Run the report by default for the first member in a level

[Ann]

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..

[CognosPaul]

Is this DMR or a proper cube?

[Ann]

DMR

[CognosPaul]

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:

Code Select Expand

[dept] in #promptmany('dept','mun','head([dept level])','set(','',')')#

Get rid of the default value in the prompt.

[Ann]

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.

[CognosPaul]

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.