Display # 5 10 15 20 25 30 50 100 All

Consolidate partitions for measure groups with 5 or more partitions that have less than 2 million...

Written by webadmin on 21 June 2007.

Create hierarchies in non-parent child dimensions

Written by webadmin on 21 June 2007.

Debugging SSAS Cubes - a Few Tips

Written by Boyan Penev on 21 June 2011.

Define a time dimension

Written by webadmin on 19 June 2007.

Define attribute relationships as 'Rigid' where appropriate

Written by webadmin on 21 June 2007.

Define partitions for measure groups

Written by webadmin on 19 June 2007.

Define the default member for non-aggregatable attributes in either the DefaultMember property or ..

Written by webadmin on 21 June 2007.

Design aggregations for partitions with 500000 or more rows

Written by webadmin on 21 June 2007.

Design hierarchies such that lower levels have more members than higher levels

Written by webadmin on 21 June 2007.

Do not build more that 500 aggregations for a partition

Written by webadmin on 21 June 2007.

Do not forget to set properly attribute relationship type (rigid or flexible).

Written by webadmin on 22 May 2007.

Do not ignore duplicate key errors. Change the KeyDuplicate property of the error configuration ...

Written by webadmin on 21 June 2007.

Either disable the attribute hierarchy or set the AttributeHierarchyOptimizedState property to ...

Written by webadmin on 21 June 2007.

Excel 2007 OLAP PivotTable Tips

Written by Richard Lees on 17 October 2009.

Excel Against a SSAS Cube Slow: Performance Improvement Tips

Written by John L. Hall on 13 January 2011.

For dimensions, do not use proactive caching with a polling query but no processing query

Written by webadmin on 21 June 2007.

For partitions, do not use proactive caching with a polling query but no processing query

Written by webadmin on 21 June 2007.

If you can, list in SELECT statement real measures first and calculated measures after

Written by Vidas Matelis on 23 May 2007.

Include the default measure of a perspective in the perspective

Written by webadmin on 19 June 2007.

Limit the number of aggregation designs in a measure group to three

Written by webadmin on 21 June 2007.

• 1
• 2
• 3
• 4