Hyperion Planning (MOSC)

MOSC Banner

Date error when loading data into Planning with ODI

edited Aug 24, 2012 10:20AM in Hyperion Planning (MOSC) 1 commentAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center