Creating a Power View report from Power View cubes
With the Dynamics AX 2012 R2 release, there are additional reporting cubes hidden within SharePoint that are not currently linked to the main forms. If you find them, then you are able to create Power View dashboards and reports.
In this example we will show how you can use the Sales cube to build a more elaborate Power View dashboard.
Getting ready
Before you start this recipe, you need to find where the Power View dashboards are stored. You may need to have administrator access to SharePoint for this step. To find the Power View Reports library follow these steps:
Open up any Dynamics AX Role Center, and from the Site Actions drop-down menu in the top left corner, select the View All Site Content menu option:
This will open up the Site Content browser. Here you should be able to see a Power View Reports document library and drill down into the contents to see all of the reports that have been saved, and also all of the available cubes:
