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