Forum Discussion

Brains86's avatar
Brains86
Frequent Visitor
5 years ago
Solved

ambiguity problem

Hello,    I was wondering if someone could help me with the following problem.    I hava a dataset from my CRM which gives me 2 tables: "offerte" (offer) and "opdracht" (project). This holds the ...
Need Help
  • Brains86's avatar
    Brains86
    5 years ago

    I solved my problem with using a "help" table to combine the offerte and opdracht id's with their id's. 

    See picture: 

     

sayaliredij's avatar
sayaliredij
Solution Sage
5 years ago

onderdeel 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.

  • Brains86's avatar
    Brains86
    Frequent Visitor
    5 years ago

    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