Skip to Content
0
Former Member
Jun 22, 2005 at 09:12 PM

SEM - checking validity periods in FOX.

85 Views

Hi,

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.