Our Blog

Setting up Cognos TM1: an initial insight into the set up and architecture

By Sanjeev Datta, Senior Consultant for PerformanceG2

Are you deciding to set up TM1? Below is a list of considerations when installing a TM1 environment – an initial insight into the set up and architecture to fill your technical needs. These stats can help determine cube size, server topology and other settings for an upgrade or new TM1 install.

User Definition:

Power Users (PU)- These are TM1 users who would load data, update models and objects and create complex reports and views. Compared to the total number of users and power users, 1:1 can be considered as a close approximation (concurrent user) ration.

Read/Write Users (RWU)- These are TM1 users who would update data in a model on a regular basis. They would create and view complex reports and views. Compared to the total number of users and RW users, 3:1 can be considered as a close approximation (concurrent user) ratio.

Read Only Users (ROU)- These are TM1 users who do not input data. Instead, they only read data or use pre-defined reports in Microsoft Excel or TM1 Web and require fast data access. Compared to the total number of users and RO users, 10:1 can be considered as a close approximation (concurrent user) ratio.

Estimating RAM:

Estimating Ram

Total concurrent users = 16
RAM required: 16 x 20 (MB per user) = 320MB

Estimating Data:
In TM1, each data item loaded occupies on average 14 bytes of RAM. Each calculated item will proportionally increase the data, and adding more CPU’s will benefit readers more than TM1 users or writers.
Rule of Thumb: Per CPU, 25 power users and 100 RO users

Data– 1,000,000 rows with 12 data items in each row = 160MB
Model with 5 years of data = 801MB

Calculations– Calculations forecast is 1 year of extra data = 160MB

Users– 10 users = 10 x 12MB = 120MB

Total Model Size– 801MB + 10MB + 120MB = 1.1GB

Report Server:
In a TM1 environment, use a Report Server for the following:

    • If the RW users require fast access to static reports while data is being uploaded
    • If writers lock server to the detriment of the readers
    • If the RO user community outweighs the RW user community by a factor of 5 and there is constant RW activity on the main server
    • If the RO users request reports simultaneously and if reporting performance is important, then use Reporting Server/Multiple Processes

TM1 Web Server:
In a TM1 environment, if the majority are Web users, then consider a separate TM1 Web server. TM1 Web servers should always run on separate physical servers if possible.
Rule of Thumb: Up to 250 concurrent users per CPU

TM1 web server

Contact the Blogger

This entry was posted in Tips and tricks and tagged , , , , , , , , , , , . Bookmark the permalink.

Comments are closed.