Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
obiee query design

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
Answers
-
Hi,
You can change the join in the BMM Layer between the two tables.
Regards,
Akansh
0 -
Yes you can:
Watch out with your example though. Joins in OBI go from fact to dimension, not dimension to fact.
0