SSAS-Info.com July 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 News
- MDX Studio 0.4.2 released - July 29, 2008
- Microsoft to Acquire DATAllegro - provider of DW appliances
- Microsoft Business Intelligence Conference 2008. Registration open, Session list available. Forum to talk about BI conference is here.
SSAS Papers
SSAS 2005 Articles
- AMO - Win/Loss chart as dynamic image created in SSAS stored procedure
- AMO - Some more samples for data aware images created in a stored procedure
- AMO - Returning an image from an SSAS stored procedure
- Design - BI Architecture and Design Guidelines
- Design - Fact table design for "State Workflow Analysis": Analysis Services Dimensional modeling
- Design - Dimension Attributes: Introduction and Overview, Part V
- Management - SSAS Deployment Wizard Retaining Permissions
- Management - Running Microsoft SQL Server 2008 Analysis Services on Windows Server 2008 vs. Windows Server 2003 and Memory Preallocation: Lessons Learned
- Management - Creating an Analysis Services Cube with Visual Studio 2008 - Parts 1 and 2
- Management - Manage traces in SQL Server 2005 Analysis Services with XMLA commands
- MDX - Product Volatility: Optimizing MDX with MDX Studio
- MDX - What happend to the top 10 products previous years ?
- MDX - MDX ratio of "current parent" issue
- MDX - Product Volatility in Adventure Works
- MDX - Intrinsic Member Properties: The MEMBER_NAME Property
- MDX - Some more thoughts on quantiles...
- MDX - NextAnalytics and MDX : Part 1 - Swap Cells with Row Labels
- MDX - Binomial distribution for a KPI status (parts 1 and 2)
- Parent-Child - Recursive hierarchies or non recursive, pros and cons
- Reporting Services - Mastering OLAP Reports: Parameterizing Number of “Top” Items with the MDX TopCount() Function, Part I
- Reporting Services - SSRS Report Against a SSAS Parent Hierarchy
- Data warehouse - Value-Add: Data Warehousing & Analysis Services Cube Storage Estimates
- Data warehouse - Best Practices for Data Warehousing with SQL Server 2008
SSAS 2008 Articles
- Named Sets, AutoExists and Katmai
- Performance Improvements for MDX in SQL Server 2008 Analysis Services
- Dynamically generating session calculated members in code with Analysis Services 2008
SSAS Client Tools
SSAS Tools
- AS Validate Users utility - to avoid "no mapping between account names and security IDs was done" error
- Kalido Universal Information Director
- MDX Studio Online - format and parse MDX queries
Webcasts
- Webcast - Webcast - SSAS 107 - Creating Dimensions
- Webcast - Webcast - Microsoft Office Excel and Microsoft SQL Server Analysis Services: An In-Depth Look at Integration
- Webcast - Webcast - SSAS 106 - Basic Deploying, Processing, and Browsing
- Webcast - Webcast - Advanced SQL Server 2005 Analysis Services Workshop
- Webcast - SSAS 105 - The Cube Wizard - SSAS 2008
- Webcast - SSAS 104 - The Cube Wizard - SSAS 2005
- Webcast - SSAS 103 - Data Source Views
- Webcast - SSAS 102 - Creating Projects and Data Sources
- Webcast - SSAS 101 - Introduction to Analysis Services
- Webcast - Webcast - Avoiding Common Analysis Services Design Problems
- Webcast - Video: Did you know? SQL Server 2008 includes Dimension Designer Enhancements (SSAS)
- Data Mining - Webcast - The Subtle Powers of Data Mining Algorithms
SSAS Implementations
SSAS Jobs
SSAS FAQ
Do not forget to rate the articles!