If i have 2 fact tables f1,f2. And d1,d2 are the confirmed dimensions and d4 is joined to f2.
If the report is built based on f1,f2,d4 then how can we build the report? Can anybody please let me know about this?
Thanks in Adv.
Multiple Fact Reporting on (Non-)Conforming dimensions | Oracle BI By Bakboord
Mark if helps.