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

Distribute with reference data create additional rows

Hi,

I have a layout for a single employee. In the lead columns I have 2 characteristics relating to the employee and the 12 posting periods, and in the data columns I have the key figure. I am trying to 'distribute with reference' using the previous year as the reference. It works ok if the the lead columns are the same as the previous year. However, if the lead columns contain different values to the previous year, new rows are created when I execute the distribute function which is incorrect for my purposes. Can anyone advise?

Regards,

Linda

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2004 at 11:41 AM

    For the extended function types distribute with reference data from sender to receiver and distribute by key from sender to receiver, you can decide whether the values that you distribute to the receiver data records should remain posted at the sender data records, or whether the appropriate sender data records should be deleted after distribution.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2004 at 10:45 PM

    Hi,

    Thanks for your reply. However, "Distribute with reference data from sender to receiver" produced the same result. Ie, excess rows. Where is the setting to delete the sender row data?

    Regards,

    Linda

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Linda,

      The behavior of the planning function depends also on the settings for the "fields to be changed".

      1. Employee Group and staff classification are in the fields to be changed (as well as period) (I presume this is the setting you have):

      The system will sum up the key figure values for all periods, Employee groups and staff classifications, will look into the reference data and will redistribute the data accordingly. As there are only entries for employee group 1 and staff classification 1 in last years data all values will be written to this employee group and staff classification. This is the entries you see that bears a value. In a layout you will see an entry for employee group 2 and staff classification 2 only until you leave the planning as this is a so-called zero record - all key figures are empty. Such records will be deleted when deleting the BPS buffer upon leaving the planning. If you enter the planning again this entry should be gone.

      2. Employee group and staff classification are not in the fields to be changed:

      The system will not change any of these characteristics. It first treats all data for employee group 1 and staff classification 1. As there is no data for this values in the current data the system cannot distribute anything and will continue with employee group 2 and staff classification 2. Now there is current data that is to be distributed but the system does not find any reference data. Hence it cannot determine a distribution key and will leave the data as it is.

      Thus I think you should delete the characteristics employee group and staff classification from the fields to be changed and should obtain the desired result. If not please get in touch with me again.

      Best regards,

      Gerd

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.