Modifying the Unit and Variable dimensions

Strategy Management requires that member names are integers.

Consolidated members in the Unit and Variable dimensions must have a child member that holds the data. In this guide, those child members are referred to as representative members. By default, representative members have - data as a suffix. You can customize the suffix using the Plan Customization page. These members are required.

Additionally, the Parent of Representative and Representative Parent fields must be specified for these two members.

To modify a dimension:

  1. Start Infor BI OLAP Administration
  2. In Edit Dimension window, add the desired members including the representatives for any consolidated element.
  3. Save the dimension.
  4. Open the dimension in the dimension browser. Click to view Attribute Table 1.
  5. Select the parent member and click the Edit Attribute Record toolbar button.
  6. Specify the caption for the member in the MemberName attribute field.
  7. In the Representative Parent field, specify the member name for the associated representative member.
  8. Click OK.
  9. Select the representative member and click the Edit Attribute Record toolbar button.
  10. In the Representative Parent field, specify the member name for the parent.
  11. Click OK.
  12. Click Save.