Microsoft SQL Server Analysis Services 2005/2008 Tips

Here you will find collection of the short tips that will help you use SSAS more efficient.
   Display # 
# Article Title
1 To get a comma separated list of members for dimension attribute use following mdx
2 Use BIDS 2008 to validate Analysis Services 2005 cubes
3 Relationship between fact dimension could have type "Fact relationship" or "Regular relationship". No difference, except metadata
4 Speed up MDX query preparation in Reporting Services by specifying default parameter value
5 Set proper InstanceSelection property for attributes used in the Report Model with Lookup Entity
6 You can order date dimension in descending order by setting OrderByAttribute property
7 Process only one partition so you can browse the cube
8 Using unformatted cell values it may improve query performance
9 NULL default measure might improve querying performance
10 Split large partitions, with more than 20 million rows or that are over 250 MB in size, into ...
11 Set the Slice property on partitions with ROLAP storage mode or with proactive caching settings...
12 Remove aggregation designs that are not used by any partitions
13 Limit the number of aggregation designs in a measure group to three
14 For partitions, do not use proactive caching with a polling query but no processing query
15 Consolidate partitions for measure groups with 5 or more partitions that have less than 2 million...
16 Avoid specifying ROLAP storage mode or enabling proactive caching with the OnlineMode property ...
17 Do not build more that 500 aggregations for a partition
18 Design aggregations for partitions with 500000 or more rows
19 The names of attribute relationships should match the names of the related attributes
20 Create hierarchies in non-parent child dimensions
 
<< Start < Prev 1 2 3 Next > End >>
Page 1 of 3
 

Data Warehouse Explorer