Date error when loading data into Planning with ODI
Hi,
We are getting an error when loading data into planning and getting the below error:
*Cannot load dimension member, error message is: com.hyperion.planning.HspRuntimeException: One or more fields of date "26-05-2002" is out of range.*
We only get this error on the one scenario on our TEST environment for loading HR data in Planning which gives the error in the data log file. This error is not present in our PROD environment only TEST.
We have ODI, planning shared services on a windows box (separate boxes for TEST and PROD) and essbase is on UNIX. We have 4 cubes (IS, BSCF, EMP, MGN) and the models in ODI loads financial data via IS, BSCF, MGN into Essbase. The HR data for the EMP cube is loaded into planning with all new dimension members.
0