code in end routine works but data not updated to cube

[lakshminarasimhan_n4]

Hi,

We have ZPS_C04 cube and given below is the code written in the end routine.

In the debug mode  i can see that code works fine(Result_package populated with correct data)

But the cube contains blank values ..

I am not sure why this happens and this is the first time i facing this error. I am in SAP BW 7.3.

I have tried to put the code in the "transformation routine"  too and it works fine there in simulation mode but data is not added to the cube.

Any help.

LOOP AT RESULT_PACKAGE ASSIGNING <RESULT_FIELDS>.

     IF <RESULT_FIELDS>-COSTELMNT = '0000409001'.

        <RESULT_FIELDS>-/BIC/ZEQINTRE = 'INTERNAL'.

      ELSEIF <RESULT_FIELDS>-COSTELMNT = '0000409002'.

        <RESULT_FIELDS>-/BIC/ZEQINTRE = 'EXTERNAL'.

      ENDIF.

     ENDLOOP.

[yasemin_kilinc · Accepted solution]

Hi,

I had a few times faced this issue. In the development side please save the transformation in a new request and then activate. I don't know the reason but sometimes when you only activate the transformation, it does not work. So I always save it first and then activate that.

Hope it helps

Yasemin...

[former_member209895]

Hi Laxminarasimhan,

       Please let us know how the field /BIC/ZEQINTRE appears in the declaration, also is it getting cleared / refreshed anywhere ? Please check the datatype of the infoobject ZEQINTRE.

Hope this helps.

Regards,

  Manohar. D

[lakshminarasimhan_n4]

Dear All,

With no single line of code change, i again done activation of transformation in the BW development system and re-transport to production, which solved the issue :-)..Thanks 

[ravi_chandra3]

Hi laxmi,

The code is correct. Are u getting any error or just the values are not populated in the cube.