Detailer Filter to Slicer

[srinu_anu2007]

Hi,

How do we place the filter from detail filter to slicer.

for exa. iam using the filter in detailed filter says: caption([packagename].[Dimname].[Hierarchyname].[levelname as:Year]=?Param_year? and i want to use the same in slicers. how can i achieve this? can any one help me to get in slicer.

Thanks,

[cognostechie]

Delete the filter, go to the query and drag a slicer from the toolbox into the slicer window, insert a prompt macro in the slicer similar to this:

#prompt('Param_Year','memberuniquename','members([CubeName].[DimensionName].[Year])'#