Skip to Main Content
Forums

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!

RANK calculation in BI and not in DB once using prompt

783226Sep 26 2010 — edited Mar 2 2011
I have report which contains RANK function in the SQL query for returning only top 10 rows from DB and not all the data.

When the report is running, I see (in the session log) that the RANK function is exceuted in the DB and only 10 rows return from DB to BI level.

After I added prompt to filter some fields (WHERE in the query) I saw that the WHERE is executed in the DB,
but the RANK is calculated later in the BI.

Thus, the BI gets all rows (answering the WHERE) from DB and then takes the top 10 and displays them.


How can I save all unrequired traffic between the DB and the BI?

How can I force the RANK to be executed in the DB?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 30 2011
Added on Sep 26 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #database, #performance, #prompt
8 comments
640 views