Hi Experts,

I have a scenario where the subject area is based on two fact tables and 3 dimension tables.

Below are the join conditions

F1 -- D1, D2, D3

F2 -- D1, D2

Now when I try to create a report with below criteria

D1 -- D2 -- D3 -- F1 -- F2

then the column from D3 table shows null value as it is not joined to F2 table. The query issued is only against the tables D1,D2,D3 and F1 as expected.

What are my options here to show the D3 column value in the report other than doing ETL work to create keys between F2 AND D3.

Let me know.

Thanks