Database Reference
In-Depth Information
It is important to understand that when you create a Power View report using the
multidimensional model, you are working with a tabular model type representation
of a multidimensional model. Some objects and behaviors may appear different
from the traditional tabular models. For more information on the differences,
see
http://bit.ly/1djQlt4
.
Power View within Excel 2013
This section describes using Power View within Excel 2013, which requires the
ProPlus Edition of Office 2013. Note that Power View is not supported within
Excel 2010 or earlier versions.
Setup
Power View is an add-on in Excel 2013 that you can enable by following these steps:
1.
In Excel, navigate to
FILE
|
Options
|
Add-Ins
.
2.
In the
Manage
box, click on the drop-down arrow and select
COM Add-ins
.
Now, click on
Go
.
3.
Check the
Power View
checkbox and click on
OK
.
If the Power View add-on has not been enabled, it will be grayed out on the Excel
Insert
menu.
Data models
Excel 2013 (ProPlus Edition) now has native support for data models. A data
model is a brand new approach to integrating data from multiple tables, in essence,
building a relational data source right inside an Excel workbook. The data models
are used transparently to provide the tabular data used in a Power View report.
