obiee query design

Question

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?

Thanks & Regards,

K

[Deleted User] · Answer

Yes you can:

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

AkanshAgarwal · Answer

Hi,

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

Regards,

Akansh