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

Applying a filter/slicer for dimensional data

Started by suhas_bhat, 17 Aug 2010 05:20:14 AM

Previous topic - Next topic

suhas_bhat

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



dlafrance

in the dimension explorer, look for long name under your level. It is a string representation of your dimension..

suhas_bhat