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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Input Measure Values on multi-drill menu when click a Measure name [SOLVED]

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Input Measure Values on multi-drill menu when click a Measure name [SOLVED]
 Login/Join
 
Gold member
posted
We always have the "Input Measure Values..." choice on the multi-drill menu that drops down when we click on a Measure name on any PMF view.

Looking at the code "a_get_drill_down_meas.fex", it has

-IF (&SHOW_MEASURES_ENTRY EQ 'N') THEN GOTO :A_GDDM_SK3 ;
DRILLMENUITEM=&MD_MEASVALINPUT.QUOTEDSTRING, FOCEXEC=measures_entry_frames( \
SCORECARD_ID = &SCORECARD_PARM \
TIME_RANGE = '&TIME_RANGE' \
RECORD_TYPE = RECORD_TYPE \
PM_MEAS_SRC_MEASURE_SERIES_Edit = &MEASURE_SERIES_FIELD), TARGET=&PMF_DRLL_TGT,

-:A_GDDM_SK3


Should this logic prevent the menu item to be displayed when we clik on a Measure that isn't User Enetered, but Loaded?

Thank you,
Endre

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


WebFocus 7.6.8
iWay Data Migrator 7.6.8
PMF 5.1
 
Posts: 83 | Registered: March 28, 2006Report This Post
Master
posted Hide Post
No, this would only let you globally show or hide the menu item. That flag is set at the top of the a_get_drill_down_meas FOCEXEC, so it's either always-on or always-off. You cannot use a single Dialogue Manager vars to do this because it is not sensitive intrinsically to the DB value; it's not data-dependent.

We haven't tested if WebFOCUS Conditional Styling can be used with multi-drill menus, but maybe that's the way to do it? Could you use conditional styling to hide or show a menu item depending on the measure's being loaded or user-entered? Conditional styling would let you create a test of the measure's acquire-type and style the column to include the menu item if it's user-entered. (in PM_MEAS_SRC the column is RECORD_TYPE; if RECORD_TYPE ='U' then it's user entered, if it's 'L' it's loadable).

Try it out and let us know if this works for you; if it does maybe we could integrate it into PMF. It would definitely be better if the menu would only appear when needed - right now if you select the menu item on a loadable type measure you get a pop-up telling you it's not user-enterable.

Note that in the near future we're splitting the loader up so that you will be able to enter some of the data and load other data. For example you could specify that targets are user-entered (and with security they could only be entered by planners) and actuals are loaded. Relatedly you'd be able to specify that actuals are loaded from one place and targets from another. This project is planned for 2010.

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
Gold member
posted Hide Post
Thank you,
Since the pop up ( that tells us that it is not user enterable) works, we might just stick with it for a while. But on my own test environment I will try to use the (PM_MEAS_SRC / RECORD_TYPE; if RECORD_TYPE ='U' then its user entered, if it's 'L' it's loadable) route.

Splitting the measure into loaded and user entered will be great. We always have actuals in source systems, but not always the targets.

Take Care
Endre


WebFocus 7.6.8
iWay Data Migrator 7.6.8
PMF 5.1
 
Posts: 83 | Registered: March 28, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Input Measure Values on multi-drill menu when click a Measure name [SOLVED]

Copyright © 1996-2020 Information Builders