Rules
Discuss Formulas and Business rules for your application

Forum Posts

[howto] Use "Insert Code" when posting on Forum boards

Hey guys! Just a reminder: if you're going to post code in this forum, please make it easier to read by using the "Insert/Edit Code Sample" button on the expanded formatting toolbar. Here's a short video showing how it works. If you need to edit code...

tmp.png 1c_code.gif

How to save updated data in SaveDataEventHandler

Hello OneStream Community,I am using the SaveDataEventHandler to validate a cell amount being saved. Depending on certain conditions I update the amount in the “args.NewDataCell.cellAmount” and set “args.Cancel = False”.Instead of the modified amount...

yhussien by New Contributor
  • 1026 Views
  • 3 replies
  • 0 kudos

Resolved! Create View using Extender rule

Hi All - I am trying to create a View using a Extender BR and It is compainling without any issue but when I try to execute it am getting the below error. Any help would be appreciated. Dim vSQL As New Text.StringBuilder() vSQL.AppendLine("CREATE Vie...

Kris_0-1689190843133.png
Krishna by Valued Contributor
  • 1303 Views
  • 5 replies
  • 0 kudos

Calculated Flow Dimension Drill Down

Hi everyone, I was trying to add drill down capabilities to a calculated flow dimension member but was having issues with the drill down formula. I entered the formula below but still wasn't able to drill down into the flow member at all. Does anyone...

Victoria_2-1689172243327.png Victoria_0-1689172007130.png
Victoria by New Contributor
  • 592 Views
  • 1 replies
  • 0 kudos

Is it possible to pass a parameter to a UD8 dynamic calc member?

Hi allI currently have a UD8 member to do a simple variance to actuals formula, but I was wondering if it is possible pass parameters to the UD8 member formula that this could be more dynamic? My current code looks something like this: Try 'Declare b...

MarkBird by Contributor II
  • 909 Views
  • 2 replies
  • 0 kudos