Recently we were having problems to get the Role Center up and running. Report Server is setup and working in a correct way. Most reports can be generated, but a few does not answer correct. For those report the following error is generated: “Query execution failed for data set 'Company'” Reports in Role Center can not be accessed. Even those that default company was set in Business Connector Configuration Utility and on the connection tab correct AOS was set up we were still not able to make report working. The root cause of this problem was that cubes in OLAP database DynamicsAX were not processed. To solve the problem we were following WhitePapers which let us configure cubes and Role Center:
The way how we troubleshoot the problem was following. We had problem with report ProjUtilizationEffeciencyEmpl.
Report ProjUtilizationEffeciencyEmpl is based on Project Accounting Cube.
If Company data set cannot be processed it seems there is something wrong with this cube. Company data set is called with following query: