Splitting Key Figure Values 

Use

You can create several update rules for each key figure in an InfoCube and each data field in an ODS object.

In a company, a sales employee generates a particular volume of sales revenue. In the InfoCube, you want to assign 90% of this sales revenue to the employee (routine 1) and 10% to the employee’s immediate superiors (routine 2).

There are two methods that you can use to split key figure values:

1. Copy Rules

You copy an update rule. You can then assign a different update method to this copy of the update rule. This also gives you the option of updating a key figure with different keys.

In the above example, you create an update rule with routine 1 (90% of the sales revenue assigned to the employee in the InfoCube). Copy the update rule. Maintain routine 2 (10% of the sales revenue assigned to the employee’s immediate superiors) in the copy of the rule, and make the necessary changes in the Characteristic Calculation tabstrip.

2. Routine with Return Table

Update routines generally only have one return value. However, in the Key Figure Calculation tabstrip, you can create a routine by choosing the Return table option. The corresponding key figure routine now has a return table instead of a return value. You can now generate as many key figure values as you like from one data record.

In the routine editor, the calculated characteristic values are stored in the ICUBE_VALUES structure. Change these values accordingly (in the above example: Employee), fill the field for the relevant key figure (in the above example: Sales revenue), and use this to fill the RESULT_TABLE return table.

If you are familiar with ABAP programming, you should use this option, because it gives you a better understanding of how a key figure is updated.