Multi Level Dimensions

Md. Altas

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

rmoff

In BMM Layer I created joints in Physical Diagram and Business Model Diagram.

If you're modelling it as a single logical dimension, how many logical fact tables do you have? Are you using multiple logical table sources with the content level set accordingly?

Md. Altas

Thanks for quick response.

I just uploaded the Model diagrams.

Please review and let me know input.

Thanks

rmoff

If it's a screenshot, can you upload it as an image please, not a MS Word document.