Monday, 17 November 2014

How to find out why a cube based report isn’t working [AX 2012]

Lets say the Vendor top 10 report is throwing an error and you find out that it is based of the OLAP. You are sure you have deployed your cube and it is working.

Open up the report in visual studio and go to the datasets. You will see the data source is DynamicsAXOLAP and there is a query. Copy the query.

clip_image002

Go to SQL management studio and create a new query (mdx query – by connecting to your cube database).

Paste the query and change any parameters – in this case I changed the company and the date (hard coded it in the query).

Then Execute the query – you should see a result at the bottom. You will see some of the reports are depended on multiple cubes. Even though you were not using the General ledger cube the report uses it to retrieve the dates.

clip_image002[6]

No comments: