Hi Guys
I have a requirement as below:
I have an organization hierarchy, in which department comes in third level.
I am having a Dept prompt(value prompt). When the report run for the first time, it should run for the first dept in my list( first in the sorted list).
I am not able to use any JS codes to accomplish this, as my report is a part of dashboard. So the first time the report should run without asking for any prompts for the first Department.
I am trying to implement this using a filter. I have the value prompt placed in prompt page of my report. default value given as 'All'
Now my filter will say.. dept in (case when (?dept?= 'All') then (head(dept level)) end) or dept=?dept?
But this throw an error.
Any clue please help..
Is this DMR or a proper cube?
DMR
DMR makes things more difficult, as it allows people to use an unholy combination of detail filters and slicers.
The dept is a multi-select prompt? Try something like this:
[dept] in #promptmany('dept','mun','head([dept level])','set(','',')')#
Get rid of the default value in the prompt.
I have few queries here.. (i am new to dimensional modeling)
what does [dept] stand for? level?
and 'dept' inside #promptmany(..) ? i assume that this is parameter name.
Exactly, I was simply converting your example filter.
Also, if you intend to use dept in the report (as opposed to simply filtering it) you can use the #promptmany(..)# expression in the data item, without using a filter at all.