How to apply filters in DMR reporting

[ajaju30]

Hi,

I have multiple multi-select prompts on my prompt page. Similar to relational authoring where filters can be added in detail filter section, I was looking for how to apply filters in DMR Reporting...I came across slicer member set and tried to apply the same thing but it did not work.My prompts have default 'All' selection.

e.g prompt Country : parameter name p_country
set([level] or [hierarchy]->?p_country?). But my data is not getting filtered based on user selection.

Highly appreciate all your inputs.

Thanks!

Aarti

[IceTea]

Just go for detail filters. It's very ok in DMR reporting.

[MFGF]

Hi,

I have multiple multi-select prompts on my prompt page. Similar to relational authoring where filters can be added in detail filter section, I was looking for how to apply filters in DMR Reporting...I came across slicer member set and tried to apply the same thing but it did not work.My prompts have default 'All' selection.

e.g prompt Country : parameter name p_country
set([level] or [hierarchy]->?p_country?). But my data is not getting filtered based on user selection.

Highly appreciate all your inputs.

Thanks!

Aarti

Hi,

Can you elaborate on *exactly* what you mean by "my data is not getting filtered based on user selection"? If you mean the members displayed in the rows and columns are the same, then this is entirely correct - slicers affect only the measure values. If you mean the measure values don't change, then this is puzzling - they ought to, and we need to investigate why they don't

To get your prompts to drive the members displayed on the row/column edges, you need to use calculated items in the rows/columns that link back to your prompt parameter

eg if you have a prompt based on Product Line, you could show the selected Product Line member(s) in your crosstab by including a calculation with the expression

[your product line level] -> ?Your Product Line parameter?

or

set([your product line level] -> ?Your Product Line parameter?)

The first expression would support selection of a single member, whereas the second would support selecting multiple members.

Cheers!

MF.