Set Two-Pass Calculation Properties
The Two-Pass Calculation property can be applied to members in non hybrid mode, block storage cubes to indicate members that need to be calculated twice to produce the desired value. To obtain the correct values for two-pass members, the outline is calculated, and then members that are dependent on the calculated values of other members are recalculated.
Even though two-pass calculation is a property that you can give to any non-attribute dimension member, it works only on members of the Accounts dimension and Dynamic Calc members. If two-pass calculation is assigned to any other member, it is ignored.
Two-pass calculations are supported only on block storage cubes. Hybrid mode and aggregate storage cubes use member solve order, instead of two-pass calculation, to control when members are calculated. In hybrid mode, members tagged as two pass are assigned a solve order of 100 by default.
-
On the Applications page, expand the application.
-
From the Actions menu, to the right of the cube name, select Outline.
-
Click Edit.
-
In the outline editor, find and select the member you want to modify.
-
In the Properties pane, expand the Two-pass Calculation menu, and select True.