SSAS-Info.com May 2008
Please add our newsletter address to safe senders list!
This newsletter can be accessed online at:
http://www.ssas-info.com/analysis-services-newsletters/45-site
SSAS-Info.com Poll
What front end are you using for SSAS database?
Results for May 31, 2008:
26.7% Microsoft Excel
24.4% Proclarity
17.6% Microsoft Reporting Services
13.7% Other
6.9% In house build software
4.6% Panorama Novaview
1.5% Strategy Companion Analyzer
1.5% PivotView OLAP Client
1.5% Cubeslice
0.8% Intelligencia Olap Controls
0.8% Business Objects - Voyager
Cast your vote at http://www.ssas-info.com
Talk about poll results in our forum.
Announcements
- June 4th webcast: Data Modeling for Business Intelligence with Microsoft SQL Server
- Free Solid Quality Mentors webcast - June 4, 2008- Craig Utley: Avoiding Common Analysis Services Design Problems
SSAS News
SSAS Cheat Sheets
Formatted list (PDF) of MDX queries. This is work in progress and the list will be updated.
- MDX Various Queries Cheat Sheet
- MDX Error handling Cheat Sheet
- SCOPE MDX Cheat Sheet
- Time MDX Cheat Sheets
SSAS 2005 Articles
- AMO - Code : utility code for converting cellset to a data table
- AMO - SSAS: Reporting on Metadata
- AMO - Managing SQL Analysis Service Objects with SSIS and AMO
- Connectivity - LINQ to MDX
- Data Mining - Data mining - Microsoft Business Intelligence with Numerical Libraries
- Design - Using TinyInt as keys in Analysis Services
- Design - Dimension Attributes: Introduction and Overview, Part IV
- Design - Star vs. Snowflake in OLAP Land
- Design - Intrinsic Member Properties: The MEMBER_CAPTION Property
- Design - Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Design - Dimension Attributes: Introduction and Overview, Part III
- Design - KPIs in Analysis Services
- MDX - SIMPLE MDXes for time periods
- MDX - Division by null and zero in MDX
- MDX - Ranking results from MDX queries
- MDX - Very Customed Aggregation
- Parent-Child - Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Reporting Services - How to implement cascading parameters in a SQL Services Reporting Services MDX Report
- Reporting Services - Creating a Report Model based on an Analysis Cube – Pros and Cons
- Security - Cell Security: when Read permissions are actually Read Contingent
- Security - Microsoft BI with Constrained Kerberos Delegation
- Security - Enhancing Analysis 2005 Security - Revoking Domain Admin and Local Admin from Built in Admin role
- Security - powerSSAS: Listing Role information
- Time Dimension - Handling Multiple Calendars with a M2M Scenario
SSAS 2008 Articles
SSAS Client Tools
SSAS Tools
- xSQL Documenter - SSAS Documentations
- Analysis Services Browser Views Add-in
- Persisting SSAS OLAP Roles In Project Server 2007
Webcasts
- Webcast - Webcast: SQL Server 2008 Analysis Services Design and Performance Improvements
- Virtual Lab - TechNet Virtual Lab: Building Integrated Business Intelligence Solutions Leveraging SQL Server 2005 and SharePoint Server 2007
- Data Mining Webcast - Using Data Mining in Your IT Systems (Part 2)
- Data Mining Webcast - Using Data Mining in Your IT Systems (Part 1)
- Data Mining Webcast - Video presentation - Working with Data Mining
- Data Mining Webcast - Video presentation - Introduction to Data Mining
- Data Mining Webcast - TechNet Webcast: 24 Hours of SQL Server 2008: Data Mining
SSAS Implementations
SSAS Jobs
SSAS FAQ
- MDX - How do I find the bottom 10 customers with the lowest sales in 2003 that were not null?
- MDX - How do I create a Rolling 12 Months Accumulated Sum that can show a trend without seasonal variations
- MDX - How do I group dimension members dynamically in MDX?
- MDX - How do I check for the top level in a dimension to avoid division by an nonexsting parent(-1.#INF)
- MDX - How do I check for division by zero and null to avoid -1.#INF in cells
- Management - How to fix dimension processing error 'mdprocessdim.cpp line 3429 function MDProcessPropertyJob'
Do not forget to rate the articles!