Y/N fields in dimension or as measure with 0 and 1 (or both)?

View previous topic View next topic Go down

Y/N fields in dimension or as measure with 0 and 1 (or both)?

Post  hennie7863 on Fri Sep 09, 2011 7:25 am

I've a couple of Y/N fields and i've translated them into 0 and 1 for summarizing the results. Now my customers are telling me they can't select on measures (in Excel/cube). I'm thinking to build a Factdimension (in SSAS) with these Y/N fields.

I'm thinking about building them both..

Is this correct?

Hennie

hennie7863

Posts : 31
Join date : 2009-10-19

View user profile

Back to top Go down

Re: Y/N fields in dimension or as measure with 0 and 1 (or both)?

Post  hang on Sun Sep 11, 2011 5:39 am

First of all, these flags are dimensions with very low cardinality. So combining them into a junk dimension makes perfect sense.

If you want to derive some measures out of the junk dimension for the cube, you could always do that in a fact view so you still have the junk dimension key for each record in the view.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

View user profile

Back to top Go down

Re: Y/N fields in dimension or as measure with 0 and 1 (or both)?

Post  John Simon on Sun Sep 11, 2011 6:37 pm

There are a dimension, not a measure. Whether you include them in a junk dimension or not, they should be renamed to something descriptive e.g. for an attribute of ManagedFund the values should be not be Y/N but rather Managed Fund, Unmanaged Fund.

John Simon

Posts : 186
Join date : 2009-05-29
Location : Melbourne, Australia

View user profile http://jsimonbi.wordpress.com

Back to top Go down

Re: Y/N fields in dimension or as measure with 0 and 1 (or both)?

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum