Generic DataSource cannot be updated in an InfoCube!

[Former Member]

Hi Expert

We have a Z infocube that is loaded directly by a Generic Datasource. We setup a infopack for initialize delta precess and other for Delta Update. With a DTP Full we load the initial data, but when we try to setup a DTP for Delta information the system respond that Generic datasource cannot be updated in an infocube directly because uses delta process AIE (RSM1112).

We have a transformation rule and many routine from the generic datasource to Z infocube, so for us is very difficult to setup a ODS. So anybody know is there another option that allow us to setup a DTP Delta for generic datasource to update directly to Z infocube, for us is going to be very helpfull any idea.

On the other hand, on DES with made a DTP Delta and the system doesn´t say anything, but on PRD the DTP Delta can´t be active.

Thanks a lot

[Former Member]

Hi,

Generic datasources supports both AIE and ADD.

ADD additive supports Infocube. We can change in RSO2 -> generic delta -> there u find 2options after image , additive image choose additive image.

Choose delta field as calday and safety upper limit = 1, safety lower limit = 0

But its better to use DSO inbetween the Datasource and the Infocube.

There may a chance of getting duplicate records in some cases.

Regards,

Aravind.

[Former Member]

Hi David,

i think you have to do the next.

- If your data source manages delta, you don't have to do anything with the DTP. You can make the initialization in the DS and later you can do the delta.

- In DTP you can set type Delta in both cases to load all the data. I think it is not neccesary changing DTP type to FULL

Best Regards,

Nacho

[Former Member]

Hi David,

Go To T-Code RSO2 and Specify your data source name click on change Then u find one option Generic Delta click on that under that u get additive radio button select that and save then replicate to BI.try to load to CUBE it will work

Hope u got.

Thanks&Regards

Anandreddy

[former_member188011]

Hi David:

AIE only supports loading to ODS/DSO, for more details refer to the blog provided by Swapna Gollakota.

"How does a datasource communicates "DELTA" with BW?"

/people/swapna.gollakota/blog/2007/12/27/how-does-a-datasource-communicates-delta-with-bw

Regards,

Francisco Milán.

P.S. Take a look at this thread for a similar discussion.

"DataSource 0FI_AP_4 cannot be updated in an InfoCube! "

Edited by: Francisco Milan on Jun 18, 2010 5:20 PM

[Former Member]

Hi

My especific question is there any way to change process delta AIE to update infocube directly with delta generic datasourse.

Thanks