none
Many to many Relationship SSAS

    Question

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

    i have tried everything but failling to implement

    kindly help.


    Asrar

    Friday, June 01, 2012 11:56 AM

Answers

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


    Asrar

    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:
    http://www.microsoft.com/en-us/download/details.aspx?id=137

    Regards,
    Bin Long


    Bin Long

    TechNet Community Support

    Thursday, June 14, 2012 10:55 AM
    Moderator