Skip to Content
0
Sep 27, 2005 at 08:48 AM

Copy key figues without the characteristic values

34 Views

Hi Everyone

I need some help /advice to copy key figues without charateristic values. Sounds easy, well I thought so...

My customer wants to plan certain key figures against a “reference employee”, for example chargeable hours.

• This reference employee, and therefore all other employees will belong to an employee group (and several other characteristics – just try to keep it simple).

• The employee group will not be a attribute of the employee, as this could change sevaral times during the year. One employee could belong therefore belong to multiple employee groups during one year.

• All key figures will be planned against a fiscal period.

As a start we would plan one of the key figures of the reference employee and then copy it to all other employees in that profit centre.

At this stage we can assume that there will already be some plan data against the same /and or another key figures for the “target” employees. This means that there will already a be a plan record with an “existing” employee group for that employee in the cube.

For example.

Existing records:

Employee Employee Group Period Standard Hours Chargeable Hours

B101 B 1 100 200

B101 B 2 0 0

B101 B 3 0 0

Now we would plan the “reference” employee:

Employee Employee Group Period Standard Hours Chargeable Hours

A100 A 1 80 0

A100 A 2 80 0

A100 A 3 - 12 100 0

When I now want to copy the chargeable hours from the reference employee to the target employees to for all periods (1-12), the following happens:

Employee Employee Group Period Standard Hours Chargeable Hours

Original B101 B 1 100 200

Reverse B101 B 1 0 200-

New B101 A 1 0 80

New B101 A 2 0 80

New B101 A 3 - 12 0 100

What we would like to achieve is the following:

• Copy key figures without having to copy the “related” characteristics

• Create new records for the other periods using same employee group as the existing record.

Employee Employee Group Period Standard Hours Chargeable Hours

Original B101 B 1 100 200

Delta B101 B 1 0 -120

New B101 B 2 0 80

New B101 B 3 - 12 0 100

I have tried sevaral versions of Fox formulas and the standard copy function, but they all give the same results:

For example:

DO.

PERIOD = PERIOD + 1.

ZP = TMVL(ZP, 1).

  • Find reference values

FOREACH ZP,ZEG,ZC,ZPOS.

ZV = {ZCHGHR,ZEG,ZP,ZC,B101,ZPOS}.

*Copy to all employees

FOREACH ZEMP.

{ZCHGHR,ZEG,ZP,ZC,ZEMP,ZPOS} = ZV.

ENDFOR.

IF PERIOD > 12.

EXIT.

ENDIF.

ENDFOR.

ENDDO.

Now for the question: Can I copy key figures values without the existing characteristic values, AND , update the new record with charateristic values from a existing record which are not attributes? And if yes, how can I do it.

Many thanks in advance

Wendy