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 infoobject MYRATIO I can sum, min and max when aggregating.
Perhaps it can be solved from Bex but I'm not sure.
Can anybody help?
Thanks in advance.
Regards.