Creating Dimensions in Cognos TM1

Creating Dimensions in TM1
 There are 3 ways to create Dimensions
          a. Manually Insert Elements & Dimension
          b. Excel / Copy Paste method
          c. Through TM1 Turbointegrator Process (TI)

Let's create Dimensions in TM1.
Steps (a- Manually Insert Elements & Dimension):
Open the BDCS Data Server
1. Right Click on Dimensions and select New Dimensions
2.  It opens up a Dimensions Editor -
(It is an interface to create or order/reorder the Elements of the Dimensions

3. Click on Edit > Click on Insert Element
4. Set 3 Facts,  as shown
        a. Unit Sales Prices
        b. Unit Cost
        c. Margin
5. Save and Give a Name to Dimension as Sales_Measures
6. Again Click on Edit -> Click on Insert Element
7. Set 2 Elements
    a. Budget Versions 1
    b. Budget Versions 2
8. Save and Give a Name to Dimension as Versions


Steps (b- using Dimension Worksheets Excel / Copy Paste method):
 Open the BDCS Data Server
1. Right Click on Dimensions and select New Dimensions
2. From Excel Sheet, Notepad etc. Copy the Elements (Jan, Feb… Dec) and Paste it in Dimension Editor
3. Create Five New Elements
     i. Qtr1
     ii. Qtr2
     iii. Qtr3
     iv. Qtr4
     v. Total Year

4. Select the first three months. Drag and drop them in Qtr1. Click on Set Dimensions Order.
5. Click Qtr1 and 3 children of Qtr1 and drop it under Total Year. Click on Set Dimensions Order.
6. Repeat the above two steps for the remaining Qtrs
7. Save the Dimensions as Months
8. Dont forget to Click on Set Dimensions Order *****

FOLLOW NEXT POST FOR TM1 Turbointegrator Process (TI)

SO THATS IT......