Forum Discussion

bvdm1980's avatar
bvdm1980
Helper II
3 years ago
Solved

totals showing same value - table relation question

Hi.   I have the following tables: dim_CostActivity fact_CostDetails fact_BudgetDetails   my cost activity is ofcourse coming back in multiple tables. Unique values. So i linked this to both f...
Need Help
  • bvdm1980's avatar
    bvdm1980
    3 years ago

    Hi ImkeF 

     

    thanks for your reply. I double checked the settings, and all keys are same formatting. 

    what i did wrong (i typed another explanation here and by typing something popped in my mind....)

    i used the activity code from 1 of the fact tables, and not the activity from the dim_CostActivity table.... 😄

ImkeF's avatar
ImkeF
Community Champion
3 years ago

Hi bvdm1980 ,
indeed, that's often the reason.
Make sure that the key-columns are of the same type (text or numbers for example).

bvdm1980's avatar
bvdm1980
Helper II
3 years ago

Hi ImkeF 

 

thanks for your reply. I double checked the settings, and all keys are same formatting. 

what i did wrong (i typed another explanation here and by typing something popped in my mind....)

i used the activity code from 1 of the fact tables, and not the activity from the dim_CostActivity table.... 😄