Transformation logic is not applied in the Active DSO

[Former Member]

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.

[anshu_lilhori]

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

[shasan]

Hey Robert,

Try checking your change log too and see if the record with value in ZOPNSTK1 is being getting overwritten by some other data record. This can help in analysis at some level.

Mostly if you are performing drop reload of the DSO, the record after activation must sit as New record and in case the record with required data is getting overwritten or manipulated, it will be showing a before after image of the same.

[former_member302041]

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,

[Former Member]

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.

[Former Member]

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.

[former_member183519]

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

[Former Member]

Hitesh,

Here is the screen shot.

dso-activate-issue.png

Robbie.

[john_hawk]

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.

[former_member183519]

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..

[Former Member]

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.

[Former Member]

We are in BW 7.4 Version.

[Former Member]

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.

[former_member183519]

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.

[former_member183519]

hi robert,

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