Best way to model Status's
2 posters
Page 1 of 1
Best way to model Status's
What is the best way to model Status's
here is the requirement I am working on
Dimensions
Person, Product, Location, Time
Fact
Client_Statistics_Fact
Measure the number of Open,Active, Closed cases at a point in time, We create a Case when a Person comes to a Location and a Product is offered to the person
Case's can have status's Open,Active,Closed, What is the best way to model this scenario should I create a Case Status Dimension and refer the foreign key in the Fact table or should I create a Case Dimension with all possible Status's a Case can have, A Case is nothing but delivery of the Product to the Person at that location it has information like Person_Id, Start_Date, End_date, Outcome
Any help is appreciated
Thanks
Kenny
here is the requirement I am working on
Dimensions
Person, Product, Location, Time
Fact
Client_Statistics_Fact
Measure the number of Open,Active, Closed cases at a point in time, We create a Case when a Person comes to a Location and a Product is offered to the person
Case's can have status's Open,Active,Closed, What is the best way to model this scenario should I create a Case Status Dimension and refer the foreign key in the Fact table or should I create a Case Dimension with all possible Status's a Case can have, A Case is nothing but delivery of the Product to the Person at that location it has information like Person_Id, Start_Date, End_date, Outcome
Any help is appreciated
Thanks
Kenny
kenny- Posts : 11
Join date : 2009-10-30
Re: Best way to model Status's
Case Status Dimension. You need it for ease of reporting.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Rule based algorithm to convert an ER model to a dimensional model
» Complexities of Relational Model and Simplicities of Dimensional Model
» Why we use Dimensional Model over De-normalized relational Model ?
» Meta-model of Kimball dimensional model
» credit card model
» Complexities of Relational Model and Simplicities of Dimensional Model
» Why we use Dimensional Model over De-normalized relational Model ?
» Meta-model of Kimball dimensional model
» credit card model
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|