Rules

Source:   Migrated from Champions I asked this question from OneStream staff at the Splash conference and OneStream support. I thought perhaps someone in this group has run into the same issue: The standard that appears to be used for calculating FX does not appear to be correct. It appears from the snippet that FX is calculating taking the month to date amount X month end closing rate - month to date amount X month average rate. From the Flow FX (Calculated) snippet: If (api.Cons.IsCurrency() And Not api.Cons.IsLocalCurrencyforEntity()) Then Dim timeId As Integer = api.Pov.Time.MemberPk.MemberId Dim rateTypeRev As FxRateType = api.FxRates.GetFxRateTypeForRevenueExp() Dim rateTypeClo As FxRateType = api.FxRates.GetFxRateTypeForAssetLiability() Dim closingRate As Decimal = api.FxRates.GetCalculatedFxRate(rateTypeClo,timeId) Dim averageRate As Decimal = api.FxRates.GetCalculatedFxRate(rateTypeRev,timeId) 'Calculate FX activity for current movement between Average and Closing

Hello,   I'm new to Business Rule, and I'm struggling with the execution of a data management step with type "custom calculate". Currently, the execution of this script is giving me the message below : Error processing Data Management Step 'CC_FY2022_BUD'. Unable to execute Business Rule 'CopyData'. Invalid destination data unit in script 'A#Account1:C#Local:T#2022M1:S#Budget:U1#None:U3#T:U8#None:O#Import'.   In the Data Management step, I have defined elements in the POV and Data Units, and "Data Units" elements seem to be taken into account correctly, but elements in the "POV" such as U2, U4, U5, U6, U7 elements that have been defined in the POV of data element task (hierarchy nodes) seem like is not considered in the calculation.   So here are my questions: - What is the error message mentionned above actually saying ? - Are POC elements from the Data Element task taken into account in the Finance Business Rules ? - How do you efficiently debug a Business Rule ? &nbsp

Is there a way to validate the Total Debit or Total Credit amount of a journal and send back a warning/fail message if the total is over a certain threshold when we try to post/save the journal? Thanks

Hi, I would like to retrieve the value for a text attribute of a member - could be in any any dimension - in order to display it in a label on a dashboard. Can I do so with a generic XFBR?

Hi all How can I run a calculation for a subset of dimension members. Something like all base members of member Top, but not the none member, or just the members with text1 attribute = "Calculate", or just a comma separated list of members. Do I need a for loop? Cheers

Originally posted by Brad KoteckiWe have a business rule set up that emails users once completed. To do this we used the sample under Snippets>Other>General>Send mail. Is there a way to BCC the email addresses on the email, rather than sending directly to everyone as a group?

Originally posted by Rahul Joshi I am trying refer a intersection in member formula and apply condition based on the referenced cell.     Dim nvASP As DataCell = api.Data.GetDataCell("A#[ASP (£)]:F#No_Curr:I#None:U1#[Adjustment (Override)]:U2#None:U4#None:U5#None:U6#None:U8#None") If nvASP.CellStatus.CellAmount = 0.0 Then api.Data.Calculate("F#No_Curr:O#Forms:U1#Total:U2#None:U4#None:U5#None:U6#None:U8#None:I#None:A#[ASP (£)] = F#No_Curr:O#Forms:U1#Calculated:U2#None:U4#None:U5#None:U6#None:U8#None:I#None:A#[ASP (£)]") Else api.Data.Calculate("F#No_Curr:O#Forms:U1#Total:U2#None:U4#None:U5#None:U6#None:U8#None:I#None:A#[ASP (£)] = F#No_Curr:O#Forms:U1#[Adjustment (Override)]:U2#None:U4#None:U5#None::U6#None:U8#None:I#None:A#[ASP (£)]",,,True)     It does not consider the if-else condition and just process the first condition .Something which i am doing wrong in here ?

Originally posted by Ramanathan GanapathyHello All, Currently Our Default Currency in the system is 'USD".  The system is rolling up the value correctly for the all the flow member formulas for USD.  We also defined additional currencies in the system and for that the base value is not rolling up to the parent.    Is there is any formula available for us to use for the Parent to do the aggregation instead of Translation?   Thanks & Regards, Ram

How can I use the api.LogMessage or BRApi.ErrorLog.LogMessage functions to print out the member names of a list of objects  like member, or memberinfo?

Originally posted by Yan SavinskyHow to check if time period is the last month in a quarter in the Business Rule?   Thanks in advance.   Yan Savinsky

Originally posted by Eric Osmanski 4/10/2020 What can I use to grab the WF Name, Text, anything .... WITHOUT using session info?

Originally posted by Chris Bielinski4/20/2020 Is there any way to filter out 0's when using cube math?