Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

PerformancePoint Services 2010 new functionality

Posted by denglishbi on November 5, 2009

I posted the link and information in regards to what was posting in the BOL in regards to What’s new for PerformancePoint Services (SharePoint Server 2010).  I just wanted to add on to the list of items and this is most likely either going to change or new items will be added over the next 6 to 8 months until the official release.

Items that have been removed from PPS 2010:

  • PPS repository – has now been transitioned into SharePoint (along with versioning)
  • Preview site – items will simply be deployed to SharePoint now
  • ODBC data source – will need to leverage SharePoint BDC (BCS in 2010) to get at this data (including Oracle now), create your own data source, or use Linked Server
  • OWC – long over due, so this brings the end to the PivotChart, PivotTable, Trending Chart – replacement will be Excel Services and data mining functionality in Excel
  • Planning – last update was the recent SP3 release for PPS 2007
  • Preview button in analytic reports during design time – access this through the right-click menu now

Items that have been added in PPS 2010:

  • PPS as a SharePoint Service just like Excel (and now Visio and Access)
  • Leverage SharePoint security – no additional PPS security anymore, permissions have been removed from the properties tab and no more PPS roles
  • SharePoint versioning – not separate anymore
  • Authentication security for data sources – security not global anymore in PPS, this can be configured at the data source level – if Farm option was chosen for SharePoint and still single server install then you will need to configure Kerberos if you want to use Per-User security option
  • Decomposition tree – this can be accessed through right-click in analytical reports and scorecards (goes from left to right instead of top to bottom) and this leverages SilverLight functionality, includes data bars, ability to send slices into analytical items to further analyze or export to PowerPoint or Excel, and more that can only be demoed. Unable to currently select this as an initial content type item and Performance Maps still not included (except for ProClarity)
  • Analytical Pie Charts – no longer have to use ProClarity for this
  • Select measures – within Analytical items you will now be able to add and select additional measure if you want to incorporate them into an existing analytical report that has already be deployed that you are using in a dashboard.  Unable to save this change outside the dashboard designer, but you have this new ability which is really nice
  • Drilling capability on the bottom axis of analytical items – now able to right-click on the bottom access members and drill down, drill up, drill to
  • SSAS conditional formatting support (color and font aware) – ability to leverage the predefined conditional formatting that is setup in SSAS in analytical items and scorecards
  • Enhanced scorecards – support for expand collapsing hierarchies on scorecards, additional filtering and sorting support (similar to Excel – select Top or Bottom N records), ability to place KPI names on columns or rows along with Actual/Target values, ability to have multiple actuals within a KPI and new feature to relate the values to each other now (connect them to each other), use multiple data sources in a single calculation
  • KPI Details content type – ability to view metadata about a particular KPI like the person responsible, threshold information, banding, etc.
  • Central Administration configuration – application settings are now done in application settings (like caching, default member limit – 5000 now instead of 500, but can be modified)
  • Increased MUI support
  • Filters – 1st class citizens now and are their own content type with ability to reuse across dashboards
  • Streamlined deployment of dashboards – ability to simply deploy to SharePoint specifying the library and master page (no more five click deployment and then closing down the wizard when it is done…yeah!)
  • Improved dimension support in Details section in Dashboard Designer – no longer a field list like Excel 2003.  This will be UDM aware and you will also be able to filter the list based off measure groups now also
  • ‘Secure Store’ authorization (single sign-on) option
  • PPS elements are now content type stored in SharePoint lists.  You will now need to maintain and arrange items accordingly in the workspace and lists to organize them (no longer separate Indicators, Data Sources, Reports, Scorecards, KPIs, Dashboards distribution
  • Ability to use filters with other SharePoint web parts
  • Ability to re-use and reference existing KPI values when setting up additional values (actual or targets) and then you can tweak them accordingly to help streamline the process
  • Instead of Publish option you now have Save (Publish = Save)
  • Instead of communicating with PPS web service URL you communicate with SharePoint site URL
  • Ability to relate the PPS web parts to other SharePoint parts so that they can interact with each other now (using the same framework now)

For some screenshots of these new capabilities take a look at this posting on the PPS site from this morning – New Features in PerformancePoint Services 2010.

Stay tuned for more changes to come based on feedback.  Participate with the public beta that comes out this month (don’t forget that this is only supported on x64 now and requires x64 SQL Server also).  You can register for the beta that will be coming out this month here – Pre-register for SharePoint 2010 Beta.

Check out the online documentation for additional information and updates as the product evolves even more – What’s new for PerformancePoint Services (SharePoint Server 2010).


6 Responses to “PerformancePoint Services 2010 new functionality”

  1. Kurt said

    "like caching, default member limit – 5000 now instead of 500, but can be modified) " – is this in relations to the filter on sharepoint dashboard pages?Do you have instructions for modifying this? We’re implementing 2010 now :)

  2. Dan said

    Yes, this is in regards to the number of members that can be displayed in a PPS filter in 2010. To get at this setting you will need to go into Central Administration–>Application Management–>Manage Service Applications–>click on your PerformancePoint Services application to manage it–>and then access the PerformancePoint Service Application Settings. Now you can scroll down to the Filters section and you will see the maximum members setting which by default is now 5000 members.

  3. Abhinav said

    Hi Dan,

    I know it sound stupid but I’ve a requirement wherein I want to show more than 5000 members in a filter. Is it possible. If yes How?

  4. Jey said

    Hi Dan, Its good to know this new features with PPS 2010.

    We are still using PPS 2007. Is there any way to increase the filter item limit? In my case, the dimension attribute has more than 2000 values; and I would like to add the member selection type filter in the scorecard. Any suggestion?

    Thanks, Jey

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: