Category: Analysis Services

How to connect Excel PowerView to Analysis Services cube

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

Improving performance of Excel reports against Analysis Services

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

Dynamic security in a tabular model for 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

Choosing a Tabular or Multidimensional model in SQL Server 2012 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