I'm stuck with an issue looking for suggestion/advice. The issue is related to records when the report is built on dimensions, non-confirmed dimensions and facts. Below is the details of RPD modelling and issue
We have 3 facts f1, f2 and f3 and three dimensions d1 d2 and d3. Joins below
a) F1 -d1,d2, d3
b) F2- d2,d3
I have set logical level to grand total for columns in f2 and f3 to non-confirmed dimensions d2 and d1 and d3
Report is built on all columns from f1, f2, f3 and d1, d2, d3. Report executes fine but the results seems not complete set of records from all facts
We have filter on d1..as it's time dimension and non-conformed . Though!!
Heres the issue:
The report is bringing the records only as per joins between f1-d1,d2 d3 and ignoring other fact rows. Example Records from F1-d2 has 100, f2-d2 has 200 and f3-d3 has 50 the report displays only 100 rows against all facts and dimensions.
Investigated further and got to know obiee is doing left outer join between SQLs from each facts.
How can I get all records from all facts...mean full outer join? Please suggest
Also this issue is only when there is a filter on non-confirmed dimension otherwise its working as desired.
Thanks in advance