create levels or dimensions in a query

[john234]

We book our costs at 4 levels
Level1
   |-level2
     |- level 3
        |- level 4

Now i want to create a report at level 1, and bij clicking that level a specification at level 2 appears

I tried much playing with dimensions and members in in a query but I don't get it done.

I don't have access to the framework so i have to solve this problem in the query it self.

Can anyone explain to me, what I have to do ???


By the way : dutch is the preferred language  ;)

[nugget]

i hope i understand your problem if so the drillup/down function will be your friend.