How to filter a dmr based report?

[suhas_bhat]

Hi All,
    I need to filter members in a certain hierarchy based on values coming in from the prompt page.
Prompt page is using a simple drop down that is populated by the member calendar year that belongs to level year within date dimension.

How do i pass this value to my report query?
I tried a simple calendar year -> ?p_year?

Can anyone show me the right way to add filter/slice on a DMR package.

This DMR was created in FM itself.

[Francis aka khayman]

Create data item

Chosen Year = [Time].[Year].[Year]->?pYear?

you can already use this as a context filter or as a data item.

[suhas_bhat]

Thans khayman, but i do not know why that was not working.

I've tried this now and it works.
#promptmany('p_year','memberuniquename','[Presentation Layer].[hierarchy].[dimension].[level)]','set(', '', ')')#

The prompt has to also be populated by the level itself.

[Francis aka khayman]

now that you mentioned it, for multiple value prompt....

set([dimension].[hierarcy].[level]->?manyvalueprompts?)

was not returning the proper calculations in one of our reports. it was changed to the one you posted and it worked fine.