Yes/No flag in SSAS
3 posters
Page 1 of 1
Yes/No flag in SSAS
I have a claims transaction fact table and some of the transactions are considered "historical" in nature meaning that they were manually entered from a legacy system.
Our business users sometimes need to filter out the Historical transactions when looking at Claim amounts for certain periods. My question is should I create a Historical Type Dimension with Yes/No attributes and have the FK live in the fact table or do i just add a Historical Yes/No field in the fact table as a Degenerate Dimension?
thanks
Scott
Our business users sometimes need to filter out the Historical transactions when looking at Claim amounts for certain periods. My question is should I create a Historical Type Dimension with Yes/No attributes and have the FK live in the fact table or do i just add a Historical Yes/No field in the fact table as a Degenerate Dimension?
thanks
Scott
scabral- Posts : 58
Join date : 2012-05-02
Re: Yes/No flag in SSAS
Is there some other dimension that can have the flag added to it? (junk dimension) I would find a place in a dimension that already exists (claimtype?).
TheNJDevil- Posts : 68
Join date : 2011-03-01
Re: Yes/No flag in SSAS
It's really not tied to another of the dimensions that I have setup.
It's basically tied to the individual transaction. Most of the transactions are not historical, but there are a couple hundred that are. I just need a way to filter them out of the cube if the users don't want to include the historical transactions.
It's basically tied to the individual transaction. Most of the transactions are not historical, but there are a couple hundred that are. I just need a way to filter them out of the cube if the users don't want to include the historical transactions.
scabral- Posts : 58
Join date : 2012-05-02
Re: Yes/No flag in SSAS
Use tinyint and put a 1 or 0 in the value, put directly on the fact table. Don't use bit because you can't sum bits.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» What to do with boolean flag?
» Current Flag in a Dimension
» Flag attributes in Subscriber Dimension
» SSAS / Design Help Please
» How to represent boolean flag representation in FACT?
» Current Flag in a Dimension
» Flag attributes in Subscriber Dimension
» SSAS / Design Help Please
» How to represent boolean flag representation in FACT?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum