Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSAS Aggregation design M2M error

Author  Topic 

ritesh.gaur
Starting Member

3 Posts

Posted - 2012-10-23 : 04:14:36
When designing aggregations on a measure group partition which uses a many-to-many dimension, I'm getting an error "Errors in the aggregation designer. The dimension has no attribute for the aggregation design. The server cannot design aggregations when this attribute is missing." The IsAggregatable property of the many-to-many dimension is set to false, since it has 4 memebers only.

Please do reply if anyone has any ideas to overcome this.

nicklarge
Starting Member

40 Posts

Posted - 2012-10-23 : 17:16:12
ritesh, could you look at the answer give in this post in case it helps.

http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/0b602371-02d2-4e2e-9489-1ced87c1c88c

Nick.
Go to Top of Page
   

- Advertisement -