Data is not trimmed during data load

[former_member477051]

Hi,

during load from CP (consist of Open ODS View) to DSO I have the following error:

And yes source column is CHAR(60) and target is CHAR(20), the easiest way is to just extend target. However I'm sure that yesterday values were trimmed,I've checked it in the DSO.

What can be done to "force" BW/HANA to trim data during load?

SAP BW on HANA 7.4

EDIT:

When previewiing DATA directly on ODS View column is trucated when option "Use DB aggregation" is off. Otherwise I get same error.

[Torsten_]

HI,

you're on BW 7.40, is that right?

Did you try to use a formula with SUBSTRING for your field.

The formula should not prevent a push down.

Torsten

[former_member183519]

Hi Lukaz

Have you tryed with offset ?

Regards

Hitesh

[former_member477051]

Could you please elaborate bit more on that?

[former_member183519]

Hi,

Lets say your soruce and target variables are :

lv_src type C length 60.

lv_tgt type C length 20.

as you wanted to assign soruce to target..

lv_tgt = lv_src+0(20). <-- offset

[shasan]

Yes Lukasz,

You can go with Hitesh's suggestion to use offset or Torsten's - substring(formula). It will kind of give you control on whether you want to trim from left or right depending on your requirement.