Facts and Dimensions - OBIEE — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Facts and Dimensions - OBIEE

Received Response
42
Views
2
Comments
Chandu K
Chandu K Rank 2 - Community Beginner

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.

Answers

  • S R Battula
    S R Battula Rank 4 - Community Specialist

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

  • 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