Creating and Deploying Dashboards Remotely

You can create and deploy PerformancePoint dashboards remotely by using several assemblies that are installed with Dashboard Designer. The code example in this article shows how to create a report object and a dashboard object, deploy (publish) a dashboard to SharePoint Server, and retrieve an existing dashboard object by name. Note: Creating and deploying dashboards…

7

Using MOSS Text filter linked to Scorecard to dynamically pass TI formula

Time Intelligence (TI) Filters in PerformancePoint Services for SharePoint provides filtering on data-time values with respect to the current date-time. The limitation, however, is that the formulae need to be defined before the dashboard is published. This article explains how users can have ability to dynamically evaluate any formula after the dashboard is published on…

0

Using the PPSAuthoringService Web Service

Because calling web services remotely is not an officially supported scenario for PerformancePoint Services development, there’s no related information in the SDK. The SDK uses the BIMonitoringServiceApplicationProxy and SPDataStore objects to perform authoring and processing tasks from code running within the SharePoint environment. However, should you choose to author content remotely through the web service,…

4

How do I create or migrate from PerformancePoint 2007 custom extensions for Dashboard Designer in PerformancePoint Services 2010?

Custom editing extensions for Dashboard Designer in PerformancePoint Services 2010 are now implemented using web pages to provide a thin editing environment and a better deployment story.  Therefore, unfortunately, custom extensions for Dashboard Designer 2007 cannot be easily migrated to PerformancePoint Services 2010. The following tables list common DLLs and classes that were used to…

3

Securing PerformancePoint Content in SharePoint

All PerformancePoint content is stored in SharePoint, which makes it easy for employees to share and re-use that content. But what about content that you want to restrict? This article will give you instructions for locking down PerformancePoint content in SharePoint. Note: Data-level security, which allows you to limit the data that users can access…


What Happened to the Pivot Button in the Scorecard Editor?

If you were one of the few people that used the scorecard pivot feature in PerformancePoint 2007 Dashboard Designer, you may have noticed that it is no longer present in PerformancePoint Services 2010.  There are a number of reasons for this.  Most notably, it was not a true pivot, rather it was a transpose.  In…

1

Conversations with data in analytic charts

Today’s post is by Jason Robertson, showing some ways to have a conversation with data using analytic charts in PerformancePoint Services for SharePoint 2010. I built a simple model using Bureau of Transportation‘s Airline On-Time Performance and Causes of Flight Delays and let Jason to go hunting. He built the initial chart using Dashboard Designer…


How to integrate SSRS Reports with Dashboard Filters

PerformancePoint Monitoring Filters work with SSRS reports, both relational and OLAP. To configure a dashboard pages to use common filters to drive SSRS reports and other PerformancePoint views, follow the below steps. For this example, we will configure a dashboard containing one page with one scorecard view (OLAP data source) and one SSRS Relational report…

7

Data source authentication in PerformancePoint Services for SharePoint 2010

PerformancePoint Services supports five types of data sources: Analysis Services Excel Services Excel Workbook SharePoint List SQL Server Table Of the five, only the Excel Workbook data source does not have an authentication model (the workbook is embedded directly into the data source).  The four remaining all support Unattended Service Account and Per-user Identity.  In…

2

Modifying PPS Dashboards with SharePoint Web Parts

In a session I gave at TechReady 10, I talked about the difference between dashboards and dashboard definitions. In the session, I made a point to talk about the difference between dashboards and dashboard definitions. Dashboard definitions are the ddwx files that you’re used to working with when you use dashboard designer. In PerformancePoint 2007,…

8