Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OBIEE generates complex queries

813040Feb 28 2011 — edited Mar 21 2011

Hi,

Currently we are experiencing performance issues, i.e. some queries are running for a very long time. I examined these queries and it struck me that it could be caused by the complexity of the generated queries. For example, a query accessing only one facttable accessed that facttable 5 times (the queries are concatenated through the WITH statement) ! I wonder, why is this necessary? Business Objects XI does not generate such complex queries, BO XI would access that facttable only one time.
Basically my question is: which settings affect the queries generated by OBIEE? Isn't it possible to generate different, simpler queries?

TIA,

EriK

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 18 2011

Added on Feb 28 2011

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

7 comments

526 views