Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Salvo(z) SQL

Adam and Jennifer Salvo are IT professionals with over 10 years of diverse experience. Jennifer is a Business Intelligence developer focusing on the Microsoft BI stack (SSIS, SSAS and SSRS). Her prior work experience includes software development, systems analysis, end-user support, training, and SharePoint administration. Adam is a .NET technical lead with a current emphasis on Dev Ops and Windows Azure. His prior work experience includes .NET development, SQL Server administration, and BizTalk development. They also maintain a personal blog at salvoz.com.

Adding PerformancePoint Dashboard Content to SharePoint

Microsoft SharePoint Server 2010 provides several options for creating Dashboards using PerformancePoint content. 

The first option is to implement the dashboard in PerformancePoint Dashboard Designer.  In PerformancePoint Dashboard Designer, you create components such as Filters, Analytics Charts, Analytics Grids, Scorecards and KPIs.  Once you’ve built the individual components, you can then create a Dashboard containing any combination of these components and create connections between the components.  

The first step is to create the individual dashboard content (Filters, Analytics Charts, Analytics Grids, etc.) in PerformancePoint and save the content to a ‘PerformancePoint Content List’ in SharePoint.  To save the content to SharePoint, simply click ‘Save’ within PerformancePoint Dashboard Designer.

 image

Next, you create a Dashboard in PerformancePoint Dashboard Designer that contains  the desired content and deploy the Dashboard to a ‘Dashboards Library’ in SharePoint.

 image

To deploy a Dashboard from within PerformancePoint Dashboard Designer to SharePoint, follow the steps listed below:

  1. Open the Dashboard file in PerformancePoint Dashboard Designer and click the ‘Properties’ tab.  Confirm the the deployment properties are correct:DeploymentProperties
  2. Right click on the Dashboard component in the left hand Workspace Browser and select ‘Deploy to SharePoint’.
    image 

The following is an example of a Dashboard created in PerformancePoint Dashboard Designer:

PerformancePoint dashboard

The second option to add PerformancePoint content to SharePoint is to create a Web Parts page in SharePoint and add various PerformancePoint Web Parts.  In this case, you still create the dashboard content (Filters, Analytics Charts, Analytics Grids, etc.) in PerformancePoint Dashboard Designer and save the content to a ‘PerformancePoint Content List’ in SharePoint. 

Instead of creating the Dashboard within PerformancePoint Dashboard Designer, the dashboard is built by inserting PerformancePoint Web Parts to a page in SharePoint and creating any necessary connections between the web parts (such as connecting a filter to charts or tables). 

To add a PerformancePoint Web Part to a SharePoint page, click ‘Add a Web Part’.

image

A Web Parts pane opens where you can select the Web Part you want to insert.  In the ‘Categories’ section, select PerformancePoint.  The associated PerformancePoint Web Parts are displayed on the right.

image

Select the appropriate Web Part and click ‘Add’ to add the Web Part to the page.

Continue adding Web Parts to the page until all desired content is included.  You can re-arrange the order and layout of Web Parts as needed.

Once the necessary Web Parts are added, you can create connections between Web Parts.  For example, you can connect a PerformancePoint Filter to one or more charts or grids.

To connect a filter to an Analytics Grid or Analytics Chart, follow the steps listed below:

  1. Click the drop-down on the appropriate PerformancePoint filter Web Part and point to ‘Connections’.
    image 
  2. Point to ‘Send PerformancePoint Values To’ and select the Web Part you want to send the filter values to, such as an Analytics Grid or Analytics Chart.  You should now see a form to configure the connection, similar to the one shown below:image
  3. In the ‘Source Value’ field, select the filter value you want to send.  A few options are DisplayValue, MemberUniqueName and Formula.
  4. In the ‘Connect To’ field, select the parameter in the report or chart to receive the Filter value.  In this example, I am sending the filter value to a parameter called ‘Calendar’.
  5. Optional:  You can also specify a Connection Formula.  For example, if you want to filter by the last 12 months, click the ‘Connection Formula’ tab and type Month-12:Month (to learn more about Time Intelligence Connection Formulas, check out this page).
  6. Click ‘OK’ to create the connection. 

In addition to connecting PerformancePoint Filters to Analytic Grids and Analytics Charts, you can also create connections between filters for cascading parameter behavior (such as sending Continent filter data to a Country filter).

To create cascading filter behavior, follow the steps listed below:

  1. Click the drop-down on the appropriate PerformancePoint Filter Web Part and point to ‘Connections’.
    image 
  2. Point to ‘Send PerformancePoint Values To’ and select the Web Part you want to send the filter values to, in this case select another Filter. You should now see a form to configure the connection, similar to the one shown below: image
  3. In the ‘Source Value’ field, select MemberUniqueName.  In the ‘Connect To’ field should contain ‘EndPoint_Filter_NonEmpty’.
  4. Click ‘OK’ to create the connection.

Comments

Leave a comment on the original post [salvoz.com, opens in a new window]

Loading comments...