Prompt???

[Jeka]

Hi,

I have a tree prompt for my Area dimension. (cube)
Country
      State
           City
               so on.....
If the user selects State in Prompt, can I show State in the report and if the user wants to drill-down to more detail then he can....
if it's possible What level should I insert into the report then?

Thank-you!
Nikki

[the_xxx]

Try Cascading

[Jeka]

Cascading? What am i inserting into the report for Area Dim?