Two fact tables

View previous topic View next topic 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
 
Marc

MArco212

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.


LAndrews

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

View user profile

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