Best way to model Status's

View previous topic View next topic Go down

Best way to model Status's

Post  kenny on 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

View user profile

Back to top Go down

Re: Best way to model Status's

Post  BoxesAndLines on Tue Dec 22, 2009 7:56 pm

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

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

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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