Focal Point
[closed] Summarization options

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/7237009516

January 26, 2012, 03:13 PM
Moogle
[closed] Summarization options
Hi Team,

There's an option on the Manage tab under Settings | Summarization called Multi-Level Dimension Display. The description says:

"Display data at lower levels of non-Time dimensions than measured"

Does this have anything to do with having Actual values at a certain level of a dimension and having Target values at a different (higher?) level? I'm envisioning a situation where a Plan is set at the top of a dimension, but the client wants to drill down past the plan to see very granular Actual values. Until I saw this option, I did not think this was possible, and now I'm wondering.

Additionally, there is a related but different scenario where the Actual values have more dimensionality than the Plan values. I'm rather certain this is not possible in PMF, but since we're on this topic, perhaps you can confirm that?

Cheers,

Joey

This message has been edited. Last edited by: Moogle,


-WebFOCUS 8.2.01 on Windows
January 26, 2012, 03:20 PM
Bob Jude Ferrante
No, actuals and targets have to be stored at the same level of dimensionality. PMF can't allocate high level targets down to lower levels, that's for your planning system to do.

In 5.3.2 using the new Datapoint model you'd be able to set things up like this, but you wouldn't be able to report that measure lower down. You still need some way to allocate data down to the proper level for those targets.

We recommend you have the sponsor show you how they do it now.

thanks


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

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

January 26, 2012, 03:38 PM
Moogle
Hi Bob,

This confirms my understanding, so thank you.

I wonder though, about that option I mentioned... What does it actually do?

Cheers,

Joey
January 26, 2012, 03:54 PM
Bob Jude Ferrante
If you're looking at multiple SEPARATE measures loaded at different levels, as you drill down into the dimensional structure, it carries the higher up loaded measures down so you can still see them. They're clearly marked as being from a higher level.

It's in the doc too... :-)


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

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