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

Best way to model Status's

2 posters

Go down

Best way to model Status's Empty Best way to model Status's

Post  kenny Tue Dec 22, 2009 6:19 pm

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

kenny

Posts : 11
Join date : 2009-10-30

Back to top Go down

Best way to model Status's Empty Re: Best way to model Status's

Post  BoxesAndLines Tue Dec 22, 2009 7:56 pm

Case Status Dimension. You need it for ease of reporting.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Back to top

- Similar topics

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