Modifying Dimensions

After creating a dimension, you can make the following modifications.

a) Add more elements.
b) Add siblings to existing elements.
c) Add children to existing elements.
d) Rearrange the hierarchy structure, such as repositioning elements within consolidations.
e) Delete elements from the dimension.
f) Delete elements from consolidations.
g) Edit element properties, such as changing the weight of an element within a consolidation.
h) Rearrange the order of elements in the dimension.

a) Adding more Elements

1) Right click on the Dimension and select Edit Dimension Structure.
2) Click Edit->Insert Element.
3) Dimension Element Insert window opens. Enter the name of the element in Insert Element Name.
4) Choose Simple in Element Type and click Add.
5) Repeat 2,3 & 4 to add more elements. After adding all the elements click Ok.

b)Adding Siblings to Existing Elements

1) Right click on the Dimension and select Edit Dimension Structure.
2) Select the element, click Edit and select Insert Sibling.
3) Dimension Element Insert window opens. Enter the name of the sibling in Insert Element Name.
4) Choose Simple in Element Type and click Add.
5) Repeat 2,3 & 4 to add more siblings. After adding all the elements click Ok.

c) Adding Children to Existing Elements

1) Right click on the Dimension and select Edit Dimension Structure.
2) Select the element for which you want to have the child, click Edit->Insert Child.
3) Dimension Element Insert window opens. Enter the name of the first child in the Insert Element Name.
4) Choose Simple in Element Type and click Add.
5) Repeat 2,3 & 4 to add more siblings. After adding all the elements click Ok.

d) Rearranging the Dimension Hierarchy

1) In the Dimension Editor, select the elements you want to move.
2) Drag and Drop the elements to their new location in the dimension hierarchy.

e) Deleting Elements from a Dimension

1) Select the elements you want to delete.
2) Click Edit, Delete Element from Consolidation or click Delete button.

f) Editing Element Properties

We can edit the element properties to assign a new weight or element type of any child.

1) Select the element in Dimension Editor.
2) Click Edit, Element Properties.
3) Dimension Element Property window opens.
4) Change the Element weight or Element type if necessary.
5) Click Ok.

g) Rearranging the order of Elements in a dimension

TM1 lets us set the order of the elements in a dimension to determine the index value for each element. The first element has an index value of 1, the second element has an index value of 2, and so on.

1) Change the order of the elements as you want them to appear in the dimension.
2) Select the elements that you want to put them in order and click on Keep. Click the Set Dimension Order button.
3) Click Dimension -> Save.
4) Click Yes to save the new dimension order.

Rearranging the order of Elements from the Server Explorer

1) Right click the dimension in the Server Explorer.
2) Click Set Elements Order.
3) The Dimension Element Ordering dialog box opens.
4) Select a Sort Type.

Automatic - Enables the Automatic Sort by options : Name, Level, and Hierarchy.
Manual - Orders elements as they currently exist in the dimension structure and sets the dimension sorting property to Manual.

5) In case of Automatic Sort -

Name - Sorts elements alphabetically.
Level - Sorts elements by hierarchy level.
Hierarchy - Sorts elements according to the dimension hierarchy.