Planning Considerations for Loading Dimensions

As an administrator, you need to design dimensions that will satisfy the needs of all groups across the organization. You should design dimensions so that you can adapt them in the future as necessary.

In PMF, metrics cascade from higher aggregated levels down through levels of responsibilities. They allow employees at all levels to track their own progress to see how their work integrates with the overall enterprise strategy. As you plan what levels of dimensionality you will need, think of levels of responsibility rather than levels of analysis and sketch those levels out. You should do this before you use the tools to design how dimensions are physically loaded in PMF. For details about sketching dimension levels, see Designing a Simple Dimension Load.

Analyze all measures to load and make sure that your dimension structure accounts for the different ways your users will want to slice and dice the data.

Before you can load dimensions, you must answer the following questions: