Defining a calculated member

You define calculated members in the expression editor using dimensional constructs and functions. You can define a calculated member based on a calculated member.

Calculated members are added to the member tree as a children of the parent member. You identify the parent member by selecting a member from the member tree under the Members folder of a hierarchy.

If there is no ALL member, the calculated member does not have to have a parent defined. The calculated member then becomes a member of the root level. If there is an ALL member, the calculated member must have a named parent and if one is not specified, the calculated member will fail to load. The failure is recorded in the log file.

It is a good practice to use a naming convention so that you and your report users can easily identify calculated members.

Procedure

  1. From the Project Explorer, click a dimension and expand it.
  2. Right-click a hierarchy that belongs to the dimension and select Open Editor.
  3. Expand the hierarchy to access the Members folder.
  4. Expand the member tree until you can view the member you wish to define as the parent of your new calculated member.
  5. Select the Calculated Members tab.
  6. Click New Calculated Member new calculated member icon.
  7. Select the new calculated member.
  8. To set the Parent Member on the Properties pane, drag a member from the member tree in the Project Explorer.
    This property specifies the position of the calculated member in the member tree.
  9. From the Properties pane, define the calculated member in the Expression property.
    • To use an object from the project, drag the item from the Project Explorer into the expression.
    • To use a calculated member, drag the calculated member from the member tree.
    • To add functions, summaries and operators, select the Functions tab, functions tab icon to access the required elements.
  10. Right-click the Members folder of the hierarchy and select Refresh.

Results

The new calculated member is displayed under the Calculated Members folder for the hierarchy. The calculated member can also be seen under the parent member in the Members folder of the hierarchy.