Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Measure(s) by dimension(s)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Measure(s) by dimension(s)
 Login/Join
 
<FreSte>
posted
Hello,

When clicking on a "Perspective", a multidrill-menu is shown with options
"Show by {name of dimension1..n}"
The same is applicable for clicking on an "Objective".

Is this also possible when clicking on a "Measure".
Can we select the clicked measure and have the multidrill-menu also have the
options "Show by {name of dimension1..n}" ??


Thanks,

PMF: Version: 5.2.3 (HF3)
 
Report This Post
Master
posted Hide Post
You didn't provide context but from what you're saying, I'm assuming you're running an analysis designer report on Measures, and grouping by Perspective and/or Objective.

When you run that on perspective you're already looking at Measure data broken out by the dimension you specified in the request. So the Measure menu is giving you a chance to cross-drill into other information. If you break the report out by or across any dimension you'll see the full range of dimensions in the system and you can drill on those to get what you want.

Hope this helps.

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!

 
Posts: 919 | Registered: March 26, 2003Report This Post
Member
posted Hide Post
I have been looking into this and would like to define the 'problem' more specifically.

Generate a Metrics Across Dimension report for All Measures with Rolling 5 Period across Year using Analysis Designer.
This report is saved and added to the Today content for the Executive user.
As an Executive I now want to split one measure out by a dimension and retain the Rolling 5 Period.
Clicking on a measure gives me a multidrill menu, BUT NOT the Show by {dimension} options.

So what are my options using PMF functionality?

1. Add by Objective to the original report (since this does have the Show by {dimension} options).
The shortcoming is when there are multiple measures per objective I get all of them, not just the one I'm interested in.

2. Let the user use the Operational Report... option to generate the required drilldown report.
The user is a one-click Executive. He will not want to use Analysis Designer and certainly does not want to do this every day to generate the same report.

3a. Click on a cell and choose Measure Details.
This gives me the specific measure BUT only for one Year.
3b. Then click on Quarter to select the required Show by {dimension}.
This now gives me the specific measure split out by the dimension of my choice BUT only for 1 quarter (I still want Rolling 5 Year Periods).

4. Last option - Click on the Year in the across heading and choose Show by {dimension}.
You guessed it...


What I really (really) want is that the multi-drill dropdown on a measure name also contains the 'Show by {dimension}' options.


This leaves me with customization (Which is clearly not for the faint-hearted.). So here goes...


Some time later... and yes it now works satisfactorily.

The task was to make a minimum of changes and retain as much of the PMF functionality as was necessary.
I needed to make a new gadget and customize 3 standard fexes. All of this of course in my pmf_custom folder.


The fexes were:
pmf_rpt_tmplt_meas_acrdim.fex
a_get_drill_down.fex
a_get_drill_down_i1.fex

Anyone needing this code please message me here.


Paul Burridge
Senior Consultant
34 years with Information Builders
WebFOCUS 8.2.5 Win10
 
Posts: 17 | Location: The Netherlands | Registered: February 21, 2005Report This Post
Master
posted Hide Post
Paul,
Analysis Designer reports are Content. They tend to be personal content, just for the person who did the design. But you can make them public quite easily.

When logged in as any PMF admin, go to the Manage tab, click Content, and select the Saved report by name from the list.

Now add it to any category in addition to "saved." This makes it an available report. If you add it as a Measures report or an Objectives report, it can be made available as the drill from any Measures report on the "Operational Report" drilldown.

Hope this way of doing things helps you.

thanks


You can then use


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!

 
Posts: 919 | Registered: March 26, 2003Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Measure(s) by dimension(s)

Copyright © 1996-2020 Information Builders