Display # 5 10 15 20 25 30 50 100 All

MDX Performance Hits - v2

Written by Richard Tkachuk on 19 November 2008.

NULL default measure might improve querying performance

Written by webadmin on 25 September 2007.

PowerPivot Nuggets

Written by frederik vandeputte on 15 July 2013.

Process only one partition so you can browse the cube

Written by webadmin on 25 September 2007.

Relationship between fact dimension could have type "Fact relationship" or "Regular relationship". No difference, except metadata

Written by Chris Webb on 28 January 2009.

Remove aggregation designs that are not used by any partitions

Written by webadmin on 21 June 2007.

Set proper InstanceSelection property for attributes used in the Report Model with Lookup Entity

Written by Ella Maschiach on 28 January 2009.

Set the AttributeHierarchyVisible property for the key attribute in a parent-child dimension to Fals

Written by webadmin on 21 June 2007.

Set the Slice property on partitions with ROLAP storage mode or with proactive caching settings...

Written by webadmin on 21 June 2007.

Simple MDX Performance Tips (by Richard Tkachuk)

Written by Richard Tkachuk on 02 May 2007.

SP2 has a lot of performance improvements for processing and querying. Upgrade ASAP.

Written by webadmin on 21 May 2007.

Speed up MDX query preparation in Reporting Services by specifying default parameter value

Written by Boyan Penev on 28 January 2009.

Split large partitions, with more than 20 million rows or that are over 250 MB in size, into ...

Written by webadmin on 21 June 2007.

SSAS - Measures or Attributes in Multiple Display Folders

Written by Devin Knight on 22 March 2011.

The Baker's Dozen: 13 Tips for Querying OLAP Databases with MDX

Written by Kevin S. Goff on 18 March 2008.

The names of attribute relationships should match the names of the related attributes

Written by webadmin on 21 June 2007.

Tips: Processing Large Dimensions

Written by Jesse Orosz on 26 September 2008.

To get a comma separated list of members for dimension attribute use following mdx

Written by Amish Manubhai Shah on 28 November 2009.

Use BIDS 2008 to validate Analysis Services 2005 cubes

Written by Thomas Kejser on 27 February 2009.

Use numeric key columns for attributes with 500000 or more members

Written by webadmin on 21 June 2007.

• 1
• 2
• 3
• 4