Focal Point
Drilling on Measures to go to lower level

This topic can be found at:

February 23, 2010, 12:18 AM
Drilling on Measures to go to lower level

In our POC scenario, Customer has 4 measures which roll up to single measure. Is it possible to create a measure such that when we click on highest level measure, we can drill down to lower level and see how measures are distributed. For example, HR headcount and how its divided into 4 individual measures. Its a design issue but I am wondering if it can be done in PMF.

February 23, 2010, 10:27 AM
Bob Jude Ferrante
Trying to help you fit this into the model...

Objectives are the way you roll up measures this way. You can name an objective as the measure and place it on your strategy map in a perspective. If this is a non-strategic view you can create just a single perspective called something like "Metrics" and the objective can be named like a Measure.

The Objective would then be set to the weighted aggregate of all the constituent measures.

Your dashboards would then need to show info at the Objective level. You can "gross up" any measures to objectives you want to show at that level in this manner.

Try this and see if it works for you.

Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management

I'll take any questions about PMF - business or technical - anytime!