Hi,
I'm going to write an easy example to explain my problem. For example, I've the following infocube:
dimension dimension ratio (infoobject)
COD_REF TYPE_REF MYRATIO
A1 T1 7
A1 T3 7
A1 T4 7
A2 T3 9
A2 T5 9
A3 T6 4
The question is that the value of MYRATIO depends on the COD_REF dimension and is always the same for each COD_REF. But, in Bex, when I aggragate by TYPE_REF dimension it adds all the values and it's the result:
COD_REF MYRATIO
A1 21
A2 18
A3 4
I want to get the following result:
COD_REF MYRATIO
A1 7
A2 9
A3 4
In the attributes of the ratio I can add, max, min and so on but there isn't any option that says not to do any action.
How can I solve this from Bex? or is it necessary to do this from BW?
Can anybody help?
Thanks in advance.
Regards.