If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Prompted Parameter used in Crosstab Layout

Started by jv_oz, 27 Jan 2020 07:08:42 PM

Previous topic - Next topic

jv_oz

Hi all,

I am trying to build a report from a TM1 cube. I want to use a prompted month to filter a block on a CA crosstab and have a secondary block with the YTD values.

Here is the base information:
1. In the cube has, amongst others, Year, Month, Branch, Account, Version and Measure dimensions.
2. I have a crosstab in CA, with Accounts as rows and Version (Actual, Budget, Variance etc) as columns.
3. The crosstab also includes a month ("Dec"), dragged above each column (Version) to define the month to display data for.
4. There is a prompt for the Year and Branch.

Like this, the report works fine.

Then I add a prompt for Month and want to swap out the hard-coded month ("Dec") for the prompted month and I can't seem to be able to make this work.

Firstly, can anyone please help with what I need to do here?

Then, I want to add a second block to the crosstab, to get the YTD values. In the TM1 month dimension, are the rollups to get the YTD values, with elements called, "mmm YTD" (eg "Dec YTD"). In CA I am expecting that I can use the prompt value for the month ("Dec") and concatenate it with " YTD" and then use that in the second block.

Does anyone have any tips on making this half of the report work?

Thanks in advance!

John

Andrei I

Since you are using TM1 as a datasource you have to come up with Dimensional expressions for all data items.
Most likely you should use dimensional function filter with relevant prompt macro

Check this thread for more details:
https://www.cognoise.com/index.php/topic,36344.0.html