Creating Dimension

Dimension consists of the elements and every element has a type associated with it.

The Element Types are -

Simple - Element at lowest level of heirarchy.
Example - Date

String - Elements have string data
Example - "Asset Category"

Consolidated - Element that define aggregated data in a cube.
Example - Year

Attributes are used to provide supporting data to an element.

Types of attributes are -

Descriptive Attributes - Element may have descriptive attribute.
Example - January may have Jan as a short name

Alias Attributes - Element have an alias for every attribute.
Example - Account ID 100023 may have Travel

Display Format Attributes - Numeric element may have format to display the numbers
Example - Number with the formatica 2 decimal places

a) Dimensions can be created either manually using a Dimension Editor or through a Process.

Creating a Dimension Manaully (using Dimension Editor)

1. In the tree pane of the Server Explorer, select Dimensions under the server name.

2. Click Dimensions and select Create New Dimension.

3. Dimension Editor -> Click Edit and select Insert Element.

4. A window will be opened Dimension Element Insert ->

Insert Element Name : Give the element name (Ex. India if the dimension is Country)
Element Type : Select Consolidated as if you want to have the group by values or Simple if it's a numeric value or String if it's a character.

Click Add and the element will be inserted in Dimension. Add all the elements in the same fashion to have a complete Dimension.

5. Click Save and name the Dimension.

b) The dimension gets created under the Dimensions Tree. Double click the dimension to see the values that you have entered.

c) In case you have many values in Dimension, this would be a difficult task to add all the elements one by one. Instead you can copy the values from outside of TM1 say from Notepad and Paste in the Dimension Editor.

d) In this case all the elements will be with Simple type, you can right on the element and say Edit Properties if you want to change.