Month: May 2012

HTML5 support for PowerView and the rest of the Microsoft BI stack

Had a long conversation with a senior Microsoft executive few days ago.  It appears that HTML5 support for PowerView will be released with the Service Pack 1 for SQL Server 2012 by the end of this calendar year.  A little too late for my taste, but I will take what I can get.  My prognostication is

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

How to create Sharepoint workflow for MDS

Microsoft Master Data Services is one of the most exciting new features of SQL Server 2012.  Technically, the V1 of the product was introduced with SQL Server 2008 R2, but to be completely honest, it did not get much acceptance.  In my prognostication, this will drastically change with the V2 of the product.  There are two

Continue reading

Reading and Loading SharePoint Data using SSIS

Lists are one of the cornerstones of SharePoint and many companies have a wealth of information stored and managed using this SharePoint feature.  I sometimes get questions whether it is possible to extract that data (or load that data) into a data warehouse or a cube elsewhere.  The answer is yes, using the SharePoint SSIS Adapters. 

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