Skip to Content
0
Former Member
Nov 07, 2012 at 03:09 PM

Aggregate without adding values

30 Views

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.