Rules

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

  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

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

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.

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?

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

Hi, does anyone have any idea on the functionality of 'Revert to Default Scenario' setting for a scenario type in the member formula? Apparently, when a calc is written in the default scenario, it gets executed for ALL scenario types regardless of whether the revert to default scenario setting is set to True or False. Any help/lead about the use of this setting is appreciated. Thanks!   JackLacava   

Hi, I have a requirement to export 2 files and then merge it into single file. While the export can be done via OOTB DM step, I wonder if we have any api or default function which can be used to merge the 2 exported files?

Hello Community, I am encountering an issue with a Data Management Sequence consisting of four steps. The first step is not executing as expected. If anyone has insights into potential causes, I would greatly appreciate your assistance. Details of the sequence are as follows: The first step is dependent on the successful completion of the second step. The first step involves executing a Business Rule (BR) that includes an Extensibility Rule. The remaining three steps are custom calculations utilizing the Finance rule type.When I run the sequence after running the 1st step separately, it is working fine. But the issue is When i try to run the Sequence which is having all 4 steps it is not working fine  Thank you in advance for your help.

Rules TIP  - ONLY write / use Rules when necessary. OneStream projects should not be a contest to see who is better at writing complex rules. If you must write rules please remember: Unless specified, the calculation will run on Base Entities AND each Parent Entity. Use these lines almost always in your rules. For Base entities only use: If Not api.entity.HasChildren Then For Parent entities only use: If api.entity.HasChildren Then For ALL entities: api.Data.Calculate(“A#Account1 = A#Account2”) There are up to 6 calculation operations in the Consolidation process per Entity. Conditional statements can be added to formulas to limit which Consolidation calculation processes will do something for this formula. For Local currency only: If Api.Cons.IsLocalCurrencyforEntity Then For Translated currency only: If api.Cons.IsForeignCurrencyForEntity Then For Parent-Child Relationship levels

I have declared CurrYear and CurrMonth to retrive year and month respectively. Dim CurrTime As String = api.Pov.Time.NameDim CurrYear As Integer = TimeDimHelper.GetSubComponentsFromName(CurrTime).YearDim CurrMonth As Integer = TimeDimHelper.GetSubComponentNameFromName(currTime).Month can you help me to retrieve month in CurrMonth? 

Hi Guys,  I'm at a project where we use Data Cell Detail, we have created classifications and added 2 lines of test data. I can find the data via a data adapter Method query: But now i want to add it via a BRApi, i've found a post here but what ever I try i cannot get it to work. I have a cube view with 2 columns and the only difference is the UD8 member, so i first want to get the current data cell POV and set UD8 to None: Dim objMbrScrBldr = New MemberScriptBuilder() 'Apply current POV to memberscript and override UD8 api.Data.ApplyDataCellPkToMemberScriptBuilder(objMbrScrBldr, api.pov.GetDataCellPk(), True, True, True, True) objMbrScrBldr.SetUD8("None") Then I call the datacell containing the amount:  'Return the sum of the DataCells that contain the selected Classification Dim objDataCell As DataCellInfoUsingMemberScript = BRApi.Finance.Data.GetDataCellUsingMemberScript(si, api.Pov.cube.name, objMbrScrBldr.GetMemberScript()) and check if the data has DataCellDetail: I

api.Data.Calculate("A#FCTR:F#EndBalanceLoad:I#None:O#Import:V#YTD:U1#00000:U2#00:U3#GL:U4#0000:U5#00:U6#00:U7#None:U8#None = A#Assets:F#EndBalance:I#Top:O#Top:V#YTD:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:U7#None:U8#None:C#Share - A#Liabilities:F#EndBalance:I#Top:O#Top:V#YTD:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:U7#None:U8#None:C#Share - A#Equity:F#EndBalance:I#Top:O#Top:V#YTD:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:U7#None:U8#None:C#Share") Error in formula: Error processing source script 'A#Assets:F#EndBalanceLoad:V#YTD:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:C#Share' or destination script 'A#FCTR:F#EndBalanceLoad:V#YTD:O#Import:I#None:U1#00000:U2#00:U3#GL:U4#0000:U5#00:U6#00'.Error processing data. The item was not found. Entity, Parent, -1.

I have the existing BR rule to export the region hierarchy which is working for last one year without any issues and I am trying to reuse the BR rule for country hierarchy export purpose. I copied & pasted the BR rules, and I am getting the error below while compling. Can you suggest what are all the possibilities to check these issues?   1) Error at line 313: Type 'SessionOptions' is not defined. 2) Error at line 315: 'Protocol' is not declared. It may be inaccessible due to its protection level. 3) Error at line 324: Type 'Session' is not defined. 4) Error at line 329: Type 'PGPLib' is not defined. 5) Error at line 338: Type 'TransferOptions' is not defined. 6) Error at line 339: Type 'TransferOperationResult' is not defined. 7) Error at line 340: 'TransferMode' is not declared. It may be inaccessible due to its protection level. 😎 Warning at line 18: Namespace or type specified in the Imports 'WinScp' doesn't contain any public member or cannot be found. Make sure the name

Hello, Is there a way to create a mapping rule for an account that looks at all entities but one?For example, A#123:E#*but E#456Thanks!

Hello every expert: I am not able to reference a different scenario member in custom calculation business rule. I tried the following api.Data.Calculate("S#Forecast=S#Actual","A#10100" ...........) in the finance business rule I created. When I run the rule through Data Management Step, I have to specify Scenario and I select Forecast, I got error S#Actual is not valid dimension member when I run the business rule through custom calculate step. I really appreciate any helps from you. Thanks in advance.

I would like to give my users the ability to launch the DM sequence from the workflow step. I have the dashboard with the button that passes the parameters to the DM package and launches the package. The last step in the DM sequence runs the Extensibility BR that completes the workflow step. Everything seems to work except that the workflow step window does not refresh after the sequence completion. The workflow step appears incomplete even though it is. The click on the "refresh Application" icon is required. Is there a way to address it? My Extensible BR is below:  

This is a doubt with the rest of the questions I have, and is that in the new workflow I created, when I hit complete worklfow there are two data management that are not executed (COPY_PLP_TO_PLN, PROCESS_PLP), which are below, but I try it in other workflows and it works correctly. Then I wanted to know how I can solve this in the new workflow, so that when I complete the workflow it also runs those data management as in the others.    

Is there any way I Can enter a +ve or -ve value based on the text property if a Flow member in a form. I think a Save Data Event Handler can, but I will throw an error if the only after the form is saved. What if the cell color will change (Just like in Excel) if the value enter on the form  should  +ve or -ve value based on the text property if a Flow member. is this achievable.   TIA, Nik

Hi Everyone. I wanted to know if there is a way to send emails that are made with parcel service automatically, for example, to send a certain number of days at a certain time, I would appreciate if you could help me to do something like that.