Creating a Power View report from Dynamics AX
The Dynamics AX 2012 R2 release has links to Power View embedded directly into the application, allowing the users to create their own reports and dashboards with just a click of a button.
In this quick recipe, we will show how you can quickly create a report directly from the Dynamics AX application.
Getting ready
In order to work through this example, you need to be running Microsoft Dynamics AX 2012 R2, or later.
How to do it...
To create a simple ad-hoc report from Dynamics AX, follow these steps:
Open up the Customers list from within Accounts Receivable.
In the far right corner of the ribbon bar, in the Customer tab there is an Analyze data button. Click on this button to open up Power View:
When the Power View window opens up, find the Accounts receivable open transactions measure from the field list on the right and select the checkbox to add it to the report canvas:
Find the Month dimension that is in the Transaction Date group in the field list...