What to do with boolean flag?

View previous topic View next topic Go down

What to do with boolean flag?

Post  Willow on Mon Nov 19, 2012 1:17 pm

Hi, last attribute to be modelled! - whether a particular attribute has a charge waived.

We could create a separate dimension but the only values would be Y or N. We have tried to group this in with some other flags to create a junk dimension but none exist. Alternatively we could create it as a measure in the fact table (1 or 0) - is there a rule for determining the best solution?

The attribute is at the level of subscriber and product and we do not have a subscriber/product dimension (as this would be huge and similar size to the fact table).

Thanks!

Willow

Posts : 5
Join date : 2012-10-24

View user profile

Back to top Go down

Re: What to do with boolean flag?

Post  ngalemmo on Mon Nov 19, 2012 3:03 pm

Willow wrote:Alternatively we could create it as a measure in the fact table (1 or 0)

No you can't.

It's not a measure, its an attribute. But there is a thing called a 'degenerate dimension'. In other words, put the flag in the fact.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

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