Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Dimensions-Dependency

2 posters

Go down

Dimensions-Dependency Empty Dimensions-Dependency

Post  SathyJaanu 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

Back to top Go down

Dimensions-Dependency Empty Re: Dimensions-Dependency

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

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

http://aginity.com

Back to top Go down

Dimensions-Dependency Empty Re: Dimensions-Dependency

Post  SathyJaanu 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

Back to top Go down

Dimensions-Dependency Empty Re: Dimensions-Dependency

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

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

http://aginity.com

Back to top Go down

Dimensions-Dependency Empty Re: Dimensions-Dependency

Post  SathyJaanu Mon Oct 19, 2015 7:37 am

Thnx for ur inputs:)

SathyJaanu

Posts : 20
Join date : 2015-10-07

Back to top Go down

Dimensions-Dependency Empty Re: Dimensions-Dependency

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


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