Hi all,
I have used this as part of my filter expression.
[cube].[dimension].[hierarchy].[level] -> (#CSVIdentityName(%Parameter_name)#)
My parameter map contains 1 key-value i.e xyz therefore the above macro (#CSVIdentityName(%Parameter_name)#) returns xyz which is a string, now i am getting an error, a qe-def-0260 parsing error before or near position: 61 of: [cube].[dimension].[hierarchy].[level] -> (#CSVIdentityName(%Parameter_name)#). What would be the right way to do this?
I have to apply the filter at the cube level, is there any alternate way to cast level to a string
in the dimension explorer, look for long name under your level. It is a string representation of your dimension..
thanks, will try this.