Skip to Content
0
Former Member
Jan 29, 2009 at 02:00 PM

restricting data in cube using start routine

27 Views

Hi,

Can anyone help me with my scenariou2026.I am trying to restrict the absence data being loaded into the cube where the absence is less than or equal to twenty.

Firstly I put in a start routine in the update rules against actual time.

DELETER DATA_PACKAGE WHERE DUR_ACTUAL GT 20

But this didnu2019t work.

Secondly I put this code in the change routine for the key figure actual time

IF RESULT GT 20.

RETURNCODE = 1.

ELSE.

RETURNCODE = 0.

ENDIF.

But all the actual time fields were set to 0.

Can anyone please help with the correct code.

Thanks

Forhad