Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Two fact tables

2 posters

Go down

Two fact tables Empty Two fact tables

Post  MArco212 Tue Nov 19, 2013 5:03 am

Hi everybody!!
I have one Dimension call Indicator
Also, I have two fact tables with the following data
IdIndicator    Value
1                   40
IdIndicator    Botton Limit       Top Limit         Final Value
1                   0                      10                 1
1                   10                     50                2
1                   50                     100               3
I need to calculate a measure that return the value 2 because Value(40) is between 10 and 50
Can anyone help me??
Thanks in advance


Posts : 1
Join date : 2013-11-19

Back to top Go down

Two fact tables Empty Re: Two fact tables

Post  LAndrews Tue Nov 19, 2013 3:33 pm

Why do you think the second table is a fact table?

To me it looks like a dimension ... its defining a banding value.

Alternately, it can just be used by the ETL process to populate a "Final Value" column on the primary fact.


Posts : 132
Join date : 2010-05-13
Location : British Columbia, Canada

Back to top Go down

Back to top

- Similar topics

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