Measures as special dimension table
2 posters
Page 1 of 1
Measures as special dimension table
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!
Thanks!
Kraft- Posts : 1
Join date : 2009-10-16
Re: Measures as special dimension table
No, that doesn't sound like a good idea. But maybe if you increase the dimensionality there may be few measures for each context.
Similar topics
» Measures in Dimension table ?
» Modelling a special kind of dimension
» Special Higher-Level Rows in Dimension
» How to create fact table with measures derived from comparing two fact table rows
» Pros and cons of consolidated dimension table Vs. many dimension table ?
» Modelling a special kind of dimension
» Special Higher-Level Rows in Dimension
» How to create fact table with measures derived from comparing two fact table rows
» Pros and cons of consolidated dimension table Vs. many dimension table ?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum