Hi All,
In my application I have 5 aggregate tables for 5 levels and sixth level is the fact table. I have set ChooseByVolume property to false in mondrian.properties. It works fine if data in level 1 aggregate table is less than, data in level 2 aggregate table and it is less than, data in level 3 aggregate table and it is less than, data in level 4 aggregate table and it is less than, data in level 5 aggregate table.

If data in level 1 aggregate table is greater than, data in level 2 aggregate table, then mondrian fetches data from level 2 aggregate table and aggregate that data to level 1.

But I want the data from level 1 aggregate table (even though it has more number of records than level 2 aggregate table) not from level 2 aggregate table.

Is there is any way to force Mondrian to fetch data for that level from that level aggregate table only.

Or its a restriction in Mondrian?

Thanks in advance.