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!

OBIEE not using join in a SQL Results driven prompt

706401Feb 15 2011 — edited Feb 17 2011
I have the following SQL in a prompt:

SELECT DW_TIME_RPS_ADD_DT.CALENDAR_YEAR_NAME FROM "IND Processing" WHERE DW_TIME_RPS_ADD_DT.DIMENSION_KEY = DW_IND_RETURN_ERROR_SUMMARY_VW.YEAR_DIMENSION_KEY

But it keeps returning all years. This shouldn't happen.

When I check the log here is the RqList:

RqList distinct
DW_TIME_RPS_ADD_DT.CALENDAR_YEAR_NAME as c1 GB,
DW_TIME_RPS_ADD_DT.CAL_YEAR_NUMBER as c2 GB
DetailFilter: DW_TIME_RPS_ADD_DT.DIMENSION_KEY = DW_IND_RETURN_ERROR_SUMMARY_VW.YEAR_DIMENSION_KEY

The actual query it is sending to the database?
select distinct T43659.CALENDAR_YEAR_NAME as c1,
T43659.CAL_YEAR_NUMBER as c2
from
DW_TIME_D T43659 /* DW_TIME_RPS_ADD_DT */

Where's the join condition? Why isn't it using it? Similar queries in other prompts work just fine. Yes I have the join defined in the RPD. Any clues?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2011
Added on Feb 15 2011
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
1 comment
241 views