Variable while deleting data in Target in APD

[former_member202214]

When we create APD, if Target is direct update ODS, it allows, us to define the attribute values based on which deletion to be conducted. Can we specify variable over there. Does anybody know where these entreis are stored in table.

We tried debugging but we could not determine from which cube values are being picked.

Regards

Saurabh

[Former Member]

DSO data does not need to be dropped completely as thread starter mentioned. You have the option to select any of the key characteristics used in the source and enter a value or a constant for it to avoid certain areas to be overwritten.

for example if you have APD 1 and APD 2 filling same DSO with mostly same characteristics you can use an attribute like 'APD constant' to avoid them overwriting each others data. give this attribute constant value '1' for APD 1 and constant value '2' for APD 2 and you will have both sets of data in target DSO.

[Former Member]

Just checked.. yes we need not drop dso data completely. I agree...

Thanks,

Raghu

[Former Member]

HI,

You mean deletion of contents from DSO based on variables?

as far as i know, dso data will be dropped completely and loaded with new data.

If you are looking for variables values used in filters of APDs, either customer exit will determine its values or values might be maintained in table TVARVC ; t-code STVARV

Regards,

Raghu

[Former Member]

Hi,

i dont think that it is possible to delete based on variables. Assuming for now you are running APD with query as source, it is common to use an dedicated attribute from the query that is specifically defined to make sure proper data is deleted. So you could use a (formula) variable, constant or formula in the source query to make sure the correct data is deleted in the target DSO.

Hope this helped.

C.