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!

Filter Repeating Twice

SYedururJul 17 2013 — edited Jul 17 2013

Hi,

I am facing the below issue in OBIEE 11g. I have a join between 2 tables with tdsnum=tdsnum as you can see below.When i try to apply report filter on TdsNum,I can see 2 filters (one on fact and another on Dimension) in the query generated by obiee.This is causing my report to run very slow.How can i resolve this issue?

select distinct T2812.TDS_NUM as c1, T77753.TDS_NUM as c2

from ORG_DIM T2812, SUMMARY_FACT T77753

where ( T2812.TDS_NUM = T77753.TDS_NUM and T2812.TDS_NUM = 7 and T77753.TDS_NUM = 7 ) order by c1, c2

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 14 2013

Added on Jul 17 2013

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

4 comments

520 views