Modifying the Scenario dimension

Strategy Management requires that member names are integers.

The default members for the Scenario dimension are Expected and Best Case.

Scenario members must have a rule for each member of the scenario dimension except for Scenario 0. The rule is:

"[Measure:'1', Scenario:'0', Measures:'amount']

The target is:

[Measure:'1', Scenario:'<new element>', Measures:'amount']

Replace <new element> with the new scenario member.

To modify the dimension:

  1. Start Infor BI OLAP Administration
  2. Add the Scenario members using integers for their names.
  3. Save the dimension.
  4. Open the dimension in the dimension browser and view the Attribute Table 1.
  5. Select the scenario and specify the member caption in the MemberName attribute field.
  6. Save and close the dimension window.
  7. In OLAP Administration, select the cube and click the Edit Cube Rule toolbar button.
  8. Add a new rule for each scenario member that you added. Specify the rule above replacing the element name.
  9. For Affected cells, select All cells.
  10. Click OK.
  11. Click Save.