Reporting from TM1 – Part4 : Prompt Macro

Let’s go on with the TM1 reporting;

You will definitely need some knowledge about Cognos macros while working with TM1 cubes. A full list of Cognos macro commands can be found in the official documentation, so I just want to focus on practical examples here.

When you need to use more than one TM1 cubes in your report and you have a prompt in your report then you already have a problem: TM1 cubes structurally use shared (conformed) dimensions but that is absolutely meaningless for Cognos BI. For Cognos BI they are just different dimensions.  

So if you have a month prompt in your report you have the problem of filtering two different TM1 cubes with one prompt. At this point you may get some help from Cognos macros; instead of a traditional prompt-filter definition try to  use a prompt macro in your report:

# substitute (  ‘Profit and Loss’ ,’KPI’, prompt (‘Month’, ‘MUN’))     #

In this case we based our macro on the time dimension of ‘Profit and Loss’ cube by the prompt macro. And use it in the related queries. On the other hand we can modify the returning result –MUN- in order to use it in the KPI cube related queries. Substitute command simply substitutes  ‘Profit and Loss’  with the word ‘KPI’.


Tags: , , ,

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: