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.
Create data item
Chosen Year = [Time].[Year].[Year]->?pYear?
you can already use this as a context filter or as a data item.
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.
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.