Focal Point
Modify PMF to show dates highest to lowest for all reports and graphs?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/1461084022/m/58910866

April 01, 2009, 10:56 AM
Moogle
Modify PMF to show dates highest to lowest for all reports and graphs?
Hi,

My client is used to reading reports with the newest time periods showing on the left and then historical periods going to the right. A report such as the Rolling 5 Measures (a_5_meas1.fex) shows the time periods lowest to highest.

I can modify a specific report like this:

-*CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC
-* the next row sorts the dates highest to lowest
ACROSS HIGHEST &SORTACR_FIELD_AS
&BY_SORTACR_FIELD_COMBO_TIME_NOPRINT
&BY_SORTACR_FIELD_NOPRINT
-* the next row originally showed the dates lowest to highest
-* ACROSS &SORTACR_FIELD_AS
-*CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC

I DO NOT want to do this for all my reports and charts. What I'm looking for is a way to do this in one place and have it cascade to all / most of PMF. I think the key is the &SORTACR_FIELD_AS variable.

If I can modify the process that builds that variable to include the word HIGHEST, than I think that would do what I want. How is that variable built, and where?

Cheers,

Joey


-WebFOCUS 8.2.01 on Windows
April 01, 2009, 04:34 PM
malapejohn
Hi,

I think it resides in PMF_analysis_parms.fex , I will get back to you with details


-PMF 5.1.2
-WebFOCUS 7.6.9 on Windows 2003 Server
-MSSQL Server
April 03, 2009, 04:21 PM
Bob Jude Ferrante
This would be a nice option. I'll run it by our guys.

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!