Hi All
Need some idea on how can I achieve the following. I build this scenario in Microsoft BI already. However the other division wants in OBIEE.
I have got 3 level under item dimensions -
Product Family
- Finished Good
- Components
Now the facts for Finished Goods and Components are independent of each other
I have got Shipment Analytics for Finished Good where we captured the Shipment Quantity, Shipment Value etc. For Components we have got Receipt Analytics like Receipt Quantity and Receipt Value etc.
I want to create a dashboard where if I select Product Family and date range then -
1: Shipment Value Section will provide details about Shipping by pulling out Finished Good related to the selected product family
2: Receipt section will provide me details related to Receiving about the components related the Finished goods pulled in the shipping section
I created 3 tables -
PF - to store data for product family
FG - To store data related to Finished goods and also stores the data of Product Family it belongs to
CMP - To store data of components and also stores the data of Finished good. Here the same component is repeated multiple times because it is linked to multiple finished goods.
PF - FG have 1 - Many relationship
FG - CMP have Many - Many relationship
In BMM Layer I created joints in Physical Diagram and Business Model Diagram.
But when I pull the data in OBIEE I get error that No fact table is common.
Can someone guide me on this whats missing?
Thanks
