Home Forums Data Warehousing Analysis Services Fact/Dim design question for cubes RE: Fact/Dim design question for cubes
happycat59
One Orange Chip
Points: 29388
More actions
September 3, 2012 at 10:08 pm
#1533107
To me, Active and Residential seem to be dimensions. Defining them as dimensions means you can easily find info about active residential records etc. If they are a measure, this sort of question is not easy to deal with.