cancel
Showing results for 
Search instead for 
Did you mean: 

Copy function in the planning level????

Former Member
0 Kudos

Hi there,

I would like to know

1)what does this 'copy' function modify the data if I create a planning level only for the <b>planning function'copy'</b> when I have other 3 planning levels in this planning area?

2) What is the <b>'field for change'</b> if I need to this 'copy function'?

Thank you.

J.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi John,

An approach for anaylzing your questions could be very short and simple as Ms Kota wrote, or a bit of detailed analysis to brush up the basics as I am writing.

1) The planning function "copy" could be implemented in different planning levels, for example in your case 3 planning levels.

2) How does it affect the execution/performance of the underlying planning function is the core to be thought about.

3) The settings of the planning level (number of characteristics, thier restriction, restriction in packet, restriction via variables, etc) describe the dimensions of the performance analysis matrix.

4) When none of the characteristic is restricted, every transaction record is "<i>able to pass through the planning level</i>". Hence the system would read all transaction data in the cube to build up the planning function buffer in end effect (a table). <b>This is never recommended!</b>.

5) The more the number of characteristics are restricted in the planning level, the better is the data records described for the system to determine which data records to read in and get it in the buffer.

6) So what these 5 points actually mean? In short, the planning level describe the structure of the transaction data to be used and the settings (restriction) help the system to determine which data records to select for using/processing!

😎 When you mark the option "selection in planning packet", then the system breaks up the "buffer" into small sub packets. What does this actually mean "break up"?

Well simply stated, without this option every transaction record would have been taken up in one large buffer and processed all in one go.

With the option "selection in paket" the buffer whould be splitted up into packets which are aggregated on the characterstic value marked with the option "selection in planning packet". With this option the underlying planning function would be executed as many times as that no of packets built up.

9-Summary ) So the planning level describe the structure of data to be build up in the buffer, the selection cretieria, and in how many times the underlying planning function would be called up!

<b>So far was the explanation for your Question 1)</b>

10) The fields to be changed in the parameter group tells the system as of what characterstic could posses a value different than what it was in the data record read in. Offcourse all during execution of the function

Note) Your restriction in the planning level for a characteristic must encompass all the characteristic values which might be built up during the execution of the function. If not, then system would give an error message, that the "records generated dosen't lie in the selection creiteria of the planning level"

All these points are perhaps not so structured, but it could definitely help you analyze your questions.

Many regards.

Former Member
0 Kudos

Hi Depr,

Based on my Q#1, there are 4 planning levels- three P&L plannings and one planning level (specific the creation of planning function -COPY; no other planning in this level). Do you mean that it will copy data from these three planning levels by executing the'copy function' if I have ChAR-<b>fiscal year, company codes and data type</b> in the <b>'fields to be changed'</b> (COPY/ parameter group) in the both source & target dataset? <b>EX: I select 2006/US10/forecast in the SOURCE and 2007/US20/forecast in the TARGET. Then the COPY function will overwrite the data from SOURCE to TARGET in all 3 planning levels within this planning area, right?</b>

This is very important for me. Thank you.

J.

Former Member
0 Kudos

Hi John,

When the cube already has data records on 2007/US20/forecast and all the 4 planning levels have same structure (<i>see explanation below</i>), then these records would definitely be overwritten or added up on (<i>depending upon the setting in the parameter group</i>)!

<u>How and why, as follows:</u>

1) All the planning levels are independent of each other, as long as their structure differs some how ( characteristics and keyfigures combination).

2) When the structure of planning levels (characteristic, and keyfigures) are same for each planning level (3 P&L and 1 Copy Function level), then each planning level builds up data records with same selection criteria. And therefore the underlying function has access to the data that was "generated/updated from execution of previous planning function".

3) Take for example, you have same characteristics and key figures in all these planning levels

You first enter the data under Planning level 1 for

2005 US10 100

2006 US10 101

2007 US10 102

2005 US20 401

2006 US20 402

2007 US20 403

Now you execute the copy function (parameter group option, overwrite). The records would be overwritten as follows:

2005 US10 100

2006 US10 101

2007 US10 102

2005 US20 401

2006 US20 402

<b>2007 US20 101</b>

Perhaps it would have been easier for me to explain, when you also mentioned the planning level structure of these 4 planning levels.

Also note that there are two variants for the copy function.

a) Copy

b) Copy to several target Objects

Best regards!

Former Member
0 Kudos

Hi Depr,

Thank you for your explaination. I was wondering if you can tell me if I need to select one 'specific planning level' after I execute 'COPY' function (I have 3 planning level in this planning area). Or the system will overwrite data in these three planning level at the same time after I execute COPY function?

Thank you

J.

Former Member
0 Kudos

Hi John,

Your second assumption is correct.

<b>Why?</b>

After you execute your copy function, you don't have to do some sort of selecting other planning level(s).

<b>The permissible data records of the planning level(s) matching the structure of "copy function" planning level would automatically get updated/overwritten. With structure I mean the characteristics and key figures involved, as well as the filters applied on them. </b>

<i>In oder to see the changes you could select the planning level(s) which have same structure as that of "copy function " planning level and see in the P&L Layouts the updated data.</i>

Best regards

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

The copy function allows you to copy the data for a particular field which you specify for a particular planning level.

teh field for Chaneg indicates the name of the infoobject for which you want to handle the copy function.

Regards,

Sridevi