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

Manually
Using Turbo Integrator Process
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.

1.What we will create

We’ll create 2 dimensions.

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

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.

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.

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.

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)

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

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.

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.

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

612