Design Warning Rules (Analysis Services - Multidimensional Data)
This section of the documentation contains cause and resolution information for database design warning rules related to Microsoft SQL Server Analysis Services.
Attributes and Attribute Relationships
Either disable the attribute hierarchy or set the AttributeHierarchyOptimizedState property to NotOptimized for non-key attributes that have 1,000,000 or more members and a cardinality within 95% of the key attribute
Measures and Measure Groups
ROLAP and MOLAP Storage
For faster performance, use the Microsoft OLE DB Provider for SQL Server or the SQL Server Native Client provider to connect to a SQL Server data source instead of the .NET Data Provider for SQL Server (SqlClient)