Planned Performance Improvements for PerformancePoint Server 2007 Planning

There are a few performance improvements planned for SP1 and earlier in an interim hotfix.  The details I have are high-level but enough to get at least a little excited that development is on going and pertinent to ‘in-the-field’ issues.

In an upcoming hot fix (KB946222) expected release prior to SP1 is currently being worked on.

Issue:
When a system contains a large number of assignments, retrieving the list of available assignments for a user has a significant performance issue.

Resolution:
Optimised stored procedure for retrieving assignments to dramatically cut time to retrieve list of available assignments.

Performance issues targeted for SP1 include:

  • Slow performance when re-opening assignment after save/submit.
  • No option to disable what-if calculation on assignment or matrix level which leads to unnecessary what-if queries that slow form performance
  • Successfully submitted change-lists are not automatically from the assignment in the V1 design which leads to unnecessarily large what-if queries
  • MDX query construction optimization
  • Client-Server data volume
  • These are targeted issues and hence they may not make the cut but it’s encouraging all the same.

    Leave a Reply

    Your email address will not be published. Required fields are marked *