cbriscoe
10 months agoContributor
VB.NET Rules - For Better Performance
Api.Data.Calculate(“A#28100=A#69000”)
What is wrong with writing a calculation like this? Tips.
A#28100 might contain thousands of cells.
Calculation MAY work but will damage performance.
Defining more dimensions reduces the number of cells that need to be processed.
A#28100 = 10 Flow x 1 IC(None) x 3 Origin x 10 UD1 x 20 UD2 x UD3 x UD4 etc
Defining more Dimensions reduces the number of cells OneStream has to process.
Write the rule as follows:
To learn more see GES - Level 2: Financial Model Rules Course
Level2-Rules.pdf (hubspotusercontent30.net)