I have a SQL 2008 R2 OLAP Cube and an Excel file that uses powerpivot and embedded datasource to the Cube.
I want to upload the Excel file in SharePoint and allow users who are authenticated to the cube refresh the selected region of the excel sheet opened in SharePoint excel viewer. This refresh must happen through their windows domain account identity and be only allowed to refresh those portion of the cube which they have access to.
I'm using a single service account for all farm services including application pools , service applications and farm services. However this service account does not have access to the cube and it is configured to be an unattended service account in Secured Store Service application. So these are my questions :-
- Is it possible to configure excel and powerpivot data refresh without giving access to the excel and power pivot service account and the unattended service account in Secured store service of SharePoint to the OLAP cube ?
- Does identity delegation as mentioned here http://technet.microsoft.com/en-us/library/gg502605(v=office.14).aspx is applicable for my requirement.