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,
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])'#