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

News

- SSAS News - Jan 17, 2011 - Microsoft released cumulative update package 2 (CU2) for SQL Server 2008 SP2
 

Software

- SSAS Client Tools - Publishing Server by Iris Business Intelligence LLC (commercial)

Articles

- Uncategorized - How to Choose the Right Business Intelligence Technology to Suit Your Style
- MDX - Solving the ‘Events in Progress’ problem in MDX, Part 2–Role Playing Measure Groups
- MDX - Calculating Cumulative Values in Microsoft BI Tools
- MDX - Solving the ‘Events in Progress’ problem in MDX, Part 1
- MDX - Days Since Last Event: TSQL vs. MDX vs. DAX
- MDX - Tuning the Currency Conversion Calculations created by the Add Business Intelligence Wizard
- MDX - Various way to calculate running total from All Period to Currentmember
- MDX - MDX IIF Execution Plans and Plan Hints
- Security - Advanced Dimension Data Security with SQL Server 2008
- Excel - Excel Against a SSAS Cube Slow: Performance Improvement Tips
- Design - Avoiding NULLs in SSAS Measures
- Design - Default Measure in SSAS Cubes
- Design - SSAS SCDs: Showing Active Dimension Members With No Data
- Design - Walkthrough: Implement many-to-many currency conversion in an Analysis Services solution
- Management - Unaggregatable M2M Dimensions
- Management - Kind of SSAS processing in simple words
- Management - How to add calculations in SSAS cubes
- Management - Processing an Analysis Services Cube Using SQL Server Management Studio
- Management - SSAS performance tuning (Case Study)
- Management - How to use SSAS 2008 Warning Framework effectively
- Performance Point - Using Reporting Services Report (SSRS) with PerformancePoint Services (PPS)
 

Webcasts

- SSAS Webcasts - Comparing PowerPivot with Analysis Services
 

Comments

- Comments - Really, really beautifull Thanks
- Comments - well. The only downside is that I use Da
- Comments - nice article cris. It helps me so much.
- Comments - Hi I am new to SSAS and I tried your so
- Comments - Very good article
- Comments - Awesome...Solved my problem too... solve
- Comments - During our development we found out that
- Comments - Thanks for reporting this - I fixed link
- Comments - Thanks for providing more info about con
- Comments - Is it possible to exclude a dimension wi
- Comments - How you define the relationship? it cann
- Comments - I try your solution, and there is an err
- Comments - i am a big fun of rafal, and i can't fin
- Comments - The link for the Read more... blog page
 

And thank you for rating the articles!