Can you dynamically create MUN's in a CA report using a TM1 cube?

[cogdevadmin1937]

Hello,

I have a report I need to re-create in Cognos Analytics from Excel, that uses a TM1 cube as a data source. Hopefully the screen shot I've included help explain things to the fullest.

I'm running into an issue because the report is going to use 4 different hierarchies within the Time dimension, all with different MUN's. The requirement is the user will choose a Month and Year from a value prompt, take March 2025 for example, and March 2025 needs to be passed to the 4 different hierarchies within the Time dimension. If the user chose April 2024 in the value prompt, April 2024 would need to be passed to the different hierarchies, etc./etc.

Is is possible to create these MUN's in the screen shot based off the value prompt selection?

Thank You in advance.

Mike

[MFGF]

Hello,

I have a report I need to re-create in Cognos Analytics from Excel, that uses a TM1 cube as a data source. Hopefully the screen shot I've included help explain things to the fullest.

I'm running into an issue because the report is going to use 4 different hierarchies within the Time dimension, all with different MUN's. The requirement is the user will choose a Month and Year from a value prompt, take March 2025 for example, and March 2025 needs to be passed to the 4 different hierarchies within the Time dimension. If the user chose April 2024 in the value prompt, April 2024 would need to be passed to the different hierarchies, etc./etc.

Is is possible to create these MUN's in the screen shot based off the value prompt selection?

Thank You in advance.

Mike

Hi,

It depends what your prompt is returning. If it's a full MUN from a different hierarchy, you would have some work to do in order to strip out the relevant Month and Year to insert into new MUNS. If it's returning string values for Month and Year, it would be fairly straightforward to insert these into the MUNs you require. All of this would be done within macros in items in the report, and it would make sense for each macro to reference the parameter(s) for month and year using prompt macros. Most of the MUN would be literal values around this, eg

#'[Income Statement New].[Time].[Time]->[TMR].[Time].[Time].[' + prompt('YearMonthParameter','token','202503') + ' QTD]'#

In the above, the prompt macro references the parameter as the first argument (so use whatever parameter name you need), the data type returned as the second argument, and a default value for the parameter as the third argument.

Hope this gives you a nudge in the right direction.

Cheers!

MF.