Skip to Content
author's profile photo Former Member
Former Member

DTP Question: Delta and re-Initialization.

Hello,

I have a question concerning the use of DTP.

I'm using a Delta DTP to load data from an DSO to a Cube.

This process is working fine.

But what if you have to delete the contents of the cube and you have to do a "re-initialization" again ?

Delta DTP is retrieving data from the change log of the DSO (PSA) and old PSA requests have been deleted in our system.

So when the Delta DTP runs, It only will retrieve the data which is still in the change log of the DSO and I will miss a lot of data in my cube.

So how do I do a "re-initialization" again from DSO to cube using DTP ?

Do I have to create a new DTP using Full update ? Running this DTP. Than delete the change log of the DSO and than using the Delta DTP again ?

Or is there an other way ?

Please advise.

Thanks,

Wim

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2008 at 12:26 PM

    Hello Wim,

    You are right. The way you described is the only way to solve it. But this solution shouldn't be a problem or?.

    If the data in the change log of the DSO is not complete - the only way to transfer all data from DSO to Cube is using Full update. Than you have to delete the change log to continue with delta load.

    Regards,

    JG

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2008 at 12:37 PM

    Hi,

    Please check this series of blogs:

    /people/community.user/blog/2007/06/22/sap-netweaver-70-bi-data-transfer-process-dtp-blog-series

    /people/community.user/blog/2007/06/21/sap-netweaver-70-bi-data-transfer-process-dtp-the-147normal-dtp148

    /people/community.user/blog/2007/05/02/sap-netweaver-70-bi-get-runtime-information-of-a-data-transfer-process-dtp-in-a-transformation

    /people/community.user/blog/2007/03/29/sap-netweaver-70-bi-extended-capabilities-to-debug-a-data-transfer-process-dtp-request

    /people/community.user/blog/2007/06/21/sap-netweaver-70-bi-data-transfer-process-with-147get-data-by-request148

    /people/martin.mouilpadeti/blog/2007/08/24/sap-netweaver-70-bi-new-datastore-write-optimized-dso

    /people/kamaljeet.kharbanda/blog/2006/11/13/real-time-data-acquisition-bi2004s

    /people/community.user/blog/2007/06/21/sap-netweaver-70-bi-data-transfer-process-with-147only-get-delta-once148

    /people/community.user/blog/2007/09/23/sap-netweaver-70-bi-how-to133-minimize-the-reporting-downtime-during-the-initial-data-load

    Hope it helps....

    Regards,

    Mona

    Edited by: Mona Kapur on Jan 8, 2008 1:38 PM

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.