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

News

- SSAS News - Apr 21,2009 - MS released Cumulative update package 3 for SQL Server 2005 Service Pack 3
- SSAS News - Apr 16,2009 - MS Released CU1 package for SQL Server 2008 SP1
- SSAS News - April 9, 2009 - MS BI Conference that was scheduled for October 2009 will be moved to October 2010
- SSAS News - Apr 7, 2009 - MS Released SP1 for SQL Server 2008
- Announcements - Apr 22, 2009 - New book released - MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 Business Intelligence Development and Maintenance
- Announcements - April 17, 2009 - Free video presentation "Microsoft SQL Server 2008 Analysis Services - Designing and Managing High Performance Cubes"

Software

- SSAS Tools - Vulcan - BI Framework (free)
- SSAS Tools - WhereSpace RED - dev environment to build DW
- SSAS Tools - OLAP Performance Advisor - beta (free)
- SSAS Client Tools - A La Carte Enterprise Intelligence

Jobs

- SSAS Jobs - Datawarehouse Analyst Position - Toronto,Canada

Articles

- MDX - Using MDX to browse the file system
- MDX - The LEVEL_NUMBER Member Property
- MDX - MDXpert.com - MDX functions
- MDX - Trojan for dynamic sets
- Security - Constrained Delegation with Kerberos and SSAS Named Instance
- Security - Enhanced Security and Integration of Microsoft BI Solutions with Kerberos
- Security - Errors may occur after configuring Analysis Services to use Kerberos authentication on Advanced Encryption Standard Aware Operating Systems
- Security - Windows Server 2008 Kerberos Bug – Transport Connection Issues with SSAS data
- Excel - Using Offline OLAP to Develop Cube Reports Without SSAS
- Reporting Services - Line Chart for Analysis Services Data
- Reporting Services - Using date parameters in Reporting Services reports built against data cubes
- AMO - Script dimensions using Windows PowerShell and AMO
- AMO - Detach and attach Analysis Service Database using Windows PowerShell and SQL Server 2008 AMO
- Design - Attribute Discretization: Using the Automatic Method
- Design - Proper partitioning can improve dramatically the writeback process when dealing with large data sets
- Connectivity - Update Isolation Level connection string property
- Management - Stress testing SSAS
- Management - SSAS 2008 Deployment: The connection either timed out or was lost
- Management - Large Analysis Database Migration
- Management - Performance Counters for SSAS 2008
- Management - Analysis Server appears to hang
- Management - Using ProcessingGroup Dimension property option ByTable vs. ByAttribute may error with string keys
- Gemini - Microsoft Project Gemini links

Webcasts

- SSAS Webcasts - Video - SSAS 120 - Storage Modes

Papers

- SSAS Papers - Economical Cloud-Based Business Intelligence with Software from Microsoft, Google, Panorama Software

Comments

- Comments - I found info about this project in Linke
- Comments - Hello, I have heard about vulcan about
- Comments - No more available ?
- Comments - Is there a way of scoping all non leaf m
- Comments - This change is done during run time, so
- Comments - This works. But then when I open the Ana
- Comments - Great article - this would have saved wa

Implementations

- Live demos - RadarSoft online SSAS cube access demo
- Experience - Top 10 demos for Microsoft BI

SSAS Companies

- Consultants - Arjan Fraaij - Microsoft BI Consultant in the Netherlands
- Consultants - Art Tennick - UK-based SSAS trainer and consultant
- Consultants - Enterprise Software Solutions
- Training Providers - Art Tennick - UK-based SSAS trainer

And thank you for rating the articles!