Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Relationship issue

Hi Fellow modelers,

 

I need help with a scenario. I understand the conceptual difference between one-many / many-many relationships and the nuances of many-many. I have a situation where i am using a refence file in my model and can't use many-many relationship due to reference file constraints. I have 2 tables from two different sources with no unique ID columns which can match. The only column which can be used to create relationship is non-unique. A 3rd table is used as referece which comes from client and is used for mapping. It has unique values and used to create a sort of bridge between 1st two tables. I'm currently using a live connection due to security constraints and can't import the data for atleast one of the sources.

 

Now the issue i'm facing is that i need to provide a decomposition with no scalar value used. Below eg shows : Provide company name and CIM ID. Can't use any scalar value as some end users use report directly to make their own reports.

 

 

 

 

 

What can be a workaround or fix for this issue?

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Make one of the columns as aggregated like first/last min/max

     

    Ideally, speaking you should analyze table and table 2 along with table 3 only

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      amitchandak I understand and i could use another column or pull in same CIM ID column as scalar and it would work. But i can't tell end users (more than 500 and keep on adding) to do it in a specific way. Their requirement is pretty straightforward : "Provide CIM IDs for each Companies referred in file". So they send in a file with IDs  and they keep sending request with sasme issue and i tell them to pull in a scalar value to get the required details but i need to find a better way to cope with this issue.