Stored calculations run based on the Data Unit POV. The Data Unit Dimension consists of Cube, Entity, Parent, Consolidation, Time, and Scenario.
Because stored calculations run off Data Unit Dimensions, these Dimensions are used as part of If Statements to execute calculations on conditions. The Data Unit Dimensions should not be used as destination data buffers, and should not be used on the left hand side of the equation in a api.Data.Calculate formula.
Account related Dimensions such as Account, Flow, and UD’s are not available at run-time of the calculations. Therefore, they cannot be used in the If Statements for stored calculations. However, they are available for Dynamic Calculations.
Run for POV and Check Member Names for Data Unit Dimensions Before Executing Calculation:
-
If api.Pov.Cube.Name.XFEqualsIgnoreCase("CubeName") Then
-
If api.Pov.Entity.Name.XFEqualsIgnoreCase("EntityName") Then
-
If api.Pov.Scenario.Name.XFEqualsIgnoreCase("ScenarioName") Then
-
If api.Pov.Cons.Name.XFEqualsIgnoreCase("USD") Then
