I have been working with a similar situation and was hoping you had found a solution. Have seen many postings about changing the BSM server web.config file key BPM.ConnectionPerUSer to a value of true but this seems to have no effect. Have also seen posts about using Kerberos authentication but my implementation is on a single box so there are no two-hop issues that I can see.
Have you made any further progress since 07/24/2006?
quote:Originally posted by saikrishna_80
I have developed a web part which contains a KPI scorecard using Business Scorecard Manager.
I have developed a cube using Analysis Services. I am developing a KPI scorecard using BSM 2005. In my cube i have defined the role based access for all the users logging into the Sharepoint Solution.
Let me give an example
I have KPI scorecard which shows a KPI for page filters Organization , Product and time period ( Which are dimensions in my cube)
When i view the KPI scorecard in the solution the Organization page filter is showing up all the organizations. For example if i login as MfgPlant1 user it should show only Plant1 and its suppliers. But it is showing all the organizations. Even though role based access has been defined in the cube it does not seem to reflect in the BSM scorecard.
Please give the solution for this as soon as possible.