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

This newsletter can be accessed online at:
http://www.ssas-info.com/analysis-services-newsletters/45-site

The following information was added to the SSAS-Info.com website during the month of March.

News

- SSAS News - March 21, 2011 - Microsoft released cumulative update package 3 (CU3) for SQL Server 2008 SP2

Software

- SSAS Tools - AS Performance Workbench (free)

Scripts

- SSAS Scripts - SSAS Operations Templates (Free)

Articles

- MDX - Last Ever Non Empty - a new, fast MDX approach
- MDX - Referencing Named Sets in Calculations
- Excel - Using Excel 2010 slicers on a SSAS Molap datasource
- Reporting Services - SSRS Sparkline report using MDX
- Reporting Services - Using the DatePicker in SSRS with MDX
- Reporting Services - Retrieving Aggregate Data from Analysis Services for Reports
- Performance Tuning - SSAS Performance tuning
- Design - SSAS: Consider Cube Browsing when Building Role Playing Dimensions
- Design - SSAS - Measures or Attributes in Multiple Display Folders
- Design - Aggregating Member Properties
- Design - Where to store calculated measures - SSAS cube or SSRS reports?
- Design - Dimensions with Multi Valued Attributes
- Design - SSAS - Preserve Measure Null Values
- Management - SSAS errors: Errors in the metadata manager. The dimension with ID of 'xxx' referenced by the 'yyy' cube, does not exist.
- Management - Quick Installation Guide for Analysis Services Load Testing using ASLoadSim and ASQueryGenerator
- Management - Why the obsession with random I/O within the context of SSAS?
- Management - SSAS: Using DMV Queries to get Cube Metadata
- Management - SSIS: Deploying OLAP cubes using C# script tasks and AMO
- Data warehouse - Building dynamic OLAP data marts on-the-fly

Comments

- Comments - At the command prompt: netstat -n -b
- Comments - Thank you for this series of videos. I a
- Comments - This is best ever url for SSAS on net.Gr
- Comments - Would love to download the software but
- Comments - I'd Like to update the 'read' field in m
- Comments - At first the "Run as Administrator" tech
- Comments - At first the "Run as Administrator" tech
- Comments - Hi Todd, just a quick thanks for the rea
- Comments - surely you could just go: create memb
- Comments - Each attempt to generate model from Data
- Comments - Thanks Richard. I know you've moved on f
- Comments - Fantastic Post

And thank you for rating the articles!