11月14日
Per-User Connections in Business Scorecard Manager
If you'd like to use permissions maintained in your Analysis Services cube, you can pass back the user credentials to the database by editing the web.config file to set <Bpm.PerUseConnection = True/>
Note that this has to be done on both the SharePoint and the Web Services site. Also note that if the database is on a seperate machine, you'll need to setup security (e.g. Kerberos) to avoid the "two-hop" issue.
Kerberos guidance available here:
Updated 4/10/2007
There have been questions on how to make KPI data personalized based on user credentials. i.e. the same KPI show different data for different users. We have both systems integrator and independent software vendors partners that have done this successfully since around the time Business Scorecard Manager shipped. It's a two-step configuration.
Step one is to setup a dimension in your cube with IDs of users that can be used to index to personalized data, step two is to create a customized webpart to feed the appropriate parameter into the scorecard webpart based on user credentials.