Show TOC

Function documentationMaintenance of Dimension Members Locate this document in the navigation structure

 

You maintain dimension members by adding and modifying members within a particular dimension. You add members to dimensions based on your business needs. For example, your company may open a new office, and the financial information of that office must be part of the Entity, Category, and Currency dimensions.

Features

Dimension Member Template (or sheet)

For each dimension in the dimension library, there is a dimension member template, or, what is frequently called a member sheet (which is short for worksheet). The member sheet is a Microsoft Excel worksheet that you modify using native Excel functionality.

Here are some guidelines for using the member sheet:

  • You must not change the name of the first worksheet from Member, or it does not work correctly.

  • You can save the member sheet on the server, and when processing a dimension, you can use an open member sheet or the member sheet saved on the server.

  • You must customize the template with the members used in your business processes. For example, when starting from the sample application set ApShell and editing a member sheet for the first time, you must delete any sample members using Excel functionality. Then add members using the process defined below.

  • Based on the dimension type, the template contains a set of predefined properties. You can add new properties, as desired.

  • You can assign dimension formulas that calculate and store information based on member values.

Adding members to dimensions

You can add a single member or multiple members to a dimension. Typically, when setting up your system, you load bulk members into a dimension by entering the master data from an existing source. For example, using Excel, you can open an existing spreadsheet, then copy and paste the members from the source file to the member sheet. With subsequent additions, you can type a member and its properties in the appropriate row.

You can add members to dimensions within an application set by choosing Dimension Library within the Admin Console. Select the dimension for which you want to add a member, then choose Maintain dimension members. In the first empty row (or you can insert a row in the middle of the sheet), enter the name of the member and properties in the appropriate columns, or paste the contents of the clipboard into the sheet. After you have entered the desired members, choose Process Dimension. Be sure to choose Process members from member sheet.

Note Note

If you make changes to any rules in the dimension, such as adding a new formula, you must validate and save those rules, and process the dimension.

You can also add members to dimensions in bulk using packages and process chains within Data Manager. For more information, see Data Management for the NetWeaver platform or Data Management for the Microsoft platform.

End of the note.

Caution Caution

You cannot rename dimension member IDs.

End of the caution.