What is the permission needed to view and create a Excel report for TFS Analysis Services cube?

To view, refresh, or create a Microsoft Excel report that connects to the SQL Server Analysis Services cube you have many options:

Without SharePoint Server

Excel report for TFS Cube

All user must be belong to TfsWarehouseDataReaders security role in Analysis Services

With SharePoint Server Single Sign-On

Excel report for SharePoint Single Sign-On TFS Cube

With SharePoint Windows Authentication + Add users to TfsWarehouseDataReaders 

Excel report for SharePoint Windows Authontication TFS Cube

For more info see the following link:

Assign Permissions to View and Manage Reports for Visual Studio ALM

Advertisements

Mohamed Radwan is a Visual Studio ALM MVP, Senior ALM Consultant @ Marvel ALM focus on C#, MVC, JQuery, BDD, TDD, TFS and Practical Agile Implementation. He is the founder of TFSEG User Group, Co-founder of MEAALM Community , the author of DevMagicFake Mocking Framework and a frequent speaker in different Microsoft events. M.Radwan is M.Sc. of computer sciences and information technology in Agile methodology M.Radwan holds number of Microsoft certifications including MCT, MCPD, MCITP in EPM, MCTS (7), MCSD, MCAD and CIW

Tagged with: , , ,
Posted in All, TFS Analysis Service Cube, TFS Excel Reports, TFS Reports, TFS Security

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

About the Author

Mohamed Radwan
is a Visual Studio ALM MVP, Senior ALM Consultant @ Marvel ALM  focus on C#, MVC, JQuery, BDD, TDD, TFS and Practical Agile Implementation. He is the founder of TFSEG User Group, Co-founder of MEAALM Community , the author of DevMagicFake Mocking Framework and a frequent speaker in different Microsoft events.
More info about Mohamed


       



TFS 2012 Visual Guide

TFS 2010 Video Guide

TFSEG User Group

MEAALM Community

Blog Stats
  • 14,144 hits
%d bloggers like this: