Setting user-defined calculation order and formatting for a calculated member

To change calculation order and formatting settings for a calculated member in a hierarchy report:

1. Right-click an element in the grid and select Calculated Member.
2. Click Pass-through Options.
3. Depending upon your MDX source, set the following options:

For Microsoft Analysis Services:

• Solve Order: The order in which the calculated member will be solved in cases where a calculated member references another calculated member.

  • Default Value: 0

  • Possible Values: Any integer between -8181 to 65535.

    It is recommended that only values 0 or greater be used, since some negative values are reserved by the system.

• Scope Isolation: Used to execute session or query-scoped calculated members before certain calculations in the cube. Neither the Aggregate function nor the VisualTotals function are applicable.

  • Default Value: NULL
  • Possible Values: CUBE

• Format String: A Microsoft Office style format string that the client application can use when displaying cell values. Click here for more on this setting.

For Oracle Essbase:

• Solve Order: You can specify the order in which the members are calculated.
  • Default Value: 0
  • Possible Values: Any integet between 0 and 127.