Skip to Content
avatar image
Former Member

How to get historical data rectified in an Infocube

Hi,

Please let me know how can we fill the missed data (Product key) for the historical records into the infocube which is now available in the lower level   DSO

How the historical infocube data can be rectified. It is not possible to delete the infocube data as daily loads happen in the production system.

Thanks & Regards,

Kumkum

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 22, 2014 at 11:23 AM

    Hi,

    Mean missed records have you noted? if yes then you can use full dtp and use proper filters.

    Load the data form DSO(missed wsa exist at DSO) to Cube.

    If you need to reload missed data form source then you can run repair full request with proper selections and continue your delta loads from PSA-->DSO-->cube.

    if client accepts then better delete cube whole data and reload.

    coming week is chrismas eve, so client will be on leave. but its depend contry.

    please check that possible.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 23, 2014 at 05:34 AM

    Hi,

    you know which records is missing if yes please use the repair full request form the source PSA.

    use the selection conditions execute the info package.

    DSO leve it will overwrite but cube level added be ware that don't load the same records 2 times into cube - it will add key values.

    better do delete the total data form the targets and load it again if client is accepted.

    Thanks,

    phani.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 31, 2014 at 04:15 AM

    Hi Kumkum,

    How many years of records are there in the cube and how much time it may take to Delete and Reload..Can you do the Deletion in Quality system and check.

    There are others ways to do partial load but we need to be sure of the Data. If it doesnt take much time then we can do a deletion and Reload the Data with Delta.

    regards

    SVU

    Add comment
    10|10000 characters needed characters exceeded