Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Mass Update of "Load" Option
Go
New
Search
Notify
Tools
Reply
  
Mass Update of "Load" Option
 Login/Join
 
Gold member
posted
We have 30 measures we are updating in PMF. There are times when we need to do a "Full Refresh" and other times when we want to do Add/Replace/Delete.

Is there a way to do a global change for all measures without having to open each measure. The issue with opening each measure and changing the load option is that the prefix code can run for quite a while on each measure.

Thanks.


WF 8.09
 
Posts: 70 | Location: United States | Registered: March 28, 2007Reply With QuoteReport This Post
Master
posted Hide Post
No way to do it now in the shipped product. But it's a good idea. We'll look into it for the future - but such a thing would not get into product in 2009.

You could of course make a form to do this. The table that contains this data is PM_MEAS_SRC_LOADPARMS, the field that contains the parameter is MEAS_LOAD_TYPE, an A1 field.

Try running this to get an idea how it fits together. You can also see the alpha values that correspond to the items you see in the dropdown by scanning this.
JOIN PM_MEAS_SRC_LOADPARMS.MEASURE_SERIES IN PM_MEAS_SRC_LOADPARMS TO PM_MEAS_SRC.MEASURE_SERIES IN PM_MEAS_SRC AS J1
END
-RUN
TABLE FILE PM_MEAS_SRC_LOADPARMS
PRINT MEAS_LOAD_TYPE
BY MEASURE_SERIES_NAME
ON TABLE HOLD
END
DEFINE FILE HOLD
DISP_MEAS_LOAD_TYPE/A70 = DECODE MEAS_LOAD_TYPE (
A    'Full Refresh'
B    'Add new, replace actual/target'
C    'Add new, increment actual/target'
D    'Add new, replace act/targ, delete old'
E    'Add new, increment act/targ, delete old'
ELSE ' ') ;
END
TABLE FILE HOLD
PRINT DISP_MEAS_LOAD_TYPE
BY MEASURE_SERIES_NAME
END

Hope this helps. And thanks for the feature idea.


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, 2003Reply With QuoteReport This Post
Master
posted Hide Post
You could automate this in batch without needing a form by doing a MODIFY also... FREEFORM the 'A' value in to force all to full refresh; FREEFORM the 'D' value in to force all to Add/Replace/Delete. How's that for an idea? You could do that in a couple hours. Make sure to use COMMIT and ROLLBACK in case there's a problem - you don't want to mess up the data mart.

best


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, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
Is there anyway to turn off the execution of the prefix code before the measure loader appears? That would make clicking the 30 measures much faster.


WF 8.09
 
Posts: 70 | Location: United States | Registered: March 28, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    Mass Update of "Load" Option

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.