Facts and Dimensions - OBIEE

Question

Hi All,

How to split master data tables into Facts and dimensions for below scenario:

Three individual tables:

Work Order -  which have details of an work order.

Columns:  wo ID, status, desc, date, some measure

labor -  which have details of a labor assigned to the above wororder

Columns: wo ID, LaborID, location, date,  department , hours and some measure

Tools -  which have details of a tool used by a labor for the  above wororder

Columns: WO ID, toolsid,asset No, date, toolrate, tool hours and some measures.

Scenario:

a work order have multiple labor assigned and  multiple tools used.

Wo ID is the only column which is available in three tables.

So, could you please suggest , how can i split all these three tables into facts and dim's and maintain a star-schema model in Physical layer.

Note:

I am able to split tables into Facts and dimensions, but not able to model the data.

Any suggestion would be highly appreciated.

Regards,

Chandu.

Gianni Ceresa · Answer

Chandu K wrote:Note:I am able to split tables into Facts and dimensions, but not able to model the data.

By "model the data" you mean how to practically define a dimension and a fact in OBIEE? For that there are trainings, books or just tutorials: OBIEE Tutorials

S R Battula · Answer

first create alias tables in physical layer and  follow the physical joins in Physical joins and  create logical Fact and dimensions in  BMM Layer.