I'm at a WF 7.6.4 client who would like expand the report to show a rolling six periods. In the a_5_meas1.fex there is a -SET &TIME_RANGE = '5PR'. The gut said to change that to '6PR' but the result was a FOCUS error:

0 ERROR AT OR NEAR LINE 327 IN PROCEDURE êƒfRNGEFOCEXEC *
(FOC295) A VALUE IS MISSING FOR: &TIM_6PR_LEVEL

How could I readily convert the a_5_meas1.fex to a_6_meas1.fex to get a rolling six months?

Thanks in advance,
Sandy Kadish

In PMF/PMM, trends are represented by objects called Time Ranges. These allow you to globally set up trends that all your users can consume.

If you are in PMF/PMM as a PMF administrator, you have access to the Administration tab, where you can create new Time Ranges at will.

Have a look at the Time Range used in the Rolling 5 Period report (and many other places) already set up - it's called "Rolling 5 Period." Take a screenshot of those settings.

Note especially the Abbreviation field is set to 5PR. Look familiar? Yes. That's the value that the amper was set to. The reason typing in 6PR didn't work is, there is no Time Range with that abbreviation.

So now, create a new Time Range. Copy the settings except change the Start Value to -5 instead of -4. Name it "Rolling 6 Period" and give it an abbreviation of 6PR.

Now you can consume it in your new Rolling 6 Period report.

And what's more, you can use it anywhere else you want in PMF - for example, if you're looking at a flexible trending grid, or trending chart, you can select it as the Time value to use, and the report will dutifully trend those 6 periods. Note I said "periods" because it will flexibly trend at any time level - Year, Quarter, or Month. You could also design one that specifies the Time Level - like the "Last 5 Quarters" Time Range does...

Cool, ain't it?

Bob -
Thanks - worked like a charm. The customer is satisfied. Note to self and others - make sure to change the description in the Launch Pages so that the dropdown matches the new version.

Nice. Happy customers are the best thing in the world.

Hopefully you named it a_6_meas1.fex, and created new HTML components for it, etc. and stored it in your PMFCUSTOM folder so it doesn't get overwritten when they upgrade.

Just making sure we all follow standards, this way we don't get in trouble in the future.