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

Please add our newsletter address to your safe senders list!

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 August.

News

- SSAS News - Aug 18, 2010 - Varigence released "Vivid" - Excel add-in for SSAS
- SSAS News - August 17, 2010 - MS Released CU3 package for SQL Server 2008 R2
- SSAS News - August 17,2010 - MS released Cumulative update package 11 (CU11) for SQL Server 2005 Service Pack 3
- SSAS News - Sep 15-16 - Free webcasts with "24 hours of PASS"
- SSAS News - July 26, 2010 - SQLBits 7 conference wil be taking place from September 30th to October 2nd, 2010 at York University (UK) 

Attention: SSAS-Info.com newsletter subscribers can use code ***** (code available just to newsletter subscribers) to receive 20% discount on all paid parts of the SQLBits 7 conference.

Software

- SSAS Tools - Vivid - Excel add-in for SSAS by Varigence (commercial)
 

Articles

- MDX - How to use ITEM and when ITEM(0).ITEM(0) is redundant
- MDX - MDX Puzzle #6
- MDX - Calculate Run Rate (Full Year Projection) in MDX
- MDX - Difference between Non Empty(Keyword) and NonEmpty (Function)
- MDX - ITEM() function - MDX
- MDX - Set Operations in MDX – UNION and EXCEPT
- MDX - Order of Nested SCOPE Statements
- MDX - MDX Scope with an If Then Exception or Filter
- MDX - MDX Calculated Member Spanning Multiple Date Dimensions
- MDX - MDX YTD not working due to format String
- MDX - MDX Puzzle #5
- MDX - MDX Puzzle #4
- Reporting Services - Reporting Services - Renaming the ALL member in an MDX parameter
- Data Mining - Data Mining on a small amount of data
- Data Mining - How much support do you need for your Data Mining results?
- Design - An other Example of Calculation-Dimension
- Design - Analysis Services ROLAP for SQL Server Data Warehouses
- Design - Multi Language Cubes
- Management - Cube Wackiness – Two Different Internal Errors
- Management - Using XMLA Command to Clear Cache of an Analysis Service Database
- Management - Write Back cubes are easy with Excel 2010
- Management - Quick Guide to BIDS Helper 1.4.3.0 for SSAS
- Management - Cube Translation in Excel 2007
- Management - Backup and Restore of an Analysis Services Database
- Performance Point - Issues Importing SSAS 2008 KPIs into PerformancePoint 2007
- Performance Point - Planning Server Planning & Architecture Guide for PerformancePoint Server 2007
 

Comments

- Comments - Thanks, This is fantastic Stuff
- Comments - Sebastian - thanks for letting me know.
- Comments - Thanks - I updated link
- Comments - I just tried link and it works. Please t
- Comments - Doesn't Work :(
- Comments - Very helpful, thank you!
- Comments - i have sql 2008 and i had downloaded adv
- Comments - It's funny how people who don't know how
- Comments - Once you create a report model based on
- Comments - Article moved to here: http://www.bp-ms
 

And thank you for rating the articles!