Display # 5 10 15 20 25 30 50 100 All

10 Tips for every SSAS developer

Written by Hilmar Buchta on 14 June 2010.

A database should have no more than 3 parent-child dimensions that have ...

Written by webadmin on 19 June 2007.

Avoid creating hierarchies where attribute relationships do not exists between one or more levels

Written by webadmin on 21 June 2007.

Avoid creating measure grops that have the same dimensionality and granularity

Written by webadmin on 19 June 2007.

Avoid cubes with a single dimension

Written by webadmin on 19 June 2007.

Avoid defining many-to-many relationships when either the intermediate measure group ...

Written by webadmin on 19 June 2007.

Avoid defining measure groups with zero dimensional overlap

Written by webadmin on 19 June 2007.

Avoid defining non-aggregatable atributes in a parent-child dimension with the exception of the pare

Written by webadmin on 21 June 2007.

Avoid diamond-shape relationships not covered by hierarchies

Written by webadmin on 21 June 2007.

Avoid having 10 or more dimensions with a single attribute. Consider unifying them

Written by webadmin on 19 June 2007.

Avoid having 15 or more measure groups in a cube

Written by webadmin on 19 June 2007.

Avoid large parent-child dimensions that have 500000 members for the key attribute

Written by webadmin on 21 June 2007.

Avoid non-materialized reference dimensions

Written by webadmin on 19 June 2007.

Avoid redundant attribute relationships because these relationships may prevent data from being ...

Written by webadmin on 21 June 2007.

Avoid specifying more than one non-aggregatable attributes per dimension

Written by webadmin on 21 June 2007.

Avoid specifying ROLAP storage mode or enabling proactive caching with the OnlineMode property ...

Written by webadmin on 21 June 2007.

Avoid visible attribute hierarchies for attributes used as levels in user-defined hierarchies

Written by webadmin on 21 June 2007.

Break distinct count measures into separate measure groups

Written by webadmin on 19 June 2007.

Change the UnknownMember property of dimensions from Hidden to None

Written by webadmin on 21 June 2007.

Consider setting dimensions that contain measure groups with semi-additive measures to MOLAP

Written by webadmin on 19 June 2007.

• 1
• 2
• 3
• 4