SSAS-Info.com website update information for May, 2010
Please add our newsletter address to your safe senders list!
This newsletter can be accessed online at:
http://ssas-info.com/analysis-services-newsletters/45-site
Poll
What is the most important feature for you in the BIDS Helper utility?
Poll option | % |
Deploy MDX Script | 25.1% |
I am not using BIDS Helper | 23.7% |
All of the above features and more | 15.8% |
Aggregation Manager | 14.2% |
Dimension Health Check | 12.1% |
Dimension Data Type Discrepancy Check | 3.2% |
Smart Diff | 3.2% |
Tri-State Perspectives | 1.8% |
Measure Group Health Check | 0.8% |
Number of Voters : 379
Please vote: http://ssas-info.com/polls
Please read more about free BIDS Helper utility: http://www.ssas-info.com/analysis-services-tools/136-bids-helper
The following information was added to the SSAS-Info.com website during the month of May.
News
- SSAS News - May 18, 2010 - MS Released CU1 package for SQL Server 2008 R2
- SSAS News - May 17, 2010 - MS Released CU8 package for SQL Server 2008 SP1
- SSAS News - May 11, 2010 - A new version of BIDSHelper has been relased - 1.4.3.0
Software
- SSAS Tools - Sperm Report - Complete OLAP browser for Analysis server created with Reporting Services 2008 featuring "Spermline" visualization (free)
- SSAS Tools - Theobald Software GmbH: Xtract PPS - Connect Microsoft SharePoint PerformancePoint Services with SAP
Articles
- MDX - Static Named Sets v/s Dynamic Named Sets
- MDX - Rank Function (For same value)
- MDX - Re: MDX ORDER Riddle
- MDX - MDX ORDER Riddle
- MDX - OR operation in MDX
- MDX - DAX vs. MDX vs. T-SQL
- MDX - MDX : Non Empty v/s NonEmpty
- Reporting Services - Tuning SSRS-Generated MDX Parameter Queries
- Reporting Services - Use Date Picker Control with MDX Based Reports
- Local Cube - Creating Local Cube or Offline Cube from SSAS 2008
- AMO - Using MSBuild with SQL Server Analysis Services Projects
- AMO - Validating SSAS Projects Programmatically
- AMO - Export Analysis services cubes, roles and members from a server to CSV using C#
- AMO - XMLA script to deploy MDX Calculations
- Performance Tuning - Optimising Cube Query Performance and Processing Performance
- Performance Tuning - SSAS Performance tips – Lessons learned
- Design - Analyzing the number of visits per customer
- Design - Hierarchical Ordering of Members of a Hierarchy
- Management - ProcessFull fails where continuous ProcessUpdate's worked
- Management - In Search of Aggregations
- Management - To Partition or Not – This is the Question
- Management - Scale-Out Querying with Analysis Services…does it apply to SQL Server 2008 or 2008 R2?
- Management - How to avoid Long running MDX Requests
- Management - What happens when you do a Process Update on a dimension?
- Management - Managing memory of Analysis Services instance
- Management - You cannot open a Business Intelligence project after you upgrade the project to the format that is used by Visual Studio 2010
- Performance Point - PerformancePoint Server 2007 Build List and Hotfix Update
- Data warehouse - Self-Service BI, PowerPivot and the future of traditional BI (DWH, OLAP, MDX)
Comments
- Comments - very good. i just started BI and this he
- Comments - I am just using the set to have the coun
- Comments - Hi Jim, It is a good article.
- Comments - Can we schedule this script in SSMS as a
- Comments - Interesting article but I am not getting
- Comments - Could you explain why Descendants is nec
- Comments - I have the same error, but the problem w
- Comments - The author seems to be know the subject
- Comments - Hmm! Ok, some of your interview question
- Comments - I can't find any pricing info for Analyz
- Comments - Please anyone help me providing the solu
- Comments - Yes it seems like this guy will take som
- Comments - Report portal handle not only numerical
- Comments - Is it me or this dimwit a racist?
- Comments - Thanx, this helped me.
- Comments - Hi Just, This sample script is not de
- Comments - Really great script! I have a soluti
- Comments - Could you please let me know which examp
- Comments - samething than Brian, someone got a solu
- Comments - Question - How to get the details of
- Comments - Thanks, it was very helpful. Good work.
- Comments - As for comments about conclusions on art
- Comments - Dave, I believe your questions are on
- Comments - http://dotnetslackers.com/Community/blog
- Comments - Scott, Good point - I updated article
- Comments - Interesting article, but some of the exa
- Comments - In my case, it was not "move" but "copy"
- Comments - You are right . This is the best Site ab
- Comments - Thank you so much.
And thank you for rating the articles!