Complex generated SQL from DMR

[backhandx]

Hi all,

I am facing a problem with a dimentional report using some dimenstional function like: tuple, aggregate...
The problem is that the report takes too long time without execution
Let me explain the context:

Suppose we have a dimension D composed with 5 hierarchies : H1, H2, H3, H4, H5. In the report I use the H1 hierarchy.
When investigating the generated SQL sent by this report to the DB I noticed that all the tables involved in the 5 hierarchies are used in the generated SQL even they are not used in the report. This makes the SQL very complex.

Can anyone have any idea ?

PS: It is a DMR.