I need to include a check function before data is written into the cube.
EXIT function is not meeting my needs.
So, I need to check this using FOX.
Has any one done this before?
Users enter CAL QUARTER & VALID FROM & VALID TO dates & I need to check if VALID DATES are falling in the same quarter or not.
Info objects that we are dealing with are 0CALQUARTER, 0CRM_VALIDF & 0CRM_VALIDT.
if users enter 3/2005 & 7/1/2005 & 9/30/2005, no message.
if users enter 3/2005 & 8/1/2005 & 12/31/2005, message needed to change valid to date.
if users enter 3/2005 & 6/1/2005 & 7/31/2005, message needed to change valid from date.
Appreciate any help.