Rules

I was wondering if it is even possible to create a transformation rule which involves different dimensions like the following composite A#[5000-0002]:UD4#[2010]:UD2#[2412] but adding ranges to it. so instead of having 10 different TR that have the UD4 going from 2010, 2011, 2012 to 2020, have only one composite including a range for the UD4 mentioning 2010~2020. Is that possible? what would be the TR be?Thanks    

Does anyone know how to get access to the "OneStreamGatewayService" Import through a Smart Integration Function in OneStream WinApp.  I am trying to run remote business rules/ remote queries through SIC but cannot seem to find any documentation related to SIC Server assemblies needed, or BR Assemblies needed to access this Import.   See line 10 below  

Hello Community, I have a puzzler for you.  My confirmation rule is set to evaluate a data intersection.  If the intersection is greater than zero, then an annotation is required in another intersection. I have tested both of the intersections in a quick view to ensure I have identified the correct data intersection members.   When tested, the rule identifies the numeric intersection (first condition), delivers the error message,  but does not identify the annotation intersection as being present.  Below is the rule: 'Check an Account value and if it is greater than zero, request a comment be made to a Cube View under the Analysis section of this pageargs.ConfirmationRuleArgs.DisplayValue = api.Data.GetDataCell("Cb#Consol:E#" & api.Pov.Entity.Name &":T#WFPrior3:C#Local:S#Actual:V#YTD:A#9610:F#EndBalInput:O#BeforeAdj:I#None:U1#Admin:U2#Top2:U3#TLOB:U4#None:U5#None:U6#None:U7#USGAAP:U8#None").cellAmountIf args.ConfirmationRuleArgs.DisplayValue = 0 Th

I have built the "Compiste" transformation rule, the Rule is below. while executing through workflow and I am getting the below error message. any insights how to make this work out? Error: Dimension: Account, Rule Type: TransformComposite, Rule Name: ., Input Expression: A#[??????????1910], Output Expression: A169140.Syntax error: Missing operand before 'And' operator.  

Here I have my income and balance sheet. I need RE to equal account number 29500 plus Net income under the balance sheet. I also only have data for Jan 22. Do I create a stored calc, dynamic calc, formula pass, or something else? How would I do this? Thank you!  

Hi Community. I have a rule that is using DataBuffer to copy data from 1 cube to another.The cubes have seperate dimensions. I have used DataBufferConvMapItems to map individual base dimensions . But I have some doubts regarding this : Is there any sample code that helps solve this issue.? Below is the complete code. Copying Data from Sales to Finance Cube. they both use separate entity dimensions , not extended ones.Sales have an LGL hierarchy from where we need to copy data , So For Eg :E#LGL190 data needs to be copied to E#190 in Finance. The rule is triggered using a customCalculate DM JOB  where the Data unit is Of Destination Finance cube."   Dim dataBufferConvInfo As New DataBufferConversionInfo Dim dataBufferConvDimInfo As New DataBufferConvDimInfo Dim dataBufferMapItem As New DataBufferConvMapItem(DataBufferConvType.MapSourceMembersToFirstDestMember, "F#SF_EndBal","F#EndBal", 1) dataBufferConvDimInfo.MapItems.add(dataBufferMapItem)

Hi All, We have multiple Profiles under a workflow and each profile contains multiple forms in it. While executing the business rule through the button from workflow dashboard, It is just completing that particular workflow with forms but not the other workflows which consists of multiple forms. Below is the code using to complete the workflow. Is there a solution for this issue. Dim selectionChangedTaskResult As New XFSelectionChangedTaskResult()Dim wfProfile As String = BRApi.Workflow.Metadata.GetProfile(si, si.WorkflowClusterPk.ProfileKey).NameDim scenario As String = ScenarioDimHelper.GetNameFromID(si, si.WorkflowClusterPk.ScenarioKey)Dim time As String = BRApi.Finance.Time.GetNameFromId(si, si.WorkflowClusterPk.TimeKey)Dim wfClusterPK As WorkflowUnitClusterPk = BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, wfProfile, scenario, time)BRApi.Workflow.Status.SetWorkflowStatus(si,wfClusterPK, StepClassificationTypes.Certify, WorkflowStatusTypes.Completed, "Auto completing Forms","

Client has a need to do USD overrides for specific accounts in the Balance Sheet and the entire P&L. The below code was working fine in prior periods for historical data from a flat file. Now we are importing from SAP, and it works for the Balance Sheet no problem, but the code to populate the Forms member in the P&L doesn't work, and even though I'm calling all base members, the Override calculation only works on some accounts. I should mention the account dimension is extended. Not sure why it worked before but does not any longer. Here is the relevant code. You'll notice both sections are set up similarly. 'Move the entered Local Override amount To the USD consolidation member To override the prior period's roll forward api.Data.Calculate("F#USD_HO_Input:C#USD:O#Forms:U1#Input_HO" & udFix & " = Eval(F#USD_HO_Input:C#Local:O#BeforeAdj:U1#Input_HO" & udFix & ")", "A#BAL8A8B.Base.Where(text2 contains FX_Fixed)",,,,,,,,,,,, AddressOf OnEvalDataBuffer ) 'Ca

  How can we reference substitution variables like |CVYear| in a Business Rule?  These variables are great for Cube Views, but now I'd like to access it directly in a Business Rule (custom calculate).   Dim ExampleCVYearDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula( "T#[CVYear]" ) Error processing Data Management Step 'Enrollment'. Unable to execute Business Rule 'zzzAdjRevenueDriverValue'. Invalid script 'T#[CVYear]' near 'CVYear'.   Dim ExampleCVYearDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula( "T#[|CVYear|]" ) Error processing Data Management Step 'Enrollment'. Unable to execute Business Rule 'zzzAdjRevenueDriverValue'. Invalid script 'T#[|CVYear|]' near '|CVYear|'.   At a minimum I'd like to know how to print the contents of the variable CVYear to the log. api.LogMessage("Value of |CVYear| " & BRApi.Dashboards.Parameters.GetLiteralParameterValue(api.SI, True, "CVYear") ) api.LogMessage("Value of |CVYear| " & BRApi.Da

I am building a Dashboard XFBR String to return a different Origin member depending on whether the time is before or after 2020. If the time is equal to or prior to 2020, it returns "Top". If the time is 2021 or newer, it returns "BeforeElim". The time is selected by a parameter when the user launches a cube view. The issue I am facing is using multiple time periods in a report. I need one time column to return 2020M12, and another column to return 2021M1. This is pulled as T#FirstPeriodInYearPrior1(|!TimeParameter!|) and T#|!TimeParameter!|, respectively. My XFBR can read |!TimeParameter!| but not the time function result.  Typically, I would use Time = parameter, but if I do that it cannot return two different results for the 2020 and 2021 time periods. CVTime does not work here either as I'm specifying the time in the member filters instead of the POV. MFTime gives an error if I try to use it..  Any help is appreciated. I am not sure how to make the XFBR acknowledge the ti

Hello.  I am a total rookie with dashboards, and am failing miserably at trying to tweak one for the first time.  OneStream has an existing dashboard for RCM; there is a chart called cht_ReconPreparationStatus_RCM that I want to use, but instead of the entity being populated from the WF Profile, I want the user to be able to choose the entity in a combo box.  I have created a combo box, and I have created an entity parameter for the combo box.  But I'm just kind of lost as to what settings I need to change.  I also assume this needs to be tweaked in the business rule, but I have tried a million different options and can't come up with it. I feel like this should be an easy one, but I clearly still have a lot to learn!    Combo Box settings (ParamBarEntity is my new parameters i created.  And the Dashboard 3a_scorecard is just a copy of OneStreams 3a_scorecard_RCM that already exists) ParamBarEntity - my new parameter Data Adapter: cht_Reco

Hi, Can someone suggest if the text file can be converted into xml file via business rule?

Hi, I need to copy data between 2 cubes . they both use different Entity Dimensions . Not Extended ones.so is there any way I can map the entities . I am using customcalculate DM with the Destination Data Units  to run finance rule. I have given the Source Entity and destination Entity in the Corresponding DataBuffers. But when I give  api.Data.ConvertDataBuffer("sourceCube","SourceScenario", databufferConvInfo, sourceDataBuffer). I am getting Error Saying "the Cube and Entity Are invalid or Incompatible". What is the issue ? Thanks.

Hi Community, I have a rule that is using DataBuffer to copy data from 1 cube to another. The 2 cubes use separate Flow Dimensions . right now I have given in the following way : Is there any way I can give individual mappings of the base members instead of copying parent data. For example :Suppose BGBAL and EBAL are base members of F#SF_Movement. Map F#BGBAL in source Dimension to  F#BegBal in Destination Map #EBAL in Source Dimension to  F#EndBal. in Destination Is such data mapping possible ?. Thanks for the help.  

Dear Community Members,I have cloned the Blueprint OSB_CustomTranslate to apply code when FunctionType FxRate fires. My cube is set to Standard Using Business Rules for FxRates.My business rule is set as Business Rule 1 (and 2 as a matter of fact for logging purposes only).I am running Translate, Custom Translate, Consolidate, ForceConsolidate but i cannot get the FXRate FunctionType to fire.  I am logging in the rule to get a log message for every different FunctionType that fires.  Getting Calculate but not FXRate.Any tips would be much appreciated.  I am sure the resolution will be utterly embarassing but i am at the end of my wits.

Hi, I am trying to build C# finance BR where scenario is being pulled from POV but how to use in api.data.calculate function. If its VB then I can use with & but C# its not working.

Hi, Has anyone updated and added new member in metadata by using extender rule by picking the member information from SQL table or any other data warehouse? Table contains most of the information related member in OneStream and their member properties. If anyone has done similar kind of implementation, please let me know. Thanks.

I'm able to extract the monthly csv files uploaded using BRAPi.Import.Data.ExportStageArchives, but this doesn't seem to work for multiperiod uploads (specifically budget) or I'm just referencing a parameter incorrectly. I've tried entering the time parameter as "2021", "2021M12", "2021M1", even "2021M1-2021M12" within the business rule, but nothing is exported at all for the Budget scenario.... Any ideas?  

Hello, I have connection string written to connect to SAP Dim r3Conn As R3Connection = BRApi.Database.CreateSAPConnection(si, "ConnectionName", True) I want to know where the ConnectionName is confirgured.  I have the error massage which is pointing to IP which is not in our network.  Unable to execute Business Rule 'SAP_TB_ALL'. RfcOpenEx failed(RFC_ERROR_COMMUNICATION): SAP_CMINIT3 : rc=20 > Connect to SAP gateway failedConnect_PM  GWHOST=10.4.16.9, GWSERV=sapgw00, SYSNR=00   LOCATION    CPIC (TCP/IP) on local hostERROR       partner '10.4.16.9:3300' not reachedTIME        Tue Jul 09 12:38:29 202RELEASE     701COMPONENT   NI (network interface)VERSION     38RC          -10MODULE      nixxi.cppLINE        2845DETAIL  &nbs

Hi OS Experts: While I am running the ForceConsolidation in cube view, I am getting the below error message. Are there any possibilities of this error: Error calculating member 'EndBal_Calc' in dimension 'Flows'. Unable to execute formula for member 'EndBal_Calc'. Invalid script 'A#NET:F#EndBal:V#YTD:O#Top:I#Top:U1#USACAP:U2#TOT_DEPT:U3#TOT_PROJ:U8#None:E#' near 'E# I am checking the EndBal_Calc in flow dimension the calculation has been working from many years correctly but this time the strange issue. any suggestion. I see the similar error for the different entities' different runs.

Hi All,   I get an the following error message: Invalid calculation script. A comma was expected after ABN.With the Syntax as show below: What am i doing wrong? Both names exist in the rows of the report.  

Is there a way to save entries in Cell Details using a business rule?

Hi All: I have ran the workflow to copy the Actuals to Forecast and the data got copied over successfully. while validating the balance sheet for the certain IC plug accounts, Etiquity accounts the data is not matching Actuals versus Forecast. For example, the below.   I narrow down to the issue, I can see that the difference coming from historical override adjustment and beginning balance. I am not quite sure how to narrow down further to fix this issue, any leads/suggestion to check on this to fix?    

Hi Everyone. What I want to do is to obtain the child entities of an element, to save them in a variable and compare them with the entities that are traversed in a data management, I would like to know how I can do this in addition to how I can get in a BR the value of an intersection, as if it were in excel. Example the childrens of this.  

I have SIC version 8.2.1 I already created the gateway and is online, is a Direct connect type configured to connect with SAP I already install the SAP dll in the SIC local When I try to compile my SIF in the Onestream App asks me for the Gateway, but I can't see my direct connect gateway, only shows the Database Gateway What I'm doing wrong?   Regards