Two fact tables

Go down

Two fact tables

Post  MArco212 on 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

View user profile

Back to top Go down

Re: Two fact tables

Post  LAndrews on 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

View user profile

Back to top Go down

Back to top

- Similar topics

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