Dynamic security in SQL Denali PowerPivot CTP3

One common requirement is that users only see data relevant to them. This normally corresponds to the role he or she has within the company. In this blogpost I will show you how this can be done in SQL denali PowerPivot CTP3.

It is important to know that security is one of the features which can not be set up within the Excel PowerPivot addin but only within Visual Studio 2010 (BIDS). Microsoft feels like this is a typical feature that BI developers would create, not end users.