BusinessObjects Board

Filter on a hierarchy

general discussion
#1

Hi,

I have a short question regarding a filter on a hierarchy.

We have a hierarchy L1, L2, L3, L4
On the Query level, we have a predefined condition to select which Level
In the report we have a table with the dimension and a measure :

Dimension Measure

L1-World 100

When we Drill Down we have
L2a-Country 50
L2b-Country 50

If the user change the Query filter to L2a-Country, table looks like :
L1-World. 50 (Which is wrong)

The users are expecting to get the table directly on the selected Level and getting :
L2a-Country 50

Thanks in advance for your help :wink:
Regards

#2

How is your measure defined?

Are all the joins in the universe set up properly, in the proper contexts?

Have you defined your @AggregateAware objects properly, with the correct incompatibilities?

Judy