SSAS-Info.com website update information for June 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
Special offer - SSWUG.org BI Virtual Conference - July 22-24, 2009. You can use special discount code SSASVIP to get 10$ discount.
The following information was added to the SSAS-Info.com website during the month of June, 2009.
News
- SSAS News - Jun 16,2009 - MS released Cumulative update package 4 for SQL Server 2005 Service Pack 3
- Announcements - June 30, 2009 - SSWUG.org presents virtual conference (July 22-24, 2009)
- Announcements - June 2,2009 - Interactive Edge LLC released XP3® BI Presenter
- Announcements - PASS BI SIG presentation June 23, 2009 - Create smarter and more useful Cubes
Software
- SSAS Tools - PTPower - Excel 2007 Add-In (Free)
- SSAS Client Tools - PowerOLAP
- SSAS Client Tools - XP3 BI Presenter
FAQ
- Management FAQ - Q: In SSAS 2008 I am getting an error message when generating usage based aggregations: "Internal error: The parameter is not valid."
Articles
- MDX - Error messages in MDX SELECT statements and what they mean
- MDX - Set alias in IIF statement
- MDX - Problem with ParallelPeriod() function
- Security - DrillThrough Actions and (semi) Security in SSAS OLAP cubes
- Reporting Services - Exploded Pie Chart for Analysis Services Data
- Reporting Services - Reporting Services Tips for OLAP Cubes
- Reporting Services - SSAS 2008 Reporting Actions: MDX vs. SQL
- Reporting Services - Suppressing Auto-generation of MDX Parameter Datasets
- Reporting Services - Creating a matrix report using the Analysis Services Cube
- Data Mining - Sampling data with the Excel 2007 data mining add in
- AMO - SSAS: Executing Arbitrary SQL queries
- AMO - Get Analysis Services last processed date
- AMO - SSAS: Powershell to replace a group member in a role
- AMO - Accessing Analysis Services Cubes with Windows Communication Foundation
- Design - Attribute Discretization: Using the “Clusters” Method
- Design - Analysis Services 2005 - Dynamic Default Member
- Design - How To Enable User-Defined Hierarchies in SQL Server Analysis Services
- Connectivity - SQL Job – Check Cube Valid Data as Last Step
Webcasts
- SSAS Webcasts - An introduction to SQL Server data warehousing concepts
- SSAS Webcasts - Video - SSAS 122 - Translations
- SSAS Data Mining Webcasts - Integrating Data Mining into your BI Solution (Presentation)
- SSAS Data Mining Webcasts - Data Mining the StackOverflow Database
Comments
- Comments - I think that so is easier ... MEMBER
- Comments - I want sum of last 13 months how to do
- Comments - Great tip! Is there a way to set the ASC
- Comments - Sorry, source files were changed and tha
- Comments - I had the same problem as the previous c
- Comments - I'm trying to install on SSMS2008 withou
- Comments - How do I restore this DateTimeTemplate i
- Comments - Thanks very much boss
And thank you for rating the articles!