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

CRM Opportunities Header and Item delta load

Hi all,

We have the CRM Opportunities already deployed. The opportunities is built on the standard content (0CRM_OPPT_H, 0CRM_OPPT_I)and the data flow is like data comes to the header DSO and item DSO and from there it moves to individual header and item Infocubes. There is a multiprovider on these two cubes and reporting happens. In the current scenario till the DSO it is a delta load and from there it is a full load to the cube by dropping the existing data in the infocube. The data is being dropped in the cube while loading and because of this reporting is not available for some 45 minutes. The load happens 2 times a day. Now business wants to increase the number of loads and asking for a possibility of making the full load to a delta load. We have tried using a delta load from the dso but the there are duplicates coming for the header and item. So I would like to understand whether for CRM Opportunities header and item data what is the correct practice. What is the problems/concerns we have to know when we want to do a delta load for these data sources.

Regards

Vijay

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 19, 2008 at 10:58 AM

    Hi Vijay,

    Check the DTP settings for STD Cube 0CRM_C04 which is getting data from DSOs 0CRM_OPPH and 0CRM_ OPPI.

    Regards.

    Sastry

    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.