Skip to Content
0
Former Member
Apr 30, 2014 at 05:33 AM

How to calculate and save planning data in bex input-ready query using keyfigures for calculation from different infoproviders

32 Views

Hi Dear All,

We have two real time infocubes and two aggregation levels based on these cubes in one multiprovider

first cube1 is like
char1| char2| keyfig_coefficient(single value for each combination of char1 and char2)
same aggregation level1
(we have input query to fill coefficients by one responsible user)

second cube2 is like
char1| char2| keyfig_quantity| keyfig_result
same aggregation level2

Input ready query should be like (for all other users of different org units)

char1|char2|keyfig_coeff| keyfig_quant(for input) | keyfig_result = keyfig_coeff*keyfig_quant(calculated value, should be saved to cube2)

And we don't have pregenerated lines in cube2, users have to add new lines themselves by wad.

Question is, what is the optimal (easiest) way to make calculation and save result data to cube2 where keyfigures for calculation should be used from different infoproviders. I need just a hint.

Appreciate any help.

Nadya.