White paper: Planning Server design basics

PerformancePoint Server 2007

Updated: 2008-11-06

When you design your Microsoft Office PerformancePoint Server 2007 Planning solution, you will need to make many decisions depending on the organizational architecture of your company. In PerformancePoint Server Planning Business Modeler, you can emulate the organizational structure that most closely represents how you do business. The whitepaper, PerformancePoint Planning Design Basics, provides best practices and considerations for designing your Planning solution and an overview of the types of models, dimensions, hierarchies, input forms and output forms involved. The following are some of the decision points discussed:

  • Multiple model sites versus multiple applications

  • One large model versus several smaller models

  • What dimensions to use

  • Aggregation versus rules

One example of a best practice is the suggestion to create an “import” model for simplifying the extract, transform, and load (ETL) process by using the model to import very granular source data. Other guidance will help you improve performance. To learn more about how to plan an application, see Planning an application.

Consider also reviewing the following related Planning Business Modeler topics.