Forum Discussion

twister8889's avatar
twister8889
Icon for Helper V rankHelper V
5 years ago

Can't determine relationship between the fields

Hi guys,

 

I have the error when I tried to, for example, put in the same visual table fields from fact1, dim1, and fact2. How can I solve this problem?

 

I don't like to use both directions ( I already read about this, and is not recommend ), Is possible another way to solve this problem?

 

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    twister8889 , what are columns/measures you have taken.

     

    I doubt you have taken un summarized column both from fact 1 and fact 2. In this can you can have un summarized column only from one fact table with common dimension along with it.

    • twister8889's avatar
      twister8889
      Icon for Helper V rankHelper V
      5 years ago

      hi, First of all, thank you for your answer

       

      In this case, the column that links with fact1 and fact2 of dim1 is a date key dd/mm/yyyy, So I tried to put in the same table these 3 fields data.
      I have some measures from fact1 and fact2, when I inserted in the same tables these date fields and these measures, the table show the values but take a long time to refresh data.