Forum Discussion
data model relationships not working
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.
Unfrtunatly i cant share the data due to data protect but ive created an example and attached . I know what you mean about the flow of the relationship but i cant change the direction of the reltion as there duplcate values in the other table. The example i've attached is very simplistic but in my real world use case there are 27k BPs and it isnt possble for me to put then in the rows. I just wanted to show how many unique accounts from the look up table had had some sort of contact or didnt show in contact data