We are currently running v13.2 (SQL Server 2012) and attempting to run a Web Intelligence report against the project object data. When a report is generated via WebIntelligence, it inserts SQL code to check to see if the user has Project View Management rights.
If the user has global Project - View Management rights, the data returns w/in a few seconds. However, if these are defined at the OBS level, the report hangs and never returns.
Providing global rights is not desired from a functional standpoint. Has anyone come across this issue? and if so, is there an OBS right that I can try to assign to help improve performance? They already have most of the core PM rights along with View Management rights at the OBS level.
Any and all input is appreciated. ThankS