Skip to Content

Transformation logic is not applied in the Active DSO

Hi All,

I have a end routine in the DSO transformation to update the fields. When I load the data it is showing correct in new table but after activation the data in the Active table is not showing the expected values.

I have full load ( new DSO ) and there are no previous requests.

Please help

Thanks

Robert.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

11 Answers

  • Oct 24, 2018 at 02:50 PM

    Hi,

    Which BW version you are using ?

    Just try to put any constant value in the newly added field for which you are trying to populate the value through end routine.

    Check if that helps or not.

    Regards,

    AL

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 24, 2018 at 02:32 PM

    hi robert,

    pls share you transforamtion, er code.. what is current values in new/active table and what is value u expected(in excel)...

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 24, 2018 at 05:21 PM

    Hitesh there is the no error code in the data load process. Data loads to new table and looks good. But when I activate I don't see the correct numbers in Active DSO.

    Thanks Anshu, Yes I tried hard code constant values in the transformation and I have not issues in the Active table after request activated.

    Do you know why the transformation logic is not updating in the process of activating the request ?

    Thanks

    Robbie.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Robert, 'er' I mean with 'end routine' code.. also if possible give a snapshot of 3-4 records with new table entry and active table(after activation) entries.

      if u shared what dso values u r getting and what u expected then its easy to figure out issue.

  • Oct 24, 2018 at 05:23 PM

    We are in BW 7.4 Version.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 24, 2018 at 10:33 PM

    New Table -

    STK is directly coming from Source and STK1 is derived based on the logic in the transformation.

    New TABLE before ACTIVATING THE REQUEST SID DATAPAKID RECORD CALMONTH CALYEAR MATERIAL PLANT STK STK1 BASE_UOM UNIT 136420 1 1 201704 2017 903423 3011 13200 1100 CS EA 136420 1 2 201704 2017 905893 3011 0.000 0.000 CS EA 136420 1 4 201703 2017 112550 3011 2186858 2186.858 KG G 136420 1 5 201704 2017 111109 3011 6571097 6571.097 TH EA 136420 1 6 201704 2017 118983 3011 0.000 0.000 TH EA 136420 1 7 201704 2017 190369 3011 0.000 0.000 TH EA
    ACTIVE TABLE AFTER ACTIVATING THE REQUEST
    SID DATAPAKID RECORD CALMONTH CALYEAR MATERIAL PLANT STK STK1 BASE_UOM UNIT 136420 1 1 201704 2017 903423 3011 13200
    EA 136420 1 2 201704 2017 905893 3011 0.000
    EA 136420 1 4 201703 2017 112550 3011 2186858
    G 136420 1 5 201704 2017 111109 3011 6571097
    EA 136420 1 6 201704 2017 118983 3011 0.000
    EA 136420 1 7 201704 2017 190369 3011 0.000
    EA

    I hope this helps.

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2018 at 08:46 AM

    Hello Robert,

    After activating request, in active table i could see you are getting fields SID DATAPAKID RECORD ?

    on activation, in active table we are not getting this 3 fields..

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 25, 2018 at 07:47 PM

    Hitesh,

    Here is the screen shot.

    dso-activate-issue.png

    Robbie.

    Add comment
    10|10000 characters needed characters exceeded

    • What kind of key figure is ZOPNSTK1 - cumulative or non-cumulative key figure? What type of ADSO?

      Consider the possibility that the system is working perfectly, and netting to zero when going from new to active.

  • Oct 26, 2018 at 04:32 AM

    It is a quantity key figure of Cumulative value. it only works if we load the data to the new table but after activation doesn't see the data in the Active table.

    I created the Write optimized DSO and it work fine with out issue.

    I am in BW 7.4 version.

    Thanks

    Robbie.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Robbie,

      can u give one try.. as u said in one of the your earlier comment, you tried hard code constant value in transformation..

      Instead of passing some hardcode value, can u pls give a try with BLANK value..as below..

      if this not work.. give one of the below try:

      1) when click on end routine.. the screen popup..ensure all fields are to right side

      2) if 1st ok OK , then ensure KF STK1 is present in structure in end routine _ty_s_TG_1

      3) code is written in correct rule group( i believe this is not with your case)

      Regards

      Hitesh

      fdaey.png (10.6 kB)
  • Oct 26, 2018 at 02:29 PM

    Hitesh, now it worked if I make the field routine as Constant with a blank value and didn't make a change in End Routine without change the logic or structure.

    After field routine, only the End Routine will work based on the sequence of three routines, why field routine is overwriting the End Routine here...

    Earlier there is nothing assigned or hardcode any values so I got the issue in the Active table even it doesn't work with some constant values as well. Now it is working because I made blank constant and End routine logic is working in the Active table. Don't know why this different behavior.

    Any idea why?

    Thanks

    Robbie.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 28, 2018 at 09:07 AM

    Hi,

    When you open start routine window, one step before getting to ABAP code popup with LHS and RHS fields appears.

    Do you see you KF in LHS or RHS?

    BR,

    Add comment
    10|10000 characters needed characters exceeded