Skip to Content
Feb 12, 2010 at 07:47 PM

0Calmonth empty in Infocube?


Hi Gurus,

We have a curious situation in one of our cubes. We are bringing in external data, and in the transformation to the cube we use the transation data field (dats type) to load into the 0CALMONTH char using a time coversion routine.

However, for any dates beginning in 2009 the 0CALMONTH field is empty it seems, and any queries return null results if it is used.

Is there an update process we need to run somewhere, or any other causes for this?