1. Using Oracle Essbase
  2. Calculate Cubes
  3. Set Two-Pass Calculation Properties

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.

Note:

Do not use two-pass calculation with hybrid mode cubes. Only use solve order.

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. Aggregate storage cubes use member solve order, instead of two-pass calculation, to control when members are calculated.

  1. On the Applications page, open the application and then open the database (cube).
  2. Click Launch Outline.
  3. If the outline is locked, click Unlock outline Image of the Unlock outline icon in Redwood..
  4. Click Edit outline Image of the edit outline icon..
  5. In the outline editor, find and select the member you want to modify.
  6. Right-click the member and select Inspect.
  7. On the General tab, in the Two-pass calculation field, select True.
  1. On the Applications page, expand the application.
  2. From the Actions menu, to the right of the cube name, select Outline.
  3. Click Edit.
  4. In the outline editor, find and select the member you want to modify.
  5. In the Properties pane, expand the Two-pass Calculation menu, and select True.

See Setting Two-Pass Calculations.