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

Call Fact Table

2 posters

Go down

Call Fact Table Empty Call Fact Table

Post  tim_goodsell Mon Apr 14, 2014 12:30 am

Hello

I have a Customer Call Fact table that contains info regarding a customer call (date of call etc). The customer can initiate up to five requests , is it better to have five fields in the existing fact table to record the customer requests or have a separate table for the requests and have a relationship table between the main call record and the request records

Regards

Tim

tim_goodsell

Posts : 49
Join date : 2010-09-21

Back to top Go down

Call Fact Table Empty Re: Call Fact Table

Post  nick_white Mon Apr 14, 2014 3:09 am

Normally better to hold data at the lowest grain e.g. at the request - your scenario sounds similar to the order/order line case that Kimball covers extensively.
However, can you roll down all the call level attribute to the request. If not you need to think how you would handle this - aggregate the requests up to a call fact table, create a call fact table as well as a request fact table, etc.
It's your business requirements that should be driving this - how does your business understand their data (is it a call or a request) and what do they want to report on?

nick_white

Posts : 364
Join date : 2014-01-06
Location : London

Back to top Go down

Back to top

- Similar topics

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