SSAS Tips

List of articles in category SSAS Tips
Title	Created Date	Author
To get a comma separated list of members for dimension attribute use following mdx	2009-11-28	Written by Amish Manubhai Shah
Use BIDS 2008 to validate Analysis Services 2005 cubes	2009-02-27	Written by Thomas Kejser
Relationship between fact dimension could have type "Fact relationship" or "Regular relationship". No difference, except metadata	2009-01-28	Written by Chris Webb
Speed up MDX query preparation in Reporting Services by specifying default parameter value	2009-01-28	Written by Boyan Penev
Set proper InstanceSelection property for attributes used in the Report Model with Lookup Entity	2009-01-28	Written by Ella Maschiach
You can order date dimension in descending order by setting OrderByAttribute property	2009-01-05	Written by Patrice Truong
Process only one partition so you can browse the cube	2007-09-25	Written by webadmin
Using unformatted cell values it may improve query performance	2007-09-25	Written by webadmin
NULL default measure might improve querying performance	2007-09-25	Written by webadmin
Split large partitions, with more than 20 million rows or that are over 250 MB in size, into ...	2007-06-21	Written by webadmin

Page 1 of 6