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.
You are clearly not interested in comprehending or learning or following even the most basic rules and etiquette.
No response from me
1 person found this helpful
Filters are at run time from presentation layer.