Monthly Archives: April 2015

Automatically Add Formatting to a Cognos Report on a TM1 Cube

So I have my TM1 cube successfully published to Cognos BI.  I have the sort order defined so that I have my elements of my PnL appearing in the right order.  All good.  Now I look at the resulting report and there is no formatting of different elements.  Simple formatting like a single line above subtotals and a double underline below the grand total.  What accountants really want in a … Continue Reading

Sort Order of a TM1 Dimension in Cognos BI

This morning I have been working with Cognos BI over a TM1 cube.  I was frustrated that I couldn’t work out how to sort a dimension the way I wanted it.  For example, in TM1 I have a PnL dimension and is viewed normally with Net Profit after Tax at the bottom, Tax Expense just up from it, Net Profit before Tax above that and then all the way up … Continue Reading

Add a TM1 cube to BI in Cognos Express

This is quite easy. Just go to Cognos Express Manager (http://servername:19300/cognos_express/manager/), click on Data, Select the Data Source Type as TM1, then enter the name you want to call it in BI, the servername as the Administration Host, the TM1 server name (“CXMD”), the TM1 cube name you want to add to BI and finally the namespace (“CognosExpress”).    

Using TM1 Aliases in Cognos BI

Often we build a TM1 dimension using codes or ID’s from another system.  For example Product ID’s or Customer Codes.  These are not particularly usable to most people, so we then usually create Aliases in TM1 as well.  Those aliases are visible through in Cognos BI.  Therefore when defining a dimension in TM1 when it is likely that it will be used in Cognos BI, also add an alias with … Continue Reading

Setting Up Level Names in TM1 for use in Cognos BI

I am in the middle of setting TM1 up for use with Cognos BI.  One of the things I like in BI is being able to present levels with business names rather than just level numbers.  To define these level names, open the control cube }HierarchyProperties and then orient it so that dimensions are listed as rows and HierarchyProperties are columns.  Then enter the default Member and the names to describe … Continue Reading

DatasourceNameForServer and DatasourceNameForClient TM1 Functions: Use and Syntax

Ever wondered how you can vary the data source for a Turbo Integrator process inside the actual process so it becomes dynamic? Well here is a method. Firstly, define a bunch of variables: sCurrentMonth = CellGetS ( ‘System Assumptions’, ‘No Year’, ‘No Month’, ‘Current Month’, ‘String’ ); sFileDir = ‘\\servername\folder\’; sFileName = sCurrentMonth | ‘ ‘ | SUBST(sCurrentYear,3,2) | ‘ Employees.csv’; sFilePath = sFileDir | sFileName; Then use DatasourceNameForServer and DatasourceNameForClient to … Continue Reading

How to Create a New TM1 Server (Model)

Here are the instructions for setting up a new TM1 server (sometimes also known as a TM1 model). This can also be used for taking a copied TM1 model and setting it up on a new physical server.  The steps are: Copy the tm1s.cfg file from an existing model Change the ServerName, PortNumber, LoggingDirectory, and DatabaseDirectory within the copied tm1s.cfg to the name and location of the new server (model). Create a … Continue Reading

How to Enable the TM1 Excel Addin and TM1 Perspectives Ribbon in Excel

I recently started working with a new PC and it did not have the TM1 Excel Perspectives add-in enabled and obviously I therefore did not have the TM1 Perspectives Ribbon included in Excel. So I thought I would do a quick blog about how to enable it. What this does is then automatically add the Perspectives addin to Excel on your PC so that TM1 automatically opens each time you … Continue Reading