There is a very interesting new Microsoft program that started back in January, called the SSAS Maestro Program. It is a five-day, deep-dive course on Analysis Services 2008 R2 that gives architects and consultants the education and hands-on experience needed to deliver the … Continue reading →
Here is a common got-ya. You are modifying the cube dimension security for a role-playing dimension. You make the changes and the cube processes successfully. But when you try to connect to the cube, you get the following error message: The ‘XXX’ attribute in … Continue reading →
As I play with the recently released CTP3 of SQL Server 2012, code name of Denali, I wanted to point something out about installing SSAS, since there is now two “modes” you can choose from due to the the new BI Semantic Model … Continue reading →
Another whitepaper to add to your “to read” list: SQL Server 2008 R2 Analysis Services Operations Guide This white paper describes how you can test, monitor, capacity plan, and troubleshoot Microsoft SQL Server Analysis Services OLAP solutions in SQL Server 2005, … Continue reading →
OK, since this conference in is England, it’s a little harder to get to compared to TechEd. No matter, all the videos for this conference are online (65 of them). Take a look at the recorded sessions at http://sqlbits.com/content/Event8. All … Continue reading →
I have always wondered if queries against a SSAS cube while it is processing would be forced to wait the entire time the cube is processing, or just for a few minutes? Or would the query bomb out? Surprisingly, I … Continue reading →
At the recent TechEd North America 2011 conference, details on the next version of SQL Server 2012 (codename “Denali”) were released. Part of those details were an update on the SQL Server Analysis Services (SSAS) roadmap. The main new feature in … Continue reading →
A nice new little add-in available for SSMS on Codeplex. It helps with repetitive tasks involved with SSAS such as processing and deployment. As the site says, the goal for the Analysis Services Helper is to fill in gaps in the toolset inside … Continue reading →
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio. Version 1.5 can be downloaded here, and read up on the new features. It’s a must-have … Continue reading →
When using role security in SSAS, one point of confusion is when a person sees the grand total for a measure that includes the total of ALL members in the cube, even though the security has limited the members that person can … Continue reading →
When Visual Studio 2010 was released about a year ago, I was very excited and wanted to quickly open up a SSAS project created in VS 2008 to see the new features that were available in VS 2010. So I copied … Continue reading →
Every couple of weeks I see this SSAS error when processing one of my cubes: Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element. An error occurred while parsing the ‘StorageMode’ element at … Continue reading →