Copy of key figures in rwo characteristics in BI IP

[Former Member]

dear all,

I need to copy key figure associated with employee group to the same key figure of employee.

As far as relation is concerned, employee has an attribute employee group. Its a copy and not distribute.

I need to get employee group from the planning, get the associated employees and then copy key figures. Is there any other way that exit function? Will hierarchy help here?

Regards,

Pal

[Former Member · Accepted solution]

Hi,

You can create a FOX to copy data from employee Group to Employees . To read all employees for that employee group you need to call a function module which returns the list of employees you want one by one. So the first call of the function module will retrieve the first employee for that employee group from employee master data table & a flag which says that there are more employees for that employee group. The second call will retrieve the second employee and a flag which says that there are more employees and so on. If there is no more data, the flag is set accordingly and you can stop calling your function.

Regards,

Deepti

[Former Member]

Since your requirement does not fully give all details, let me assume certain parameters,

IF you want to copy data from employee group to all employees and there are multiple employee groups and both employee groups and employees characteristics are in planning level/aggregation level, you can make use of FOX to write a copy function.

Ex:

DATA EMPGRP TYPE ZEMPGRP.

DATA EMPGRP1 TYPE ZEMPGRP.

DATA EMP TYPE ZEMPLOYEE.

DATA AMT TYPE F.

FOREACH EMPGRP.

FOREACH EMP.

EMPGRP1 = ATRV('ZEMPLOYEE',EMPGRP).

IF EMPGRP = EMPGRP1.

{AMOUNT,EMP} = {AMOUNT,EMPGRP}.

ENDIF.

ENDFOR.

ENDFOR.

If you have additional charcteristics and if needed include that also in 'Fields to be Changed'.

Hope this helps.

Raga

[Former Member]

hi deepti angel,

thanks .. How about creating a multiprovide on top of infocube and 0employee. Will that save abap call?