Month: September 2012

Drillthrough action in Tabular Analysis Services

It seems that Analysis Services supported actions for Tabular mode for a while, but who wants to maintain it using XMLA? Luckily, the BIDS Helper is more than capable. Please follow this link for additional information. This is really exciting! It is almost strange that this feature is not available in the SQL Server Data Tools

Continue reading
No comments

Excel Services 2013 and SharePoint 2013 – interact with Pivot Tables using Browser

One of the nice new features of Excel Services now available in SharePoint 2013 is ability to interact with pivot tables directly from the browser without having to open the workbook in Excel. Here we have a PivotTable report deployed in SharePoint. Before, if we wanted to change a layout of the pivot table, we had to

Continue reading

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

More details on new PerformancePoint features in SharePoint 2013

Additional details are coming out on the new features that will be available in PerformancePoint 2013. Here is a list of new stuff: Themes – SharePoint has traditionally been somewhat of a challenge with respect to look and feel configuration and PerformancePoint Services was an even bigger challenge yet. Microsoft has simplified the CSS challenges

Continue reading