SSAS-Info.com website update information for October, 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
SSAS-Info.com Poll
What do you think about PowerPivot/Gemini?
Results for October 31, 2009:
10 - I have not seen it yet
10 - I tested it and I like it
4 - I tested it and I don't like it
6 - I saw demos of it and I like it
3 - I saw demos of it and I don't like it
Total votes: 33
Cast your vote at http://www.ssas-info.com
The following information was added to the SSAS-Info.com website during the month of October.
News
- SSAS News - Oct 19,2009 - MS released Cumulative update package 6 for SQL Server 2005 Service Pack 3
- SSAS News - Oct 19, 2009 - Project “Gemini” name officially revealed as Microsoft SQL Server PowerPivot for Excel
- Announcements - Nov 13, 2009 - Free webcast Learn MDX scripting
- Announcements - Nov 11, 2009 - Free webcast - Extract data from the cube
- Announcements - PASS BI Virtual Chapter Presents: Analysis Services End-To-End - Oct 27, 2009
Software
- SSAS Tools - InstantCube - Creates cubes quickly by auto-generating the underlying code (Free)
- SSAS Tools - Ranet.UILibrary.Olap is component library for OLAP
- SSAS Client Tools - PushBI by Extended Results Inc.
- SSAS Client Tools - Flash Pivot Table Component by Flex Monster
- SSAS Client Tools - Smart eVision by Object River Information Technology Inc.
- SSAS Client Tools - Adomd Command Designer (Free)
- SSAS Client Tools - Cubeware Cockpit V6pro
FAQ
- Management FAQ - Q: During database processing I am getting error "OLE DB error: OLE DB or ODBC error: Class not registered"
- Management FAQ - SSAS error during deployment - "The connection either timed out or was lost"
Articles
- MDX - Problems with FORMAT_STRING, VBA functions and NON_EMPTY_BEHAVIOR
- MDX - Actions and Multiselect
- MDX - Bitmap index (Universal percentage in OWC - take 2)
- MDX - A Box of Chocolate: Flavors (part one)
- MDX - Using MDX to Enhance PerformancePoint Data Visualization
- MDX - Using Dimensions as Parameters to Calculations and Sets
- Security - SSAS advanced dimension level security using SSRS reports, showing parent of a level you have no access
- Security - Kerberos SPN Generation Setup Tool - SSAS 2008
- Excel - Excel 2007 and SSAS 2008 Error
- Excel - Excel 2007 OLAP PivotTable Tips
- Excel - A Few More PivotTable Improvements in Excel 2010
- Excel - Excel 2010 PivotTable What-If Analysis (Writeback)
- Excel - What's preventing Excel from being the ubiquitous cube browser
- Excel - PivotTable Named Sets in Excel 2010
- Reporting Services - 100% Stacked Column Chart for Analysis Services Data
- Reporting Services - SSRS 2008 – Lattice Charts
- Reporting Services - WinLoss Graphs in Reporting Services 2008
- Reporting Services - HowTo: Bullet Charts in Reporting Services 2005
- Reporting Services - Conditionally Hiding Axes for Trellis Displays
- AMO - Create New SSAS Partition dynamically: XML Task
- AMO - Which Edition is my Analysis Services Server?
- Design - Role-playing time dimensions and semi-additive measures
- Connectivity - Deploying a Business Intelligence Solution Using SharePoint, Reporting Services, and PerformancePoint Monitoring Server with Kerberos
- Management - Analysis Services (SSAS) Processing and Aggregations
- Management - Cube Storage: Introduction to Partitions
- PowerPivot - PowerPivot for SharePoint 2010 – The Business User’s Perspective
- PowerPivot - Project BI bloggers – Analysis in PowerPivot (ex-Gemini)
- PowerPivot - What is PowerPivot?
- PowerPivot - Gemini (PowerPivot) Does Cloud!
- PowerPivot - Announcing the Great Football Project (PowerPivot)
- PowerPivot - Trying to solve a business problem with Powerpivot, Gemini CTP2
- PowerPivot - Using PowerPivot with Excel 2010
- PowerPivot - Introducing PowerPivot
- PowerPivot - Donald Farmer on Gemini (PowerPivot) - audio interview
- PowerPivot - Creating a Custom Gemini/PowerPivot Data Feed – Method 1 – ADO.NET Data Services
- PowerPivot - Gemini (PowerPivot)- Copy/Paste
- PowerPivot - Introduction to Data Analysis Expressions (DAX) in Gemini (PowerPivot)
Comments
- Comments - We hae pushed changes which should signi
- Comments - Ashok, I fixed the link. Thank you very
- Comments - For some reason the link provide above a
- Comments - Andre, tov Thanks for highlighting th
- Comments - The query is very slow and my cpu usage
- Comments - A lot of people are not able to view the
- Comments - Very slow query run query (20-30 sec) co
- Comments - Microsoft has stopped supporting this do
- Comments - Jun, I am running this on 2005 and on
- Comments - Hi Vidas, will this scrip work in SQL 2
- Comments - Great instructions! Thanks. One addition
- Comments - I believe I fixed this link.
- Comments - I'm gettting 404 too. I want to see the
- Comments - Great article. Thanks a lot
Implementations
- Live demos - Intelligencia for SilverLight demo
Cheat Sheets
- Cheat Sheets - PowerPivot DAX function list with samples
SSAS Companies
- Consultants - Sid Atkinson, BI Lead at Catapult Systems, Austin TX
And thank you for rating the articles!