Mass Update of "Load" Option

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: 68 | Location: United States | Registered: March 28, 2007

Bob Jude Ferrante

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, 2003

Ignored post by Bob Jude Ferrante posted

Show Post

Bob Jude Ferrante

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, 2003

Ignored post by Bob Jude Ferrante posted

Show Post

Janice

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: 68 | Location: United States | Registered: March 28, 2007

Ignored post by Janice posted

Show Post