obiee query design

3193829

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

AkanshAgarwal

Hi,

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

Regards,

Akansh

[Deleted User]

Yes you can:

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