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

Modelling the Relationship between Dimensions

2 posters

Go down

Modelling the Relationship between Dimensions Empty Modelling the Relationship between Dimensions

Post  monserob Mon Mar 04, 2013 11:42 am

I work for an alarm installation company. In our transactional system we have two tables - site and system. The site table holds where the alarm system is installed and the system table relates to the alarm. A site can have more than one system and a system can as you'd expect only be installed in one site.

It makes sense for site and system to become dimension tables in a proposed data warehouse. If that assumption is correct then how would a BI user do an adhoq system count and also pull in one or more attributes from the site dimension e.g. a site type? Would we need to create a factless fact table to manage the relationship between these two dimensions?

monserob

Posts : 4
Join date : 2013-01-30

Back to top Go down

Modelling the Relationship between Dimensions Empty Re: Modelling the Relationship between Dimensions

Post  ngalemmo Mon Mar 04, 2013 3:13 pm

You could do that, but would there not be a sale or installation event that provides that information as well?
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Modelling the Relationship between Dimensions Empty Re: Modelling the Relationship between Dimensions

Post  monserob Tue Mar 05, 2013 6:30 am

The site and system records are created as part of an order release process, which we will be modelling; unfortunately information may not be available for systems that were installed prior to 2007. I guess we could create dummy order release fact records for those systems but I can't help thinking that this is a lot of work for something as simple as a system count grouped by site type. Am I missing something here?

monserob

Posts : 4
Join date : 2013-01-30

Back to top Go down

Modelling the Relationship between Dimensions Empty Re: Modelling the Relationship between Dimensions

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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