Many to many Relationship SSAS


  • Kindly Help me how to implement Many To Many Relationship in SSAS ,

    i have tried everything but failling to implement

    kindly help.


    Friday, June 01, 2012 11:56 AM


All replies

  • Thanks a lot sir,

    I have been able to implement many to many relation in SSAS cube via intermeditary fact table.

    but i am facing problems in data,  while browsing it shows ablnormality in aggregations. and brings  unnecessary data pertainning to my dimentions

    Kindly Help


    Saturday, June 02, 2012 8:47 AM
  • Hello Asrar,

    I would suggest you to check the relationship between the measures in your case. In addition, Here is an article about Analysis Services Many-to-Many Dimensions: Query Performance Optimization Techniques for your reference, please see:

    Bin Long

    Bin Long

    TechNet Community Support

    Thursday, June 14, 2012 10:55 AM