Sunday, October 7, 2012

Creating Dimensions IN TM1 using Turbo Integrator Process

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

Steps (C- Through TM1 Turbointegrator Process (TI) ):
Open the BDCS Data Server
i. Click on Processes
ii. From the Panel select Data Source, Click on Text and Navigate to Product.csv file

iii. Focus on the below area of screen and confirm that v1 is Product and v2 is Product Type and v3 as All Product
iv. Click on Variable tab and rename V1 as vProducts, V2 as Product Types and v3 as Total Products
v. Select Contents as Element for Product and Consolidation for other two
vi. From the Maps Tab in the Dimensions Create a New Dimension known as Product (Products) at the end Element Order should be make as Automatic by Hierarchy
vii. Click on consolidations Tab, make Product as a Child for Product Type and make ProductType as Child for TotalProducts.
viii. Click on the advanced tabs and make sure to validate/Click on all the Tabs.
ix. Save the Process as CreateProductcsv
x. Run the Process
xi. Validate Elements in Products Dimensions
xii. Similarly Create the Channel Dimensions and Process.

SO THATS IT......

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......