Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

1344


Part IX: Business Intelligence


FIGURE 59-14
Product Catalog using a Card.

Deploying Power View Reports


Power View reports can be deployed two ways:


  1. Uploading the report defi nition fi le (.rdlx) to a PowerPivot Gallery

  2. Opening and saving the report to the target PowerPivot Gallery.
    When deployed, the entity data source properties need to be modifi ed to point to the cor-
    responding Report Data Source.


In addition, Power View enables you to export the entire report into Offi ce PowerPoint
while conserving all data interactivity and animations. To export a Power View report to
Offi ce PowerPoint, follow these steps:


  1. Open the Power View report titled PicnicItemAnalysis created in the previous
    section.

  2. Click File ➪ Export to PowerPoint.

  3. When the export process completes, click Save and provide a name, for example,
    PicnicItemAnalysisPPT.
    At this point an Offi ce PowerPoint fi le has been created containing the controls neces-
    sary to provide the same interactivity as Power View. Open the PicnicItemAnalysisPPT


c59.indd 1344c59.indd 1344 7/31/2012 10:37:09 AM7/31/2012 10:37:09 AM


http://www.it-ebooks.info
Free download pdf