Can't determine relationship between the fields

[twister8889]

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?

[amitchandak]

@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]

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.