Package Level Drill Through slicer to filter any part of a dimension

[maxchuie]

Hello
I have been given the task to do Package Level Drill Through is there a slicer that I can use to filter any part of a dimension based on what a user might select for that dimension?

[MFGF]

Hello
I have been given the task to do Package Level Drill Through is there a slicer that I can use to filter any part of a dimension based on what a user might select for that dimension?

I removed your duplicate post - please don't post the same topic in multiple places in future. Someone might spend time trying to answer in one board when it has already been solved in another, and people don't appreciate having their time wasted in that way.

To define a slicer allowing members from any level to be chosen, drag a slicer member set into the Slicer Filter section of your query, and code the expression as:

[Your hierarchy] -> ?Your Parameter?

This will allow a single member to be passed (which I assume is what you need). If by some chance you need to be able to handle multiple members selected, code the expression as

set([Your hierarchy] -> ?Your Parameter?)

Cheers!

MF.

[maxchuie]

MFGF thanks
will this work as well

#promptmany('p_prompt','memberuniquename','source.dimension.hierarchy.level')#