Microsoft Business Intelligence Blogs

Greg Galloway on 4/1/2010

Using EffectiveUserName To Impersonate in SSAS

It's common to implement your role-based security in your Analysis Services cube. That way Fred can only see the sales from the east region, but Frank can only see sales from the west region. Role-based security requires connections to your cube identify the end user so the cube can secure itself. One way of tackling this is to implement Kerberos so that the cre ...
Read Full Blog Post

Ram Sangam on 3/31/2010

SSRS – Multiple Row Grouping Elements to appear under a Single Column within a Table in a report

In SSRS 2008, when you create multiple Row groupings based on the dataset that is being consumed in the report, SSRS adds these grouping elements as separate columns in the table of the report. In the example shown below (Fig.1), Adventure Works DW Sales information is being retrieved by Territory and Product Classification (using database AdventureWorksDW and the tables FactResellerSales, DimProduct, DimProductSubCategory, DimProductC ...
Read Full Blog Post

Greg Galloway on 9/22/2009

Self-Documenting Cubes in Excel PivotTables

If I were the supreme leader of the Excel team (and I've had trouble convincing them of that), one of the first things I would do is add tooltips in the PivotTable field list so that when you mouse over a field, it would describe that field. I've asked ...
Read Full Blog Post