Focal Point
TIME dimension won't load

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

July 17, 2008, 10:37 AM
Susan J
TIME dimension won't load
using the EMPLOYEE file with nicely defined YEAR/A4, MONTH/A2, and QUARTER/A1
we can't load the TIME dimension
we get

Running dim_loaderlook for dimension type (DTTYNM): Time
EX DIM_LOADER_TIME01 TIME_SOURCE_MFD=employee, ECHO=ON
DEFINE FILE employee
LEVEL02_CNT/I6 = IF (TIME_LEVEL02_VALUE NE ' ') THEN 1 ELSE 0 ;
LEVEL03_CNT/I6 = IF (TIME_LEVEL03_VALUE NE ' ') THEN 1 ELSE 0 ;
END
0 ERROR AT OR NEAR LINE 22 IN PROCEDURE DIM_LOADER_TIME01F
(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: TIME_LEVEL02_VALUE
0 ERROR AT OR NEAR LINE 23 IN PROCEDURE DIM_LOADER_TIME01F
(FOC258) FIELDNAME OR COMPUTATIONAL ELEMENT NOT RECOGNIZED: TIME_LEVEL03_VALUE
Failure in dim_loaderlook


765 unix server & client; devstu 765; pmf 4.2
July 17, 2008, 10:44 AM
Bob Jude Ferrante
Hi Susan--
Welcome to the forum.

If you’re creating a Time Dimension as Year/Quarter/Month, you don’t need to load from external data. You can use the Dimension Loader’s built-in Time AutoGen capability. In the Dimension Loader, select the Time AutoGen option, pick your start and end months, and you should have a Time dimension in moments.

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!