Rules

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

Hello - I'm looking for a formula to calculate data from one entity to another for two specific accounts. I would just use a standard data management job for this since the amounts are not changing, however I want the sign to change, so the amounts will net to zero when the entities are consolidated in the same structure. Can I use api.data.calculate for this? And if so, would the formula be stored on the two accounts? 

Hello All,We are having a requirement where we need to export Dynamic Calc members through FDX. We have few dynamic accounts which are complex and it refers to different time periods like (T#POVPrior, T#2023, T#2022). So whenever we run the export, it generates a very huge amount of error logs , 1 Million, referring to the T# Summary: Error processing script '((Divide(A#ABC:U8#Sample,A#DEF:U8#None))*100)'. Unable to execute formula for member 'ABC'. Invalid script 'A#DEF:I#Top:T#LastActualPeriod- A#IJK:V#YTD' near 'T#'Here LastActualPeriod will be calculated based on current actual period, Example T#2022M1Any idea why this happens and any alternate ideas to come out of this and export the Dyn Calc Accounts.Thanks in advance for your help !

Dear OneStream Experts: Thank you so much for the great help in the past. I am converting one Hyperion Planning application to OneStream application and would like to know how to use if statement to check calculation flag. For example: I have 3 dimensions Account dimension has the following 3 members Sales Rebate Rebate_Flag UD1 - Product Dimension has many Members TOTAL_Product  Parent member with children(Product_1,Product_2,Product_3,,,,,,Product_N). No_Product UD2 - Country of Sale Dimension has one parent member ALL_Country and 2 children members ALL_Country   USA   Canada In Hyperion application, I have Rebate_Flag->USA->No_Product =1 Rebate_Flag->Canada->No_Product =2 I want to calculate Rebate only when Rebate_Flag=1. In OneStream, I want to do api.Data.Calculation("A#Rebate=A#Sales * 0.10", "UD1#Total_Product.base",true) But how to I apply the if logic. In Hyperion, I can do Fix(@Relative("All_Country",0),@Relative("TOTAL_Product",0)) If("Rebate_Flag