Skip to Content
avatar image
Former Member

Generic DataSource cannot be updated in an InfoCube!

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jun 18, 2010 at 10:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

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

      Thanks

  • avatar image
    Former Member
    Apr 16, 2012 at 01:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 16, 2012 at 02:19 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 16, 2012 at 05:19 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded