Cubes in TM1 hold data. They are employed for storing the data. You can create a cube with 2 or more dimensions. The cells in the cube keep the data for intersection of elements of the dimensions.

Creating Cubes

1. Create

We’ll create a cube which will store the data for different products for different months. We’ll use the dimensions that we created in previous section.

Open your TM1Beginner server that we created previously. Login using Admin as ID and no password.

Right click on Cubes node and click on Create New Cube.

The create cube box shows up. Now you can one by one select all three dimensions as shown in the subsequent screenshot. Remember to keep them in the order specified.

Now click on Properties and assign Measure as measure dimension and Months as time dimension. It’s of not much user TM1 but is done for BI. Click on OK.

Now give the cube a name (Products) and click Create Cube. Your newly created cube will show up under Cubes node in Architect. Open it. Press F9. You press F9 to load (or reload) the data in a cube. Pressing F9 will show you the data (or updated data) of that cube.

Cube will show up like this:

2. Arrange Cube

Let’s arrange it to show the data in a better way.

Drag the Products dimension over Months dimension (notice the green mark) and leave it. Doing this will swap the months dimension with Products dimension.

Similarly swap the months dimension with measure dimension so that the measures exist in page (on top), months in columns and products in rows.

Double click on Products dimension, expand all nodes and click on OK.

Similarly, double click on months dimension, expand and select only the months. Click on OK. Again, double click on months and click Show all button this time.

Click on FY, copy it (Ctrl+C) and click Cancel. Again, double click on months dimension, click Dec and paste the FY element that we just copied below Dec. Now select all elements and click OK.

Ready.Press F9 and a new view will be opened in front of you.

This is much better. Now let’s save it as our default view so that from the next time when you open a cube, this view opens.

Go to file click on Save. A save dialog opens. Check mark Default check box and uncheck Private check box. Click on Ok to save the view.

From the next time the same view will open.

Assignment

Create a new ‘Versions’ dimension which includes 3 items Actuals, Budget, NY Forecast (next year forecast)

Create a new Products cube (with name Products2) which includes 4 dimensions now: Products, Months, Versions and Measures

Arrange the cube so that Products exist in rows, Months and Measures dimensions in columns, Version and measure in pages. In months dimension, only Q1, Q2, Q3, Q4 and FY should be visible. Final layout should be like this:

So, this brings us to the end of blog. This Tecklearn ‘Cubes 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

638