Dimensions-Dependency
2 posters
Page 1 of 1
Dimensions-Dependency
Hi All,
I have a table that has list of Project Activities in it.And the Successor table has list of Activities that shows dependency between activities.
I am planning to design a dimensional model.How to i relate these two tables?Should i join the two tables into a single dimension or show it as two separate Dimensions?
I am asked to deisgn a report where i show all these details for a particular activity:
projid,
Activity Str Dt ,
ActivityEndDt,
est-hrs,
Remaiging Hrs,
Pred_activity_id
Activity Table:
PrjID ActID Activity Str Dt ActivityEndDt Est-Hrs Remaiging Hrs
1 1a mm-dd-yyyy mm-dd-yyyy 10 6
1 1b mm-dd-yyyy mm-dd-yyyy 20 6
1 1c mm-dd-yyyy mm-dd-yyyy 30 7
2 2a mm-dd-yyyy mm-dd-yyyy 14 4
2 2b mm-dd-yyyy mm-dd-yyyy 14 7
2 2c mm-dd-yyyy mm-dd-yyyy 15 2
Activity Successor Table:
PRjID ActID Prev_Proj_id Pred_activity_id
1 1b 1 1a
1 1c 1 1b
2 2a 1 1c
2 2a 1 1b
2 2b 1 1c
2 2b 2 2a
I have a table that has list of Project Activities in it.And the Successor table has list of Activities that shows dependency between activities.
I am planning to design a dimensional model.How to i relate these two tables?Should i join the two tables into a single dimension or show it as two separate Dimensions?
I am asked to deisgn a report where i show all these details for a particular activity:
projid,
Activity Str Dt ,
ActivityEndDt,
est-hrs,
Remaiging Hrs,
Pred_activity_id
Activity Table:
PrjID ActID Activity Str Dt ActivityEndDt Est-Hrs Remaiging Hrs
1 1a mm-dd-yyyy mm-dd-yyyy 10 6
1 1b mm-dd-yyyy mm-dd-yyyy 20 6
1 1c mm-dd-yyyy mm-dd-yyyy 30 7
2 2a mm-dd-yyyy mm-dd-yyyy 14 4
2 2b mm-dd-yyyy mm-dd-yyyy 14 7
2 2c mm-dd-yyyy mm-dd-yyyy 15 2
Activity Successor Table:
PRjID ActID Prev_Proj_id Pred_activity_id
1 1b 1 1a
1 1c 1 1b
2 2a 1 1c
2 2a 1 1b
2 2b 1 1c
2 2b 2 2a
SathyJaanu- Posts : 20
Join date : 2015-10-07
Re: Dimensions-Dependency
From what I get from you description, the successor is simply the activity that happens next, correct? This is something that is reflected in the facts. It is not something you would attempt to identify in the dimension.
You would typically have a planned activity fact that contains all activities, their sequence (WBS), planned dates and budget. Activity reporting would be another fact that captures the actuals relating to those activities.
You would typically have a planned activity fact that contains all activities, their sequence (WBS), planned dates and budget. Activity reporting would be another fact that captures the actuals relating to those activities.
Re: Dimensions-Dependency
So Successor activity table would be another fact table?
"
You would typically have a planned activity fact that contains all activities, their sequence (WBS), planned dates and budget. Activity reporting would be another fact that captures the actuals relating to those activities.
"
MY bad its confusing can you please elaborate.
"
You would typically have a planned activity fact that contains all activities, their sequence (WBS), planned dates and budget. Activity reporting would be another fact that captures the actuals relating to those activities.
"
MY bad its confusing can you please elaborate.
SathyJaanu- Posts : 20
Join date : 2015-10-07
Re: Dimensions-Dependency
Yes, it would be the project plan fact that would contain the planned activities and when they should occur. Succession is implied. Dependencies can be handled with a bridge table keyed by project, activity and dependent activity.
The work that is actually done, and when it is done, is handled in a separate fact. Succession is not something you care about here as you are simply recording what happened. Deviation from the plan is analysis performed by aligning the plan to the actuals.
The work that is actually done, and when it is done, is handled in a separate fact. Succession is not something you care about here as you are simply recording what happened. Deviation from the plan is analysis performed by aligning the plan to the actuals.
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|