Forum Discussion
ambiguity problem
I solved my problem with using a "help" table to combine the offerte and opdracht id's with their id's.
See picture:
Solution Sageonderdeel table and offerte table has many to one relation. If we consider onderdeel is your dimension table and offerte/opdracht is your fact table. Then the relation from onderdeel to offerte/opdracht should one to many (Not many to one)
once you do that and put direction from onderdeel to offerte/opdracht . you can solve the ambiguity problem
Regards,
Sayali
If this post helps, then please consider Accept it as the solution to help others find it more quickly.
Thx for the quick reply but my data looks like this. I was a bit to quick with that. 😄
"offerte" id's (colomn1_id)
1
2
5
6
"opdracht" id's (colomn1_id)
3
4
7
8
"onderdeel" id's offerprojectbase_id
1
1
1
2
3
3
4
5
5
5
6
7
8
8