Hierarchical prompt with a filter?

[petperson]

Hi,

I have a report that includes Region, District, Store in the Report Objects window (cube).

I have a hierarchical prompt with Region -> District. What I'd like to do, is if the user chooses a Region, run the report normally. But if the user chooses a District, then I want an additional filter applied choosing only stores in the district that are currently open. I've tried adding a filter to the District attribute in the hierarchical prompt, but the filter isn't being applied in the SQL.

Any help is appreciated!

 

[coola73]

Security filter on user could do it.

 

[mizh]

how would you define the security filter?

 

[amigoser]

Hi,
what do you think of an object prompt that prompts you for two different filters ? One only with Region and the other with District (maybe filtered by Region, if you like) and you can apply a second filter within the District filter.