Home Forums Data Warehousing Analysis Services Fact/Dim design question for cubes RE: Fact/Dim design question for cubes
Thomas LeBlanc
SSCrazy Eights
Points: 8075
More actions
September 4, 2012 at 8:33 am
#1533310
I agree with happycat, they should be used in a dimension. You can use the Count Distinct MDX function to answer the How Many... question
Thomas
Thomas LeBlanc, MVP Data Platform Consultant