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.
Goal: To have the scorecards overview report drill down from perspective go directly to measures skipping objectives (there is only one perspective and one objective per scorecard)
Technique … copied the two programs affected so not to loose original PMF code a_obj_measures.fex a_get_drill_down_persp.fex
Changes to programs.
a_get_drill_down_persp
I changed this program to drill a_obj_measures instead of a_persp_objective and changed the link to say show measures (curr vs prev)
a_obj_measures,
I added the following code after the line –INCLUDE PMF_BOOKLET_DATA
TABLE FILE OBJECTIVES PRINT OBJECTIVE_ID WHERE SCORECARD_ID EQ &SCORECARD_ID ON TABLE SAVE AS HOLDOBJID END -RUN -READ HOLDOBJID &OBJECTIVE_ID.I11
The good news is, it worked the first time I ran the scorecard report and I was able to drill right to the measures, skipping the objectives.
Please advise if this was the correct approach or if I may have broken something down the road.
Thanks!This message has been edited. Last edited by: Bob Jude Ferrante,
WF 8.09
Posts: 68 | Location: United States | Registered: March 28, 2007
You got it right, right off the bat. This would be *exactly* the right way to customize the report to skip the objective level and go right to the measures.
Note that if you intend to upgrade PMF later to a new version, you'll have to preserve this customization if you've used any of the same name programs.
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!