Modelling hierarchy information

View previous topic View next topic Go down

Modelling hierarchy information

Post  Aravinth on Mon Oct 24, 2011 4:04 pm

I am creating a dimensional data model to store Project management data. I am receiving 3 file input file

1. Region.dat - Has Region details

2. Project Detail.dat - Each record contains details about each program or project or subproject

3. Project Cross Reference - Cross reference file to build the hierarchy for Program, project and Subproject. One project can reside under
more than on program and subproject under more than one project

I am creating 2 dimension to store Region and Project detail (Excluding effort)

How do I store the cross reference/hierarchy Bridge table, as key columns in fact table?

Input Files

Region - (Region information)
Region ID
Region

Project Detail - (Program/project/Subproject information)
ID (Can be program/project/subproject ID)
Project Name
Manager
Status
Progress
Sart Date
End Date
Approved effort
Actuals effort

Project Corss Reference
Program Id
Program Name
Project Id
Project Name
Sub Project Id
Sub Project Name



Aravinth

Posts : 1
Join date : 2011-10-21

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum