Tip: The AdventureWorksDWMultidimensional model contains two cubes, Adventure Works, and Mined Customers. Replace with the name of your Analysis Server instance.ĭata source= initial catalog=Adventure Works DW Multidimensional cube='Adventure Works' In Connection String, enter the following connection string. In Data Source Type, select Microsoft BI Semantic Model for Power View.Ĥ. On the Data Source Properties page, in Name, type Adventure Works Reseller Sales.ģ. In a SharePoint library with Report Data Source document types enabled, click Documents > New Document > Report Data Source.Ģ. To create the Adventure Works Reseller Sales shared data source (.rsds) fileġ. This task may need to be completed by an administrator. For more information, see Understanding Multidimensional Model Objects in Power View.Ĭreate a shared data source for a data model
Some objects and some behaviors may appear different from the traditional tabular models you may be familiar with. Remember, you are creating a Power View report based on a multidimensional model exposed as a tabular model. If you have the necessary prerequisites installed, you can complete the following tasks to create a shared data source connection to the AdventureWorksDWMultidimensional model, and then create a Power View report with different visualizations to explore Adventure Works data. Use Power View to explore and analyze data in the AdventureWorksDW2012Multidimensional model You should be familiar with how to create and save documents in a SharePoint library. For detailed information and a Power View tutorial, see Power View: Explore, visualize, and present your data. You should be familiar with how to create reports and design views in Power View. For SharePoint Server 2010, Service Pack 1 is recommended.ĪdventureWorksDW2012 sample database is required as a data source for the Adventure Works Multidimensional Model.Īdventure Works Multidimensional Model for SQL Server 2012 deployed to the Analysis Services instance.
Microsoft SharePoint Server 2010 or 2013 Enterprise Edition or later is required. Microsoft SQL Server 2012 Reporting Services in SharePoint Integrated mode with Service Pack 1 Cumulative Update (CU) 4 applied or later. Microsoft SQL Server 2012 Analysis Services running in Multidimensional mode with Service Pack 1 Cumulative Update (CU) 4 applied or later. Note: This feature does not apply to Power View in Excel 2013.
0 kommentar(er)
