SSAS Tips

List of articles in category SSAS Tips
Title	Created Date	Author
Avoid diamond-shape relationships not covered by hierarchies	2007-06-21	Written by webadmin
Avoid defining non-aggregatable atributes in a parent-child dimension with the exception of the pare	2007-06-21	Written by webadmin
Use numeric key columns for attributes with 500000 or more members	2007-06-21	Written by webadmin
Design hierarchies such that lower levels have more members than higher levels	2007-06-21	Written by webadmin
Avoid specifying more than one non-aggregatable attributes per dimension	2007-06-21	Written by webadmin
Avoid creating hierarchies where attribute relationships do not exists between one or more levels	2007-06-21	Written by webadmin
Define a time dimension	2007-06-19	Written by webadmin
Avoid having 10 or more dimensions with a single attribute. Consider unifying them	2007-06-19	Written by webadmin
A database should have no more than 3 parent-child dimensions that have ...	2007-06-19	Written by webadmin
Define partitions for measure groups	2007-06-19	Written by webadmin

Page 4 of 6