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

Measures as special dimension table

2 posters

Go down

Measures as special dimension table Empty Measures as special dimension table

Post  Kraft Fri Oct 16, 2009 3:03 pm

I am modeing a data warehouse for a manufacturing industry. The issue I had is there are too many measures for one particular business process. Say for a work centre, we have 20 measures, and each measure might have different unit of measures. Is is a good idea to create a dimension table say DimMeasures to hold these measures instead of creating many columns in facts table?

Thanks!

Kraft

Posts : 1
Join date : 2009-10-16

Back to top Go down

Measures as special dimension table Empty Re: Measures as special dimension table

Post  ngalemmo Tue Apr 06, 2010 3:49 pm

No, that doesn't sound like a good idea. But maybe if you increase the dimensionality there may be few measures for each context.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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