SSAS-Info.com website update information for July, 2009
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 July.
News
- SSAS News - July 21, 2009 - MS Released CU3 package for SQL Server 2008 SP1 (CU6 for RTM)
- Announcements - July 21, 2009. New book released - Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
- Announcements - Jul 28, 2009 - Free live meeting - MDX drillthrough capabilities in Reporting Services
- Announcements - July 14, 2009 - SQL Sentry released Performance Advisor for Analysis Services
Software
- SSAS Tools - SQL Sentry - Performance Advisor for Analysis Services (commercial)
Jobs
- SSAS Jobs - San Diego, CA - Sr. Data Warehouse Architect, MDX Expert
Scripts
- SSAS Scripts - SQL Profiler EventClass & EventSubClass Column Descriptions
- SSAS Scripts - Script to automate SSAS partition management (SQL + SSIS)
Articles
- MDX - Dynamic sets
- MDX - Calculating Percentile in SQL Server Analysis Services MDX
- Excel - Excel 2010 - a personal sneak preview
- Excel - What’s new for Analysis Services users in Excel 2010?
- Excel - Excel 2007, OLAP Cubes: Customizable, User Defined Named Sets in Excel 2007 using VBA
- Reporting Services - Simple Doughnut Chart for Analysis Services Data
- Reporting Services - Syntax highlighting bug in Reporting Services 2008 MDX Query Designer
- Reporting Services - Sum of a SQL Analysis Services calculated measure within a Reporting Services report gives #Error
- Reporting Services - How to Test SSRS MDX Queries in SQL Server Management Studio
- Drillthrough - Default Cube Action in Excel
- Time Dimension - How to create time attribute relationship (2)
- Time Dimension - Date Dimension script optimized for Analysis Services KeyColumn property (Part 1)
- Time Dimension - How to create a time attribute relationship (1)
- AMO - SSAS: Creating a Rowset action with the ExecuteSQL .Net stored procedure
- Performance Tuning - Query Performance Tuning in Microsoft Analysis Services (Part 1 and 2)
- Performance Tuning - Enterprise Performance Tuning: Best Practices with SQL Server 2008 Analysis Services
- Design - Measures and Measure Groups in Microsoft Analysis Services (Part 1 and 2)
- Design - Implementing histograms in OLAP
- Design - Ignore processing errors in SSAS 2005 and 2008
- Design - Using a View for a Fact Table in SSAS Project
- Design - Attribute Discretization: Customize Grouping Names
- Design - SQL Server ifrastructure planning and design paper (SSAS)
- Design - Storage Modes in SSAS (MOLAP, ROLAP and HOLAP)
- Design - Avoid Common SQL Server Analysis Services Problems
- Design - SQL Server Analysis Services ( SSAS ) - Introduction
- Design - Practical Dimensional Modeling – Part II
- Management - Creating and managing SQL Server Analysis Services partitions
- Management - Multi user SSAS writebacks may result to blocks on similar functions and new connections
- Management - How to use Partition Processing Destination Task to pump data into a SSAS partition via SSIS
- Management - Disk Partition Alignment Best Practices for SQL Server
- Management - Analysis Services Memory Limits
Webcasts
- SSAS Webcasts - Video - SSAS 123 - Perspectives
Papers
- SSAS Papers - SQL Server Analysis Services Protocol Specification (MS-SSAS9)
- SSAS Papers - SQL Server Analysis Services Version 8.0 Protocol Specification
Comments
- Comments - Hi Vidas, This is a timely post as I
- Comments - 10q :)
- Comments - Can you do audience targeting on a dashb
- Comments - Not sure what happened, but when I click
- Comments - Fixed link. It appears that original web
- Comments - Link does not take to any webcast :(
SSAS Companies
- Consultants - MEYERS Vincent - BI Consultant at Sylis BELGIUM
- Training Providers - Pragmatic Works
And thank you for rating the articles!