How to impliment this in OBIEE-Change OBIEE generated query

user652652

Hi Experts,

We have Dimensions D1 and D2. Fact F1.

D1 and D2 are joined to F1 and  confirmed dimensions.

1. D1 to F1 left outer join

2.D2 to F1 is inner join.

When we apply any filter on D2 then the left outer data(i.e. all data from D1) is not appearing in report.Because where clause apply at end of query. How to design if we want

1. First where clause for D2 apply and then

2.Left outer join apply,so that we can get all data from D1.

Gianni Ceresa

user652652 wrote:D1 and D2 are joined to F1 and confirmed dimensions.

CONFORMED ! They are conformed dimensions because if they aren't "confirmed" they aren't supposed to exists ...

You maybe want to jump back to How to impliment this in OBIEE? Financial year for India is April to March  and have a look at the note the moderator posted there as apparently you still didn't.

You are taking things in the wrong way, you do not write things to generate a query in OBIEE, you model things to answer a business need. So make your model in a way able to answer to the business question instead of taking a random (default) model and try to force it to do something it hasn't been designed for.

[Deleted User]

You are clearly not interested in comprehending or learning or following even the most basic rules and etiquette.

No response from me

Joel

You'll need to add a WHERE clause to the Logical Table Source of your Logical Fact to ensure that the query will have the D2 WHERE clause even if D2 attributes aren't part of report/query

Joel

haven't been following previous conversations but I would stringly suggest listening to the advice given to you by @Gianni Ceresa and @Christian Berg

user652652

Thanks Joel,

Filters are at run time from presentation layer.