What I'm trying to do is expose access to an OLAP cube using Excel Services. From what I've read, we're comfortable with getting this in place providing that it uses Active Directory for authentication, and the Cube applies security based on the Active Directory groups.
Note: I'm not a sharepoint expert, nor am I an Excel Services expert, so if there's a gotcha in there, it's worth pointing out.
The issue is that there needs to be Single Sign On between our in-house developed application and the Sharepoint instance, and that user information needs to be passed the OLAP Cube so that it can be used for data security.
I can pass "CustomData" attributes when accessing the Cube using excel to connect locally, but what I want is to provide data that is stored in the session.
So the process would be:
- User logins into our application
- User gets transferred to Sharepoint SSO url
- Sharepoint checks SSO credentials, and stores the UserID from our application in the session
- Excel services loads up the workbook, and dynamically amends the connection string to add in the UserId as a CustomData attribute.
- Is this possible?
- Is there a better way of doing this?
- Have I missed something obvious?
I'm happy to be pointed in the direction of articles to read, I'm not looking for a quick fix, just some advice.