Creating a Calculated Category at the Dimension Level

When created at the dimension level, new calculated categories become siblings of the categories from which they are derived.

You can create calculated categories at the dimension level by using the Dimension property sheet, or individually at the child category level, by using the Change to Calculated Category command on the Diagram menu.

Procedure

  1. Open the property sheet for the dimension that is to contain the calculated category and click the Calculation tab.
  2. Click Add.
  3. In the Label box, enter a name for your calculated category.
  4. If you want all the calculated categories listed together in your OLAP reporting component, select the Group calculated categories together check box.
  5. Click Calculation.
  6. In the left pane of the expression editor, expand the Functions folder, select the mathematical function you want to use, and click the right-arrow button to insert it into the Expression definition box in the right pane of the editor.
    Tip: You can also double-click or click and drag the parameter to add it to the calculation.
  7. Next, expand the Levels folder and select the appropriate level for the expression.
    Tip: You can also select and drag the appropriate level from the Categories diagrammer, or lower pane of the Categories diagram, directly into your expression, and type or copy-and-paste a valid calculation. For more information, see IBM Cognos Transformer Expression Editor.
  8. Click OK in the expression editor when you are ready to save your final expression.