Concept of Dimensions in Cognos TM1

Last updated on Sep 27 2021
Rahul Nair

Table of Contents

Concept of Dimensions in Cognos TM1

What are Dimensions

In TM1 there are objects to hold data. These objects are called cubes. Dimensions in TM1 are basic building blocks of cube. So, if you have an excel file which captures the grocery products’ data for different months, you’ll create one cube in TM1 to keep this data. To do that you’ll create 2 dimensions 1. Products and 2. Months to create this cube.

How to Create Dimensions

  1. Manually
  2. Using Turbo Integrator Process
  3. Using dimension work sheets

In beginner tutorial we’ll just follow the first method to create what we want.

Creating dimension with first method

Open your TM1Beginner server that we created in second tutorial. Login using Admin as ID and no password. Expand the tree to see the dimensions node.

Page 1 Image 1 43
Expand

1.What we will create

We’ll create 2 dimensions.

  1. Products
  2. Months

Products dimension will contain subsequent elements:

Total Products
Soft Drinks
Pepsi
Coca cola
Seven Up
Chocolate
Almond Joy
Amul Chocolate
Bournville
Bread
Wonder Bread
Britannia

Months dimension will have subsequent hierarchy:

FY
Q1
Jan
Feb
Mar
Q2
Apr
May
Jun
Q3
Jul
Aug
Sep
Q4
Oct
Nov
Dec

Let’s start to create these dimensions.

Let’s start to create these dimensions.

2. Insert Elements

Right click on the node and click ‘Create New Dimension’. Dimension editor will be opened for you. Go to Edit in the menu and click on Insert Element.

Page 3 Image 2 8
Insert Elements

Doing this will open Dimension element editor. You can now write your element’s name and click on Add. This will add your element to the list of newly added (but not saved yet) elements. Write ‘Total Products’ (without quotes) in the Insert element Name box and click on Add. Notice that element type is simple. This means that this element will be of numeric type.

Page 4 Image 3 7
Numeric type

Click Add and then click OK. You’ll see the Total Products element in your dimension.

Now right click on Total Products and click Insert child.

Page 5 Image 4 5
Insert child

Again, dimension element editor will be opened and you can insert immediate children of Total Products (Soft Drinks, Chocolates and Breads) from our hierarchy. Click Ok and you’ll see them as children of Total Products. Now time to insert remaining elements.

You can even copy and paste elements from an excel file. So, to test this, write all the remaining elements in an excel file. Copy them, select Total Products and paste them directly in the dimension editor. Editor will ask you where to paste the elements.

Paste Above, paste below and Paste as Child. You should select paste below. All elements will be added to the dimension.

3. Arrange Elements

Now time to move them to their designated places. Select all three beverages (Pepsi, Cocacola, Seven Up) and drag them to the Soft Drinks element. When you do that, you’ll see mouse cursor change from pointer to another pointer (as shown below)

Page 6 Image 5 4
Arrange Elements

Drop them and they will be inserted as children to that element.

Now select Chocolates (Almond Joy, Amul Chocolate, Bournville), right click on them and click Cut. Then right click on Chocolates and click ‘Paste as child’.

Page 7 Image 6 4
Paste as child’

They will be added to the chocolates element and element’s sign (which is in front of element) will change from n to ∑ (sigma). That means the element is now of type consolidation.

Insert the remaining elements like this and you’ll have your hierarchy ready. Now you’ll notice that soft drinks are not in alphabetic order. So, I need to move Cocacola above Pepsi. Just right click on cocacola and click Cut. Then right click on Pepsi and click Paste Above. The element will be inserted above Pepsi.

Page 8 Image 7 3
Cut

This is a way of moving elements in the dimension. There are many other ways of arranging dimension but we’ll discuss them in advanced tutorials.

Now click save and give name to your dimension: Products.

Page 8 Image 8 2
Products

Click on OK and OK again. You’ll see your dimension appear under dimensions node in Architect.

Now create the months dimension the same way. Just write all elements in an excel file and copy paste from there. Then arrange them in Q1, Q2, Q3, Q4 and FY.

So, this brings us to the end of blog. This Tecklearn ‘Concept of Dimensions in Cognos TM1’ blog helps you with commonly asked questions if you are looking out for a job in Cognos TM1. If you wish to learn Cognos TM1 and build a career in Business Intelligence domain, then check out our interactive, Cognos TM1 Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/cognos-tm1/

Cognos TM1 Training

About the Course

Tecklearn’s Cognos TM1 training will make you proficient in building and configuring models in Cognos TM1 using performance modeler tool. Some of the topics included in this Cognos TM1 training are creation and configuration of TM1 servers, building Cubes and Views, creating dimensions, deploying Turbo Integrator for loading and maintaining data and transferring data using scripts. etc., in working with real-time projects, and this will enable you to become a certified Cognos TM1 developer.

Why Should you take Cognos TM1 Training?

  • The Average salary for a Cognos TM1 Developer is $117,816 per annum – ZipRecruiter.com.
  • Cognos TM1 has a market share of about 11.87%.
  • Solution that is owned by Financial and Business analysts, with limited IT involvement, but consistent with IT’s governance.

Curriculum

Introduction to Cognos TM1

  • Concepts of Multi-dimensional OLAP database
  • Cognos TM1 Installation
  • TM1 Servers and Services
  • TM1 Workflow
  • TM1 User Interfaces
  • Turbo Integrator

Cognos TM1 Configuration

  • Managing TM1 Components and Tasks
  • Operations on TM1 Servers: Start, Stop and adding TM1 Servers
  • TM1 Web, Applications and Operations Console
  • Using Command prompt create or delete Desktop/Windows services
  • Hands On

Creating Dimensions

  • Manual creation of Dimensions
  • Create Product Dimensions and Measure Dimensions
  • Dynamic Subset Creation
  • Sparse and Dense Dimensions
  • Using Turbo Integrator ETL create cubes, review Cubes and Dimensions
  • Create Subset, assign Subset, Dimensional Manipulation
  • Performance Monitoring
  • Control Cubes
  • TM1 Web and Rules in TM1
  • Cube related attributes, dimension related attributes
  • Hands On

Building Cubes and Views

  • Building Cubes
  • Building Views
  • Bulk Load Mode
  • Creating Data Source through TM1 Turbo Integrator
  • Hands On

TM1 Security

  • Various security levels including Server level, Cube level, Dimension level
  • Concepts of Security in TM1
  • Creation of Client & Group and access privileges
  • Cube Level Security
  • Hands On

TM1 Data Spreading

  • TM1 Data Spreading and Recreating dimension
  • Attributes element types
  • Cube control elements
  • Dimension elements
  • Drill Assignment rules
  • Trace a feeder and feed strings
  • Hands On

Cognos TM1 Rules

  • Understanding TM1 rules
  • TM1 Rules Editor and Rules compilation using functions
  • Rule performance optimization
  • Element information rules functions
  • Cube manipulation Turbo Integrator functions
  • D-type in TM1
  • ELCOMP & ELISCOMP Functions
  • ELISPAR & ELWEIGHT Functions
  • Hands On

Advanced Scripting with Turbo Integrator

  • Advanced Scripting with Turbo Integrator
  • Deploying Dimension subsets and attributes
  • Editing procedures using scripts
  • Hands On

Advanced Modelling Techniques

  • Significance of advanced modelling
  • Manually adding objects to application design
  • Understanding application views, dimensions and hierarchy
  • Virtual cubes, Lookup cubes and spread profile cube
  • Hands On

TM1 Application Web

  • TM1 Web Applications
  • Creating TM1 Application
  • Working with TM1 Application Web
  • Snapshots in TM1 application
  • Adding MDX filters and Action button properties
  • Active forms, TM1 user and data formatting range
  • Hands On

 

 

0 responses on "Concept of Dimensions in Cognos TM1"

Leave a Message

Your email address will not be published. Required fields are marked *