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.