September 3, 2012 at 12:48 pm
With Accounts cube we quite a few measures setup such as Active, Residential, CreditScore buckets.
Any issues with creating FactAccounts table with columns such as IsActive, IsResidential, values being 0 or 1, and they get summed up as a measure.
Or create these as dimensions?
Chris Becker bcsdata.net
September 3, 2012 at 10:08 pm
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.
September 4, 2012 at 8:33 am
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
September 5, 2012 at 8:34 am
I think the answer can be both. Although I would normally associate those items with a dimension, it could be possible depending on the business processes that they would be usefully done as a measure or even both in the same cube.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply