Yes/No flag in SSAS

View previous topic View next topic Go down

Yes/No flag in SSAS

Post  scabral on Tue Oct 16, 2012 3:15 pm

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

scabral

Posts : 58
Join date : 2012-05-02

View user profile

Back to top Go down

Re: Yes/No flag in SSAS

Post  TheNJDevil on Tue Oct 16, 2012 4:05 pm

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

View user profile

Back to top Go down

Re: Yes/No flag in SSAS

Post  scabral on Tue Oct 16, 2012 4:11 pm

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.

scabral

Posts : 58
Join date : 2012-05-02

View user profile

Back to top Go down

Re: Yes/No flag in SSAS

Post  BoxesAndLines on Tue Oct 16, 2012 8:30 pm

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.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Yes/No flag in SSAS

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