Forum Discussion

Anmolgan's avatar
Anmolgan
Post Prodigy
6 years ago

Eliminate Many 2 Many Relationship

Hi,   I am facing the issue while building many 2 many relationship, so far it works well when I want to display sales vs actual as per month, location, but when it comes down to customer codes, I ...
Need Help
Show and Tell
Anmolgan's avatar
Anmolgan
Post Prodigy
6 years ago

Hi amitchandak, I have shared the PBIX link for the report, let me know if you can access it.

  • Anmolgan's avatar
    Anmolgan
    Post Prodigy
    6 years ago

    Hi amitchandak any issues while accessing the file?

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Anmolgan ,

       

      I looked at it. The complete data model needs to re-looked. You need common dimension for the customer, dealer, Material, Geography, plant, and sales group.

      One or more than one member can be there in each of these. My advice would be that get correct data from the source. Creating a dimension here is not a great idea.

      Like Geography might start from city or store, depend on the common data point. Both tables seem to have a different column for material that needs to be addressed.

      • Anmolgan's avatar
        Anmolgan
        Post Prodigy
        6 years ago

        Hi amitchandak thanks for the response, basically I only need to create realtionship between customer key from both the tables, the problem is I dont have some keys in my plan query, but they exisist in actual, what will be the best way to eliminate them in such a way so that there is no issue when buiulding the relationship.