Creation of Dynamics AX Cube report (Analysis Report)

Its quite complex to proceed with developing Cube reports from Scratch.

Lets proceed with learning from installation of Analysis server reports

Processing of cube:

·         Install Analysis server and Reporting server component in AX.

·         Enter Analysis server instance name in AX analysis server form.

·         

·         

·         It does not matter if OLAP databases tab does not hold any record(Database).

·         To deploy and process report Tools->Business Intelligence tools-> SQL Server Analysis Services wizard.

·         Run the wizard. Select deploy (If you are going to process existing analysis cube)

·         

·         You will be able to find the existing project available in AX in analysis server project section.

·         Click Next and check process option. It is good to process the analysis server project from visual studio project as it is quite quicker and errors will be detailed. Another advantage is you can have a option to deploy only required cube rather than deploying aall existing cubes through wizard.

·         Finish the wizard.

Let us write a MDX query for Accounts Payable Cube.

Login to SQL Server-> Analysis service->Right Click database

Enter following query and run . You can drag and drop measures and dimensions from left window pane to code editor.

Keep this aside and create a SSRS report in VS and add SSRS report item to this project solution.

Create a Dataset and update the datasource property to DynamicsAXOLAP.

Click Query window and paste the query.

·         Execute the query.

To get all fields in datasource  you must get atleast one record when you executre the query in dialog. If not you will get only measures populated.

Rename the fields and create a design and deploy the report.

Create a output menu item to use this analysis report.