Microsoft demonstrated PowerView on top of the Multidimensional model in Analysis Services several weeks ago at SQL PASS and now the CTP version of the product is available here. There are two pieces of new functionality delivered with this CTP: Update for Analysis Services engine to allow DAX support for Multidimensional models Update for the … Continue reading Microsoft SQL Server 2012 With PowerView For Multidimensional Models is available in CTP
There are several UI gotchas related to building PowerView visualizations that I wanted to address with this post. First, PowerView is not available in the Ribbon out of the box, in order to enable it, one needs to go to File->Options->Add-ins. Then find Manage Add-Ins drop down box, select "COM Ad-ins" and click Go. That … Continue reading How to connect Excel PowerView to Analysis Services cube
Here is a great article on how to implement row level security for a tabular Analysis Services model. Along with security it also makes some interesting points about Parent Child relationship, that are not very friendly for the Tabular mode just quite yet.
This will be in a long rant format as I am still trying to organize my thoughts around this subject. Before I start comparing and contrasting the two vendors, I just wanted to make a quick statement to get something off my chest: Generally speaking, HANA is a good business decision for SAP as it … Continue reading SAP HANA versus Microsoft Business Intelligence and xVelocity
I will start this post with a bit of a rant. There are two types of people in the Business Intelligence world: Those who do not like Excel Those who do Most of the right-click-hating low tech users belong to the first category (they are also usually the same people who like bubble gum and … Continue reading Improving performance of Excel reports against Analysis Services
The second iteration of the tabular model for analysis services now allows us to implement very sophisticated security scenarios including row-level dynamic security. In order to implement it, first we need the means of finding out the windows credentials of the user. That can be accomplished using the DAX function USERNAME(). Second, we need to map … Continue reading Dynamic security in a tabular model for analysis services
Many great discussions are taking place about the future of the Multidimensional mode for the Analysis Services. It is very clear where the majority of the investment went for the 2012 version (hint... think rows and columns and not multidimensional). At the same time, one might argue that the traditional or Multidimensional set of features is already … Continue reading Choosing a Tabular or Multidimensional model in SQL Server 2012 Analysis Services
great tip on how to process your analysis services cubes faster by running the processing in more threads http://geekswithblogs.net/ManicArchitect/archive/2010/11/02/142558.aspx
Microsoft is claiming that xVelocity technology will be available across SQL Server database engine, PowerPivot AND Analysis Services... This technology works great for the first two, however, I couldn't find anything on column store for the Analysis Services.... This would be a huge new improvement for SSAS...