Skip to Content
0
Former Member
Nov 09, 2007 at 04:08 PM

0CCA_C11 Delta and Full upload datasources.

228 Views

Hi,

I'm not quite sure how to go about the following:

Infocube 0CCA_C11 is provided with data by two BC datasources: 0CO_OM_CCA_1 and 0CO_OM_CCA_9.

0CO_OM_CCA_9 is delta enabled and we would like to use that functionality. However 0CO_OM_CCA_1 is not delta enabled.

If I run a Full upload infopackage 0CO_OM_CCA_1 without deleting the data in the Infocube I get duplicate records in the Infocube.

Let's say that Infocube 0CCA_C11 has 100 records. If I run the the infopackage I'll get 200. Next time I get 300 and so on.

1. Is this how a full upload should work? I'd expect the data from the Infopackage to overwrite that in the cube just like it does for attributes. Is there a setting I'm missing or is it just how this specific datasource works?

Nevertheless, our way around tis was to delete the datatarget prior to running the infopackage in a Process Chain. That way we are sure that the data in the cube is correct

The problem with this option is that by deleting the datatarget, we are not only deleting data that originates from datasource 0CO_OM_CCA_1 (full upload), but also from 0CO_OM_CCA_9. This would pose no problem if we use a full upload, but if we use delta it would be incorrect because it would delete the initial upload as well.

3. How can I use both the full upload for 0CO_OM_CCA_1 and the delta upload for 0CO_OM_CCA_9 that supply 0CCA_C11. Am I restricted by SAP to use either two full uploads or two deltas?

thanks in advance

Michalis