obiee query design — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

obiee query design

Received Response
1
Views
2
Comments
3193829
3193829 Rank 5 - Community Champion

Hi All,

I have report which the below BMM. and the query generated is below..

WITH SAWITH0 AS

(

  fact1

)

WITH SAWITH1 AS

(

  fact2

)

select....

FROM SAWITH0 D1

LEFT OUTER JOIN SAWITH1 D2

I need to change LEFT OUTER to right OUTER for my report to work. but this is generated by OBIEE itself. Can this be designed in the RPD?

Capture.JPG

Thanks & Regards,

K

Answers

  • AkanshAgarwal
    AkanshAgarwal Rank 4 - Community Specialist

    Hi,

    You can change the join in the BMM Layer between the two tables.

    join.png

    Regards,

    Akansh

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Yes you can:

    pastedImage_2.png

    Watch out with your example though. Joins in OBI go from fact to dimension, not dimension to fact.