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