July 17, 2008, 10:37 AM
Susan JTIME 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
July 17, 2008, 10:44 AM
Bob Jude FerranteHi 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