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

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

News

- SSAS News - Oct 18, 2011 - Microsoft released Cumulative Update package 3 (CU3) for SQL Server 2008 R2 Service Pack 1
- SSAS News - Oct 10, 2011 - Microsoft released Cumulative Update package 8 (CU8) for SQL Server 2008 Service Pack 1
- SSAS News - Oct 7, 2011 - Microsoft released Service Pack 3 (SP3) for SQL Server 2008

Scripts

- SSAS Scripts - Backup Ssas Databases with SessionTrace Output

Articles

- MDX - MDX - Top count with aggregate
- MDX - Scoped Assignments and Multiselect
- MDX - Three Strategies of Evaluating the MDX Aggregate Function
- MDX - How to hide Calculated Members in MDX SSAS
- MDX - Showing an SSAS Hierarchy as Delimited String
- MDX - Excel subtotals when querying Multidimensional and Tabular models
- MDX - MDX Descendant Function
- MDX - Is SSAS Too Lenient on MDX Syntax?
- Excel - Excel Services Scorecard as Windows Desktop Gadget
- AMO - Partition Generator for Multidimensional Cubes
- Performance Tuning - Performance tips for SSAS
- Design - SSAS: Selecting facts with different dimensionality
- Design - SSAS Relationships and Granularity
- Management - SSAS: Process Incremental - What it is and isn't
- Management - SSAS - Deployment Wizard
- Management - Why has all the data in my cube disappeared?
- Management - Enabling Drillthrough in Analysis Services
- Performance Point - Using PowerPivot to incorporate publicly available data sets in your PerformancePoint dashboards
- Tabular - Power Pivot and SSAS (Tabular) Restore
- Tabular - When to choose tabular models over PowerPivot models
- Tabular - Deploy only changes to a Tabular model from BIDS and not process
- Tabular - Observations on interoperability between BISM Tabular and OLAP clients
- Tabular - Calculating aggregate tables in BISM Tabular
- Tabular - You cannot open the BIM file. Reason : The workspace database server 'localhost'
- Tabular - “Denali” Analysis Services where is online mode in BIDS with tabular models
- Tabular - "Denali" Analysis Services Tabular mode vs. Multidimensional mode
- Tabular DAX - Handling Dates in BISM Tabular

Papers

- SSAS Papers - Analysis Services 2008 R2 Performance Guide

Comments

- Comments - Pyramid is an amazing tool for analyzing
- Comments - This was exactly my problem! thanks a l
- Comments - I found my solution for calculating roll
- Comments - I need a count of a time dimension store
- Comments - hello, All the high level
- Comments - I can´t download Adventure Works DW Ref
- Comments - Thanks !!!
- Comments - This wont work for all the cubes,can you
- Comments - Please disregard my previous comment - a
- Comments - The 2nd calculation seems wrong - the as
- Comments - Thank u,This Query was Helped to Me.
- Comments - Very patient and careful advices
- Comments - Is this series of questions really a hid

SSAS Companies

- Consultants - Tomislav Piasevoli (Europe and Telecommute)

And thank you for rating the articles!