For BI 4.2sp4
I have a Web Intelligence report that is written against the BI platform CMS system database.unx universe that is provided by SAP for reporting against the Repository database.
A member of the Administrator’s group can run the report with issues. The user’s however cannot. When they try to refresh the data in the report, the get “No data to retrieve in Query 1”
The users are granted the following rights:
Universe:
General.General.View objects = Granted
System.Universe (information design tool).View objects = Granted
System.Universe (information design tool).Data access = Graneted
System.Universe (information design tool).Create and edit queries based on the universe = granted
Connections:
General.General.View objects = Granted
System.Relational Connection.Data Access = Granted
System.Relational Connection.Use connection for Store Procedures = Granted
Report:
General.General.View objects = Granted
General.General.View document instances = Granted
Content.Web Intelligence.Export the report's data = Granted
Content.Web Intelligence.Use Lists of Values = Granted
Content.Web Intelligence.Save as Excel or Text = Granted
Content.Web Intelligence.Save as CSV = Granted
Content.Web Intelligence.Save as PDF = Granted
Content.Web Intelligence.Refresh the report's data = Granted
Web Intelligence Application:
Application.Web Intelligence.Data - enable data tracking = Granted
Application.Web Intelligence.Data - enable formatting of changed data = Granted
Application.Web Intelligence.Interfaces - enable Rich Internet Application = Granted
Application.Web Intelligence.Interfaces - enable web viewing interface = Granted
Application.Web Intelligence.Left pane - enable document structure and filters = Granted
Application.Web Intelligence.Left pane - enable document summary = Granted
General.General.Log on to Web Intelligence = Granted
Application.Web Intelligence.Query script - enable viewing (SQL, MDX...) = Granted
Application.Web Intelligence.Reporting - created and edit breaks = Granted
Application.Web Intelligence.Reporting - create and edit conditional formatting rules = Granted
Application.Web Intelligence.Reporting - create and edit input controls = Granted
Application.Web Intelligence.Reporting - create and edit report filters and consume input controls = Granted
Application.Web Intelligence.Reporting - create and edit sorts = Granted
Application.Web Intelligence.Reporting - enable formatting = Granted
Application.Web Intelligence.Reporting - enable merged dimensions = Granted
Application.Web Intelligence.Reporting - insert and remove reports, tables, charts, and cells = Granted
I’m stumped. What am I missing here?