Content Items Tagged mdw.-SSAS

Title	Section	Date
SSAS Monitoring Scripts For Management Data Warehouse (Free)	Software	27/2/2009

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

Consolidate partitions for measure groups with 5 or more partitions that have less than 2 million rows or are smaller than 50MB in size.

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