Skip to Content

Delta Init from DSO to cube different from Full load...

Dear Gurus,

I am stuck with a behaviour I have never seen. I have a DSO that loads a cube.

When I run the delta init DTP for the first time, I get only 500K records extracted among the 1,2 million I have in the DSO. If I decide to run the Full DTP to check, and if I run it, I get the 1.2 million records.

My first run is set to take the active data, not the change log

Does anyone have a clue on that ? I might be missing something very simple, but may too simple ;-)

We are on BW 7.3 SP 5 on top of MSSQL DB

Thanks

PY

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 07, 2013 at 07:17 AM

    Hi,

    First time when you loading data from DSO to cube you just create delta DTP do not change any property and execute...it will load your full data and next run it will take care and load delta records only

    delete all data from cube and load using delta DTP..

    Try this.

    Regards,

    Ganesh Bothe

    Add comment
    10|10000 characters needed characters exceeded

    • Hi ,

      It should work.

      First right click on cube delete data

      2)Execute delta DTP from DSo to Cube check DTP setting.

      I think you have tries this Can you check once again because I have checked in my sandbox and it is workinf for me.

      Regards,

      Ganesh Bothe

      dtp2.jpg (37.5 kB)
  • Dec 07, 2013 at 12:40 PM

    Hi,

    Please follow ganesh suggestion & for your other query delta DTP is picking the data from active table instead of changelog table this is due to settings in the EXTRACTION tab in the DTP it will posses 4 options like below.

    Active Table(with Archive)

    Active Table(without Archive)

    Archive(Full Extraction only)

    Change log

    select the 3rd option because your running delta DTP & you will get desired data in the cube.

    Regards,

    Harish

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 07, 2013 at 05:06 AM

    HIPierre,

    In DSO level have 1,2 million records and u will run delta DTP it carrying only 500 records,

    Have you done full load form DSO to Info cube (1,2 million records?)

    if you perform delta DTP i will carry Delta records only.

    Please check the any filter in Cube DTP level?

    please find the link

    SAP BI DTP 7.3

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 08, 2013 at 03:41 AM

    Hi,

    Please check whether there is any routine is there while transferring data from DSO to cube or one to one mapping is there.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

    • Hi

      unfortunately, it is a one to one mapping..no routine...

      The objective of the cube is just to get rid of the detailed data and aggregate the information at a higher level...so we are just putting on the side some characteristics....

      It is based on COPA (analytical model..) So I should extract from the DSO the same volume as what I have in the DSO and insert fewer records...

      PY