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:
- Start Infor BI OLAP Administration
- Add the Scenario members using integers for their names.
- Save the dimension.
- Open the dimension in the dimension browser and view the Attribute Table 1.
- Select the scenario and specify the member caption in the MemberName attribute field.
- Save and close the dimension window.
- In OLAP Administration, select the cube and click the toolbar button.
- Add a new rule for each scenario member that you added. Specify the rule above replacing the element name.
- For Affected cells, select .
- Click .
- Click .