Skip to Content
0
Former Member
Jan 17, 2006 at 06:06 PM

how to use multiple hierarchies for a single char in single query

20 Views

Hi,

Is there any way that we can use multiple hierarchies for a single char in single query. I tried and it just allows me to select one hierarchy even if I use hierarchy variable.

I have a requirement where user wants to see information related to a cost center with different cost center groups in different hierarchies (every year has different cost center group hierarchies).

Suppose I want to see information related to a cost center from year 2001-2004.in these four year cost center may have been associated to different groups depending upon that year hierarchy. How can I do that?

Thanks

Jona