Hi all,
I have a report with a prompt "Version", those are like "Winter_2015"
I need to get from "Year" dimension, the attribute matching with version's year.
The problem is I can not use in Cognos Macro, neither susbtring or dataitem reference.
I manage to replace first caracters with substitute function, but I am forced to put first part directly which I'd like to avoid:
#substitute( '\[cube\]\.\[dimension2\]\.\[Hierarchy2\]->:\[TM\]\.\[dimension2\]\.\[Hierarchy2\]\.\[@MEMBER\]\.' ; '' ;
'[cube].[dimension1].[Hierarchy1].'+ substitute( 'Winter_' ; '' ; prompt( 'pVersion' ; 'token' ) ) )#
Any idea?