Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Fact/Dim design question for cubes Expand / Collapse
Author
Message
Posted Monday, September 03, 2012 12:48 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 6:35 PM
Points: 222, Visits: 239

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?



Post #1353620
Posted Monday, September 03, 2012 10:08 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:21 PM
Points: 2,842, Visits: 2,423
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.


Post #1353696
Posted Tuesday, September 04, 2012 8:33 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 10:01 AM
Points: 2,979, Visits: 762
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, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/
Post #1353938
Posted Wednesday, September 05, 2012 8:34 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 7:28 AM
Points: 788, Visits: 1,915
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.


Post #1354596
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse