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