Tree Prompt Fun

[kevinsalazar]

Been stuck on this one all day, and it's probably more because I'm not as familiar working with dimensional data as I'd like to be, but here goes...

I have a multi-select tree prompt displaying a merchandise hierarchy that I want to parse for selections.  It has 5 levels (brand > division > department > class > subclass).  The user, by default, then can select any and every option they want from the tree.  What I want, if possible, is a way to pass each level selected as individual parameters for use in multiple queries.

The fact that the user can select however many levels and selections are what complicates this for me, so any help out there would be appreciated.

Thanks in advance...


K

[laks]

Hey Kevin,

Did you figured how to do this. I am struck with similar problem, but in my scenario I want to pass the value selected in last level of hierarchy to another query.

Please let me know.

Thanks,
pavan

[ryan.thomas]

Are you trying to use a prompt macro or detail filter? 

If you are using a detail filter, using the 'in' statement should work for you.  However, the #promptmany('promptname','MUN')# should work for you.

Hope this helps.

RT