CCA Actual Delta - 0CO_OM_CCA_9

[Former Member]

Currently my CCA Actual and Plan cube are stored in the same cube, and the Actual data is for multiple years, and the amount of data has gotten very large. What I am about to do is create a new cube for the Plan data and also create a new cube for data for 2009 forward. My concern is making sure I don't miss any deltas. For 2009, we are in period 5, so what I would like to do is do full loads for periods 1-3, then start my delta init at period 4. I looked at the documentation for 0CO_OM_CCA_9 and it looks like deltas are determined by a time stamp. So my question is, if I start the delta with period 004/2009, and on the R/3 side, they enter a document with a posting date for a period previous to 004/2009, will that document be picked up with the delta? From what the documentation reads, I would say yes, but I have had this happen to me with A/R, and A/R uses one of the dates to determine if a delta is picked up. Thanks, Keith J

[Former Member]

I tested this and that is correct. If you start the INIT with period 004, and someone creates an FI document with a posting date in a period before period 004, then the document will not be picked up in the delta.

[Former Member]

In my new 2009 cube, all I am planning on putting there is 2009 data. The problem is we are in period 005 and our CCA data runs about 25 million records a month, so to do an INIT for the beginning of 2009, I am looking at over 100 million records. My hope was to do full loads for the first 3 periods, then do the INIT beginning with period 004. But that takes me back to my original problem and that is if a new record is created with a posting date of period 003/2009, now my INIT that started with period 004 will not pick up this record. That is correct, right?

[Former Member]

So if I go with the option of loading a new cube from R/3, you are saying I can do full loads for periods 001 - 003, then do an INITs load without data transfer from something like 001/2008 to 12/31/9999, then do a second INIT load from 004/2009 to 12/31/9999?

Now any document created with a posting date of 001/2008 forward would get picked up?

[dielom]

Hi Keith,

You can't do two init with the same or overlaping parameters.

If you are going to do a full load, you can do an init from 001/2008 to 12/9999 with data transfer. then, you would get all data from 001/2008 forward picked up.

Regards,

Diego

[dielom]

Hi Keith,

 if I start the delta with period 004/2009, and on the R/3 side, they enter a document with a posting date for a period previous to 004/2009, will that document be picked up with the delta? 

No, it won't pick it up. The deltas will be looked from 004/2009 forward (until the end date from your init load, usually 31.12.9999).

Some comments:

- You don't need to reload. you can create the new cubes and load them from the cube you already have.

- if you do want to reload, you can do full loads and then do init without data transfer, you may do this from the beggining of time up to 004/2009 and then do init with data transfer from 004/2009 to the future.

There are many alternatives to do it, hope this clarifies a bit.

Regards,

Diego