What to do with boolean flag?
2 posters
Page 1 of 1
What to do with boolean flag?
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!
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
Re: What to do with boolean flag?
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.
Similar topics
» How to represent boolean flag representation in FACT?
» Should a True/False value be a dimension
» Boolean dimensions
» Modeling help on dimension with many boolean value
» Yes/No flag in SSAS
» Should a True/False value be a dimension
» Boolean dimensions
» Modeling help on dimension with many boolean value
» Yes/No flag in SSAS
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum