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

How to Resolve TM1 Alias to Element Name in CA?

Started by jv_oz, 27 Jan 2020 08:22:19 PM

Previous topic - Next topic

jv_oz

Hi everyone,

I have a report over a TM1 cube. In the cube is a Year dimension with an alias called "Relative Year". In this alias against the element "2020" is the text "Reporting Year". Next year it will change so that "Reporting Year" is against "2021" etc.

In CA 11.1, I can prompt to return the alias using the expression "[GL].[Year].[Year].[Relative Year]". This returns as the parameter pYear.

In the report, I want to show "2020", not "Reporting Year".

How do I convert "Reporting Year" back to the source element "2020" please?

Thanks

John