Can I do DELTA load to Plang Cube via Process Chain...?

[Former Member]

Hi BPS Gurus:

I am new to BPS. I want to know following basics:

1. Can I do DELTA loads to a Planning Cube on a DAILY basis via Info-Package?

2. I know we can switch manaully between loading and planning. Is is possible to do this in a Process Chain?

If yes, I would greatly appreciate the commands used for it. I need to do delta/ Full loads daily from 3 diffrent

sources to the planning cube. Wondeiring Info-pkg way would be bettr. I am not sure if COPY function would

for a daily load..... it might mean selective deletions etc and ABAP codin ... right??

3. Can I do a Selective Deletion of Just ONE key Figure and then reload that same Key figure? This might need

ABAP coding I assume. Any suggestion how to proceed with that..... please.

Please let me know your thoughts/ opinion/ anwswer on each of the above a .....bit urgently please....!

Thanks.....pbs

[former_member5472]

Hi,

The options suggested above will work; I'm suggesting another approach ; You can opt which ever is feasible for you.

1. Bring delta records from DSO to actual cube (delta mode)

2. Rather than using fox code, you can standard copy function with options as "overwrite existing values" ; this will overwrite the old records with new values and hence only changed values will be reflected.

thanks

pratyush

[Former Member]

1. I think it is possible to load deltas because you are normal dtps.

2. Yes, you can change this setting in a process chain. There is an action in pfcg.

[Former Member]

Thank you all of you for the feedback.

Pratyush, I am not sure about the COPY for Daily deltas....? I asked a few of my colleagues about being

able to copy from Cube A to Cube just the Delta records and no one thought it was possible and so I was

wondering ton use the info-Package.

A normal Cube "A" gets daily Delta loads from ODS (Actuals) and I want to copy just those Daily changes

from Cube 'A' to cube 'B'. Cube 'B' being a transacional/lanning cube. So, when we do the COPY, how can

you make sure you get just the Daily Deltas....? Are there any time stamp parameters that can be set..? I am

not fully aware of the possibilities. Can you or anyone please provide me a bit more on how the Delta copy

can be accomplished.

We are in a 3.5/ 7.0 environment. But the copy of cube will be within the BI 7.0 system.

Also, in another posting, I read that Selective Deletion is possible ONLY for Chars.....? Is this true? I thought

based on the various postings and SDN article by Surendar that Deletion of records is possible... which may

include several key figures. I know that there is a FUNCTION "RSDRD_SEL_DELETION" that can be used in a

Program to delete data for specified period, but again it deletes all the rows for that period. How can we do

just single key figure?

Sorry for the long note. But appreciate a feedback... particulalry about COPY of Delta loads please!!

Best.... pbs

[Former Member]

Hi.

To copy delta from cube A to planning cube B you should do the next:

1. each day before you get delta from DSO to cube A delete all data from cube A and load delta from DSO.

2. you can copy from cube A to B using IP function.

You should build Multiprovider based on cube A and B, create aggregation level on multiprovider, create filter, create planning function FOX formula something like this:

IF {KF, CUBE_A} <> 0.

{KF, CUBE_B} = {KF, CUBE_A}.

ENDIF.

This way each day you will get only delta records from cube A to cube B.

Regarding RSDRD_SEL_DELETION - it is impossible to delete value of one KF.

You can use IP function (probably FOX) to delete specific KF value.

Regards.

[Former Member]

Hi.

I'll try to answer on part of questions ...

1. You can load delta into plannig cube.

2. For switching between transactional and load mode you can use following FM:

RSAPO_SWITCH_BATCH_TO_TRANS

RSAPO_SWITCH_TRANS_TO_BATCH

If you are on BI7 you can use built-in processes in process chain (RSPC->other BW processes).

If on 3.5 you can use in process chain those FM.

3. I don't thnk you can do selective deletion of ONLY ONE KF.

Regards.

[former_member5472]

Hi,

I'm not sure why you want to upload data into plan cube using info-packages;

SAP best practice dosen't allow the same :

1. It would be ideal if you load all your data into another cube ( say actual ) using info-packages and then copy the data from actual to plan cube using planning functions ( copy); This copy function will works as delta every time u run.

Pratyush