Forum Discussion
data model relationships not working
zedders1250 The message suggest that relationships MAY be needed. It doesn't say that there are no relationships.
You don't show the set-up for the pivot table. Which fields / measures from which tables did you use?
Riny_van_Eekelen It doesnt matter which fields i use in the pivot table. It doesnt work unless the fields are from the same table.
Even if i use the most basic relationship so a field from custom contact received and a count of bp from lookup table i get the same message advisng that relationshis may be needed
zedders1250 Well, if you don't share more info and just repeat that it doesn't work, I can't help you.
- I answered your question. What exactly do you need to know?
zedders1250 Difficult to answer if you don't tell what your are doing, but it seems you are counting BP's from the dimension table based on a column from one of the fact tables. Then you are filtering against the direction of the relationship. It will work, however, when you either put the BP in the Row or Column field.
Since you didn't share any data to work with, I made a mock-up to demonstrate. See attached.