Cognos BI & TM1 reporting

Here I would like to list some techniques I’m using when developing IBM Cognos BI reports and using TM1 cube as datasource

1. Dimension member prompt
In the next example, I have “FIN Fiscal Period” dimension with members: Jun to Mar. I created a value prompt binded to pPeriod parameter. The prompt is populated using a query for “FIN Fiscal Period” dimension.

Now in my report query (i.e. for report crosstab) I can create a “Data Item” with the next expression:
#'[FIN FS].[FIN Fiscal Period].[FIN Fiscal Period]->:[TM].[FIN Fiscal Period].[FIN Fiscal Period].[@MEMBER].[‘+prompt(‘pPeriod’,’token’)+’]’#

Moreover, if I need to filter the entire query I can create a slicer with the same expression:
#'[FIN FS].[FIN Fiscal Period].[FIN Fiscal Period]->:[TM].[FIN Fiscal Period].[FIN Fiscal Period].[@MEMBER].[‘+prompt(‘pPeriod’,’token’)+’]’#

TO BE CONTINUED…

Recent Posts

Recent Comments

Meta

Written by:

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *