We can assign own custom names to the hierarchy levels of TM1 dimension by using
}HierarchyProperties control cube.
1) This is a default control objects creates by TM1. To get this Cube click on View-> Display Control Objects.
2) The hierarchy level names get created as level000, level001, and so on. We can change them to have a proper meaning.
TM1 Dimension Level Example Named Dimesion Level
level000 All
level001 IT Accounts
level003 Admin Accounts
Congifuring Named Levels
1) In TM1 Architect, click the View menu and select Display Control Objects.
2) In the Navigation pane, expand the cubes.
3) Open }HierarchyProperties Cube. Cube opens.
4) Select the dimension for which you want to assign named levels. Click on Recalculate button.
5) In the default member cell, enter an existing element name to set as the default member for this dimension.
6) Enter the name of the top element in the dimension hierarchy to retrieve all the elements by default.
7) Enter own custom name in the level000 to level020 cells.
8) Just restart the TM1 server or Run RefreshMDxHierarchy function in TI process to get the changes.
}HierarchyProperties control cube.
1) This is a default control objects creates by TM1. To get this Cube click on View-> Display Control Objects.
2) The hierarchy level names get created as level000, level001, and so on. We can change them to have a proper meaning.
TM1 Dimension Level Example Named Dimesion Level
level000 All
level001 IT Accounts
level003 Admin Accounts
Congifuring Named Levels
1) In TM1 Architect, click the View menu and select Display Control Objects.
2) In the Navigation pane, expand the cubes.
3) Open }HierarchyProperties Cube. Cube opens.
4) Select the dimension for which you want to assign named levels. Click on Recalculate button.
5) In the default member cell, enter an existing element name to set as the default member for this dimension.
6) Enter the name of the top element in the dimension hierarchy to retrieve all the elements by default.
7) Enter own custom name in the level000 to level020 cells.
8) Just restart the TM1 server or Run RefreshMDxHierarchy function in TI process to get the changes.
No comments:
Post a Comment