Figure 7
Using the Map Control
Other New SP1 Capabilities
There are a few more important new Power View capabilities intro-
duced in SQL Server 2012 SP1:
• Key Performance Indicators. KPIs that are defined in PowerPivot for
Excel or a tabular instance of SSAS will now show up in the Power
View field list, which means you can display the KPI status indica-
tors in a table or matrix. However, KPIs won’t show up if you’re
working against an Excel 2010 workbook. They’re visible only with
Excel 2013 workbooks or with a tabular SSAS database that has its
Compatibility Level property set to SQL Server 2012 SP1 (1103).
• Hierarchy support. The hierarchies have the same visibility requirements as KPIs. If these requirements aren’t met, they won’t show
up in the Power View field list. Unlike an Excel PivotTable, Power
View doesn’t display hierarchies in a table or matrix with an
expandable/collapsible icon. Rather, the hierarchies simply make
