I am trying to setup Power View with AX now that SQL 2012 CU4 supports power view with multidimensional models. According to technet documentation, the 'Power View Reports' document library should automatically be deployed in enterprise portal.
Go to the Power View Reports folder of your Enterprise Portal site. The URL for this folder is typically http://<SharePointServerName>/sites/DynamicsAX/Power%20View%20Reports.
Data source connections are created automatically when you deploy role center pages to Enterprise Portal. You can browse the Power View Reports folder to see the data source connections that already exist. For information about creating and deploying role center pages, see How to: Create a Role Center.
There is no 'Power View Reports' document library or existing data source connections when I deploy the default enterprise portal setup. I can verify that they do exist on the Contoso VPC but I cannot seem to duplicate the setup.
Here is an example from the Contoso VM:
Do I need to create the document library and data sources manually on my implementation?
I believe the document library is created automatically when you deploy the PowerViewDataSourceGeneratorPV page definition. I believe this also deploys the data sources for the Accounts Payable, Accounts Receivable, GL, and Sales cubes. (To connect to the other cubes, you'll need to create a data source manually, as documented here: technet.microsoft.com/.../jj933492.aspx).
Sorry I wasn't able to help you resolve your issue,
You can recreate/deploy datasource by deploying \Web\Web Files\Page Definitions\PowerViewDataSourceGeneratorPV page definition. For detail, see following link
Did you follow my other post to setup powerview? TechNet documentation is not covering everything, as far I remember I got same error due to not configure SQL PowerPovit tool. also open Dynamics AX and check following method exist or not, if not, you have create a new method:
public static void removeFromCache(str key)
key = strLwr(key);
classFactory.lastValueDelete('', '', UtilElementType::Enum, key);
+31 6 147 989 53
3905 PE - Veenendaal
OTHER CONTACT INFORMATION
Did you find a solution stuck at same...
Anbody found solution to this? Please help
Have you installed AX CU6? You may need to redeploy some page definitions and generate incremental CIL. Please see the steps listed in the prerequisite section here: technet.microsoft.com/.../jj933492.aspx.
Hope this helps!
I have Installed CU6 Compiled, Generated incremental CIL.
My and MikeG313 have same issue. I don't see the report data source in Power View Reports Library. I also created the Power View Reports Library manually.
Do we need to create the document library and data sources manually? Did I miss anything while deploying EP?
I am trying to deploy PowerViewDataSourceGeneratorPV , but neither it creates the Power View Library nor any Data Source. I am able to create Data Source manually and able to add Power View reports to EP Pages..
Any advise ?