Level Naming Template Dialog Box
Use this dialog box to specify the level names that are displayed to end users when they browse a cube containing the dimension displayed in the dialog box title bar.
This dialog box is displayed only for parent-child dimensions. A parent-child dimension always contains a single meta data level (excluding the (All) level, if any), which typically produces multiple displayed levels. The number of displayed levels is not always known when the dimension is created or edited. Also, this number can change when the data in the dimension table is updated. For these reasons, you can use this dialog box to specify the names applied to the displayed levels.
For more information about parent-child dimensions, see Parent-Child Dimensions.
If you do not specify level names, by default the displayed levels are named Level nn where nn is an integer indicating the level's rank, starting from the top level. An exception is the (All) level, which must be named (All).
This dialog box appears when, in the tree pane of Dimension Editor or Cube Editor, you select the level in a parent-child dimension, and, in the Advanced tab of the properties pane, click Level Naming Template, and then click the edit (...) button.
After you change values in this dialog box for a shared dimension and save it, you must process it with the Incremental update option. For more information, see Updating and Rebuilding Shared Dimensions. After you change values in this dialog box for a private dimension and save the cube that contains it, you must process the cube with the Refresh data option. For more information, see Updating and Refreshing Cube Data.
Options
Level
View the displayed level names ranked from highest to lowest. By default, if the dimension's All Level property is No, only the row for Level 1 is displayed. If the dimension's All Level property is Yes, only the rows for Level 1 and Level 2 are displayed.
You can add a blank row by placing your cursor in the last row's Name column and typing a value. Each row's value in the Level column is one greater than the preceding row's. You cannot edit the Level values.
If the dimension's All Level property is Yes, the entire row for the (All) level (Level 1) is read-only because the name of the (All) level must be (All). (Some client applications do not display the (All) level's name.)
Name
View the level names displayed to end users. There are two common techniques for supplying the level names:
- In the top row (or second row if the dimension's All Level property is Yes), type a value followed by a space and asterisk (*). This technique produces names that are identical except for an incrementing, numeric suffix, which replaces the asterisk. For example, if the dimension's All Level property is No, in the top row type My Level * to apply the name My Level 01 to the top level, the name My Level 02 to the next level, and so on. Or, if the dimension's All Level property is Yes, in the second row type My Level * to apply the name My Level 02 to the level below the (All) level, the name My Level 03 to the next level, and so on.
- Add rows and type a level name in each. If the number of supplied level names is exceeded by the number of displayed levels, the last nonempty Name value along with an appended, incrementing, numeric suffix is applied to the unnamed levels. For example, if the last Name value, supplied for Level 8, is Element, the names Element 01, Element 02, and so on are applied to the unnamed levels. If the last Name value contains an asterisk, the resulting suffixes indicate each level's rank, starting from the top level. If the last Name value, supplied for Level 8, is Element *, the name Element 08 is applied to Level 8, and the names Element 09, Element 10, and so on are applied to the unnamed levels.
The Result value changes to reflect the current values in the Name column. To refresh the Result value, click anywhere in the Level or Name column except in the row where you most recently typed.
To display an asterisk in the level name, type a double asterisk (**) in the Name column.
Because semicolons (;) are used to separate level names when they are stored, it is recommended that you omit them from level names. If you type a semicolon in the Name column, it is interpreted as a level name separator.
Clear All
Click to delete all values in the Level and Name columns except the values for the (All) level, if any.
Result
View the first five level names that are displayed to end users. The names are separated by semicolons (;). The names change to reflect the values in the Name column. The semicolons and ellipses (...) are not displayed to end users.
OK
Click to temporarily save your changes and close the dialog box. To permanently save your changes, in the editor, on the File menu, click Save.