Dimensions-Dependency

View previous topic View next topic Go down

Dimensions-Dependency

Post  SathyJaanu on Fri Oct 16, 2015 12:09 pm

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

SathyJaanu

Posts : 20
Join date : 2015-10-07

View user profile

Back to top Go down

Re: Dimensions-Dependency

Post  ngalemmo on Fri Oct 16, 2015 2:52 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Dimensions-Dependency

Post  SathyJaanu on Fri Oct 16, 2015 3:01 pm

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.

SathyJaanu

Posts : 20
Join date : 2015-10-07

View user profile

Back to top Go down

Re: Dimensions-Dependency

Post  ngalemmo on Fri Oct 16, 2015 3:49 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Dimensions-Dependency

Post  SathyJaanu on Mon Oct 19, 2015 7:37 am

Thnx for ur inputs:)

SathyJaanu

Posts : 20
Join date : 2015-10-07

View user profile

Back to top Go down

Re: Dimensions-Dependency

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


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