Delta update to Infocube from ODS with incomplete ODS Key

[Former Member]

Hi,

I wrote my own generic extractor with delta management with after immages. I am wondering if its possible to write incomplete ODS keys with 0RECORDMODE set to D in my own functionmodule and to have a routine in the ODS to search for the possible combinations of the missing keyfields to achieve a complete removal for the incomplete key on the infocube.

This is a simplefied example of my problem:

Infocube

Z_ORDER(ch) Z_AGENT(ch) Z_COMMIS(kf)

1000 AGENT1 100$

1000 AGENT2 50$

ODS

Z_ORDER(key) Z_AGENT(key) Z_COMMIS(data) 0RECORDMODE

1000 _ _ D

1000 AGENT1 150$ ( new value ) _

first line should be substituted for all existing combinations in the cube I guess ?

Anyone any suggestions on how to achieve this ?

Thanks,

René

[former_member93896 · Accepted solution]

Rene,

to my best knowledge this does not work. To "delete" data from an InfoCube via a delta you have to match the exact key (characteristics) and reverse the key figures.

An alternative is to look into deletion methods:

- Selective deletion as a job

- Delete options in an InfoPackage

Regards,

Marc

SAP NetWeaver RIG, US BI

[Former Member]

Hi,

I indeed used the start routine to look in the dimension table for the existing combinations for the missing key fields. I inserted new entries with the complete key with the deletion indicator and it works perfectly.

Regards,

René

[Former Member]

Hi Rene,

If your ODS key matches the Extractor Keys, then the delta from ODS--> Cube will generate the required Reverse image.

In your example, you should do a design - so you read the Active table of the ODS and create Delete records for all combination in the start routine . In your example the same Order no with agent1 , agent2 and agent = # .

Arvind