Using a Report Studio package that contains 5 TM1 cubes, I need to populate an optional value prompt from one cube and have it filter the lists displayed using the other cubes. The value prompt is using a level from the hierarchy dimension that is exactly the same in all 5 cubes with the only difference in the MUN being the cube name. This cannot be done using caption in a filter due to performance issues so a macro expression is the only option.
Environment: Windows Server 2012 R2, Single Server install, IBM Cognos BI/TM1 10.2.2 FP4
Here is my code for the macro expression that is currently not working:
#
substitute ('\[great_outdoors_sales_en].\[Years].\[Years].\[Year]',
'[sales_and_marketing].[Time].[Time].[Year]',
prompt('p_Year','memberuniquename')
)
#
I would love the answer to that one.
However, is the \ meant as an escape character? Because if so why only for the opening bracket?