PMF 5.1.2 with Oracle
Source: Banner ERP

Custom Time Dimension (loaded from external table)

Time Dimension is defined as : Year/Month/Week

Default Time Level: Year

Measure is loaded at Month Level

Page: Measures-Previous vs Current

Page displays measure correctly:

Current Year (2009) % of Trg : 83.1% (Yellow)
Current Year Actual 45.33
Current Year Target 54.57

Previous Year (2008) % of Trg : 92.4% (Yellow)
Previous Year Actual 28.66
Previous Year Target 31.02

Variance -9.4%
Trend Down

==============================
I have Data loaded for 2009/01 and 2008/01
I click on DIM tree Time on left selecting the following date --> 2009/01 and I get the following screen.
What is the cause? thnx

--------------------------------------------------------------------------------

No HTML Output!

--------------------------------------------------------------------------------


-******************************************************* Running filters.fex ***************************************************
-*** a_defaults is in:
E:\ibi\apps\pmfdata\a_defaults.fex
SET KEEPFILTERS = ON
FILTER FILE PMF_MEAS_SRC_PROPERTIES_VW CLEAR
NAME=DFLT
WHERE (RECORD_TYPE NE 'J') ;
WHERE (SCORECARD_ID GE 0) ;
END
SET FILTER = DFLT IN PMF_MEAS_SRC_PROPERTIES_VW ON
FILTER FILE TIME_RANGES CLEAR
NAME=SYST
WHERE NOT (TIME_RANGE_ABBR IN ('PRV_NX_Y_Q', 'PRV_NX_Y_M')) ;
END
SET FILTER = SYST IN TIME_RANGES ON
APP FILEDEF TRANSLOG PMFDATA/TRANSLOG.LOG (APPEND
APP FILEDEF STD_METRICS PMFLANG/en_std_metrics.csv
APP FILEDEF LAUNCH_PAGE_TYPES PMFLANG/en_launch_page_types.csv
-********************************************************* End filters.fex ***********************************************
SET GRAPHSERVURL=http://webfocus4.ad.davenport.edu:80/ibi_apps/IBIGraphServlet
SET GRAPHENGINE=GRAPH53
? PATH
BASEAPP = E:\ibi\apps\baseapp;
APPHOLD = E:\ibi\srv76\wfs\edatemp\ts000186;
APPPATH = E:\ibi\apps\mainstreet;
E:\ibi\apps\pmfdata;
E:\ibi\apps\pmfdemo;
E:\ibi\apps\pmfora;
E:\ibi\apps\pmfgadgets;
E:\ibi\apps\pmflang;
E:\ibi\apps\pmf_custom;
E:\ibi\apps\baseapp;
-******************************************************************************************************************************
-******************************************************************************************************************************
-*** This report is in:
WHENCE TODMEAS1 FOCEXEC
E:\ibi\apps\mainstreet\todmeas1.fex
-* START TIME: 2009/07/26 17:02:53.296000
-************************* Starting row_lvl_sec.fex
-************************* End row_lvl_sec.fex
TABLE FILE SCORECARDS
WRITE CNT.SCORECARD_ID/I4
ON TABLE SAVE AS SCRCDCNT
END
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1
ALPHANUMERIC RECORD NAMED SCRCDCNT
0 FIELDNAME ALIAS FORMAT LENGTH
SCORECARD_ID SCORECARD_ID I4 4
TOTAL 4
TABLE FILE SCORECARDS
PRINT
SCORECARD_NAME
SCORECARD_TYPE
WHERE (SCORECARD_ID EQ 1) ;
ON TABLE SAVE AS SCRCRD
END
0 NUMBER OF RECORDS IN TABLE= 1 LINES= 1
ALPHANUMERIC RECORD NAMED SCRCRD
0 FIELDNAME ALIAS FORMAT LENGTH
SCORECARD_NAME SCORECARD_NA> A50 50
SCORECARD_TYPE SCORECARD_TY> A1 1
TOTAL 51
SCORECARD_ID: 1 SCORECARD_NAME: Davenport University SCORECARD_TYPE: P
-* ************************************************** Starting pmf_booklet_data ********************************************
FILEDEF PASS1 CLEAR
FILEDEF PASS1 CLEAR
FILEDEF PASS2 CLEAR
FILEDEF PASS2 CLEAR
FILEDEF PASS2A CLEAR
FILEDEF PASS2A CLEAR
FILEDEF PASS3 CLEAR
FILEDEF PASS3 CLEAR
FILEDEF PASS3 CLEAR
FILEDEF PASS3A CLEAR
FILEDEF PASS3A CLEAR
FILEDEF PASS3A CLEAR
FILEDEF PASS4 CLEAR
FILEDEF PASS4 CLEAR
FILEDEF PASS4A CLEAR
FILEDEF PASS4A CLEAR
TABLE FILE DIMENSIONS_TYPE
PRINT
DIMENSION_TYPE
DIMENSION_TYPE_NAME
DIMENSION_NUMBER
DIMENSION_LEVELS
TIME_DIMENSION_FLAG
DIM_TLRNC_FLAG
DIM_WGHTNG_FLAG
BY DIMENSION_NUMBER NOPRINT
WHERE (DIMENSION_LOADED_FLAG EQ 'Y') ;
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SAVE AS DIMTYPES FORMAT ALPHA
END
0 NUMBER OF RECORDS IN TABLE= 7 LINES= 7
ALPHANUMERIC RECORD NAMED DIMTYPES
0 FIELDNAME ALIAS FORMAT LENGTH
DIMENSION_TYPE DIMENSION_TY> A1 1
DIMENSION_TYPE_NAME DIMENSION_TY> A50 50
DIMENSION_NUMBER DIMENSION_NU> A2 2
DIMENSION_LEVELS DIMENSION_LE> I11 11
TIME_DIMENSION_FLAG TIME_DIMENSI> A1 1
DIM_TLRNC_FLAG DIM_TLRNC_FL> A1 1
DIM_WGHTNG_FLAG DIM_WGHTNG_F> A1 1
TOTAL 67
FILEDEF DIMS_DECODE DISK dims_decode.fex (LRECL 200
NUM_DIMTYPE: 01 DIMTYP: T, DIMNAM: Time, Real Dim#: 01, Dim Lvls: 3, Time Dim: Y, Dim Tolerance: N, Dim Weighting: N
NUM_DIMTYPE: 02 DIMTYP: C, DIMNAM: Country, Real Dim#: 02, Dim Lvls: 1, Time Dim: N, Dim Tolerance: N, Dim Weighting: N
NUM_DIMTYPE: 03 DIMTYP: D, DIMNAM: Discipline, Real Dim#: 03, Dim Lvls: 2, Time Dim: N, Dim Tolerance: N, Dim Weighting: N
NUM_DIMTYPE: 04 DIMTYP: Y, DIMNAM: AcademicYear, Real Dim#: 04, Dim Lvls: 3, Time Dim: N, Dim Tolerance: N, Dim Weighting: N
NUM_DIMTYPE: 05 DIMTYP: R, DIMNAM: Region, Real Dim#: 05, Dim Lvls: 2, Time Dim: N, Dim Tolerance: N, Dim Weighting: N
NUM_DIMTYPE: 06 DIMTYP: S, DIMNAM: STS, Real Dim#: 06, Dim Lvls: 2, Time Dim: N, Dim Tolerance: N, Dim Weighting: N
NUM_DIMTYPE: 07 DIMTYP: G, DIMNAM: DegreeLevel, Real Dim#: 08, Dim Lvls: 2, Time Dim: N, Dim Tolerance: N, Dim Weighting: N
SET MSG=OFF
TABLE FILE DIMENSIONS_TYPE
PRINT
DIMENSION_TYPE
DIMENSION_TYPE_NAME
DIMENSION_SOURCE_TABLE_TYPE
DIMENSION_SOURCE_TABLE
DIMENSION_SOURCE_TABLE_TBTYPE
DIMENSION_SOURCE_TABLE_SERVER
DIMENSION_SOURCE_TABLE_KEY_FLD
DIMENS_DEFINE_PROC
DIM_LOADER_DELETE_NOT_NEW
TIME_DIMENSION_FLAG
TIME_FISCAL_YEAR_START
DIMENSION_LEVELS
DIMENSION_NUMBER
DIM_TLRNC_FLAG
DIM_WGHTNG_FLAG
WHERE DIMENSION_TYPE EQ 'T' ;
ON TABLE SET MSG OFF
ON TABLE SAVE AS DMTYP01
END
FILEDEF DMTYP02 DISK dmtyp02.ftm (LRECL 1024 RECFM FB
TABLE FILE DIMENSIONS_TYPE
PRINT
DIMENSION_DESC
WHERE DIMENSION_TYPE EQ 'T' ;
ON TABLE SAVE AS DMTYP02
END
FILEDEF DMTYP03 DISK dmtyp03.ftm (LRECL 1024 RECFM FB
TABLE FILE DIMENSIONS_TYPE
PRINT
DIMENSION_SOURCE_PREFIX_CODE
WHERE DIMENSION_TYPE EQ 'T' ;
ON TABLE SAVE AS DMTYP03
END
Dimension Type (DTTY) : T
Dimension Type Name (DTTYNM) : Time
Dimension Source Table Type (DTSRTBTY) : K
Dimension Source Table (DTSRTB) : timedim
Dimension Source Table TBTYPE (DTSRTBTT) : COM
Dimension Source Table SERVER (DTSRTBSV) :
Dimension Source Table Key Field (DTSRTBKYFL) : SEG01.TIME_KEY
Dimension Define Procedure (DTDFPR) :
Dimension Loader Delete if not in New (DTDMLDDLNTNW) : Y
Dimension Description (DTDE encoded) :
Dimension Source Prefix Code (DTSRPFCD encoded) :
Dimension Time Flag (DTTMDMFG) : Y
Dimension Time Fiscal Year Start (DTTMFIYRST) : 0101
Dimension Number of levels (DTNUMLVLS) : 3
Dimension Number (DTDIMNUM) : 01
Dimension Tolerances (DTTLRNC) : N
Dimension Weighting (DTWGHTNG) : N
******************************** A_GETPERID ********************************
Dimension Source Table Type : K
Start Calendar Year : 0101
Use Current Date? : N
TABLE FILE TIME
WRITE
MAX.TIME_LEVEL03_VALUE
WHERE TIME_LEVEL01_VALUE EQ '2009' ;
WHERE TIME_LEVEL02_VALUE EQ '09' ;
ON TABLE SAVE AS GOTTIME
END
0 ERROR AT OR NEAR LINE 201 IN PROCEDURE A_GETPERID
(FOC299) UNRECOGNIZED FORMAT OF AMPER VARIABLE IN -READ: -READ GOTTIME
&TLVL03_CUR. 2

Hey Endre

Just a guess, but after you configured and loaded the Custom Time, did you go into PMF Settings and reset the Default Time Period? If not, there might be invalid values in there which are causing an error.

EricH