info needed

[Former Member]

hello everyone,

is it possible to do delta updates from flat file into infocube? can anyone tell me the detail steps?

AND

i am trying to load data from flat file into info cube.( i am tring to do initialize delta process.)and this error is occuring: An error occurred in the SAP BW when processing the data. The error is documented in an error message.

System response

A caller 01, 02 or equal to or greater than 20 contains an error meesage.

[Former Member · Accepted solution]

Hi Mani,

It is not possible to have delta upload with flat file.

You have two possibilities:

1) any file contains only the new and changed records

2) put an ODS between the infosource and the Cube. The ODS with the overwrite functionalities introduce a delta update directly in BW.

Ciao.

Riccardo.

[Former Member]

Hi,

It is possible by providing the delta values

i.e., it has additive delta option (but has no overwrite)

You have to select a suitable update mode in

transfer structure maintenance

so that the system uses the correct update type.

· Full upload (ODS Object, InfoCube, InfoObject)

The DataSource does not support delta updates. With this procedure, a file is always copied in its entirety. You can use this procedure for ODS objects, InfoCubes and also InfoObjects.

· Latest status of changed records (ODS objects only)

The DataSource supports both full updates and delta updates. Every record to be loaded defines the new status for all key figures and characteristics. This procedure should only be used when you load into ODS objects.

·

Additive delta (ODS object and InfoCube

)

The DataSource supports both full updates and additive delta updates.

The record to be loaded only provides the change in the key figure for key figures that can be added. You can use this procedure for ODS objects and for InfoCubes.

Caller msgs:

Caller 01 : If there is any inconsistecy while loading the data or if the program cannot able to execute a specific task it will give the caller errors.

If you check in the transaction ST22 (Short dump analysis)you can get the idea of where the problem is.

You can check for the OSS notes 631668, 860475 for more info.

Refer this Oss notes 631668

Caller 05 : while no load data in psa for specific infosource .

Caller 09 : The error occurred in Service API .

Errors when loading flat file data : 1. Lowercase letters.

Either use capital letters only. Or use formula/routine in transfer rules.

reward if helpful

shylaja.