Content Items Tagged desing.-SSAS

Available Tags:

What is the most important feature for you in the BIDS Helper utility?

Aggregation Manager

Deploy MDX Script

Dimension Data Type Discrepancy Check

Dimension Health Check

Measure Group Health Check

Tri-State Perspectives

Smart Diff

All of the above features and more

I am not using BIDS Helper

Read more about BIDS Helper here

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

Importance - Medium. Source - SSAS 2008 (Katmai) June CTP Partition and Aggregation design warning rules.

SQL Server Analysis Services 2005/2008 articles,blogs,scripts,FAQs,tools,books