Hi,
I built a simple cube with dynamic security implemented on it by using custom data. I added a data connection using a role with "unattended service account and add authenticated user name in connection string" in dashboard designer and a report based on it which is displaying fine through the sharepoint BI site.
Now I tried implementing in the same way the dynamic security on a different cube on the same server, different DB. Added roles appropriately. In the dashboard designer I created a data connection in the same way as before and on testing the connection is successful. When I create a report based on this connection I get "Error running data source query. Contact the administrator for more details" in the design preview pane. In the details pane under dimensions/ measures I get error: "You do not have permissions to see this data. Additional information has been logged for your administrator".
(The dynamic security logic in both DS is the same, giving the same users the same permissions).
Same role members in both of the above cases. Same BI site.
One's working and one's not.
What can be the problem?
The detailed error on the server is:
Exception Message: Error running data source query. Inner Exception Message: Stack Trace: at Microsoft.PerformancePoint.Scorecards.Server.PmServer.ExecuteAnalyticReportWithParameters(RepositoryLocation analyticReportViewLocation, BIDataContainer biDataContainer) at Microsoft.PerformancePoint.Analytics.ServerRendering.OLAPBase.OlapViewBaseControl.ExtractReportViewData() at Microsoft.PerformancePoint.Analytics.ServerRendering.OLAPBase.OlapViewBaseControl.CreateRenderedView(StringBuilder sd) at Microsoft.PerformancePoint.Scorecards.ServerRendering.NavigableControl.RenderControl(HtmlTextWriter writer) PerformancePoint Services error code 20604.</Data>
Please a