Many to Many Relationship RRS feed

  • Question

  • Hello All,

       In my current design am having Product dimension related to my main fact table through many to many relationship and most of the reports are based on Product Dimension as a result all my queries are hitting the partitions not the aggregations.

    Can anyone suggest way to create aggregations so that when i query based on dimension related to many to many relation can get good performance.??



    Wednesday, July 29, 2015 3:35 AM


All replies