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 email@example.com and provide your corporate email address, company, and name.
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.
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!
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.