cancel
Showing results for 
Search instead for 
Did you mean: 

How to aggregate a KF in BEX which is an attribute of a InfoObj (avoiding sum)?

former_member285493
Participant
0 Kudos

Hi all,

i've a requirement in a report that now I'll try to explain in detail.

We have a attribute (ZCOST) of a new infoobject (ZVEND) that i need to use in a new report using BEx analyzer (we have BI 7.3), the attribute ZCOST is a currency and an example of the report layout is the following

MonthZCOSTOrdered €KPI_2
11.20149500 €15000 €OK
12.20146200 €5000 €KO

This is just an example of master data of infoobject ZVEND:

ZVENDZCOST
11000000903000 €
11000000916500 €
11000000923200 €

The detail in the infocube for the months is this:

0CALMONTHZVEND
11.20141100000090
11.20141100000091
12.20141100000090
12.20141100000092

So our goal is to have in the bex report under the column ZCOST the sum of the KPI for each different value of ZVEND, the problem is that of course the report is aggregate and I cannot sum the same ZVEND key more than once (this value is kind of a budget for ZVEND).

It is clear what am i trying to do here?

My problem is to avoid summation of all the values of ZCOST in the infocube, the drill dimension are variable so there isn't just the month usually.

If anything is not clear feel free to ask for other details.

Thanks

Stefano

Accepted Solutions (1)

Accepted Solutions (1)

ccc_ccc
Active Contributor
0 Kudos

Hi Stefano,

I understand requirement, to help you in better way  , could you please share some sample report output what is current and what is expected.

So that I will try to help you.

Thank you,

Nanda

former_member285493
Participant
0 Kudos

Hi Nanda,

at the moment what i've tried (and it seems to work although after not much testing) is to create a variable in Bex to use in a formula to pull data from master data of ZVEND.

Table
Material
CostNo of PO itemsPO quantityCost SUM
F000000310.000,00 EUR00 EA310.000,00 ERROR
F00000199.000,00 EUR220 EA396.000,00 ERROR
F000002$ 150.000,00110 EA300.000,00 ERROR
F000003310.000,00 EUR151 EA620.000,00 ERROR
F000004$ 150.000,0000 EA150.000,00 ERROR
F000005$ 150.000,0000 EA150.000,00 ERROR
F000006$ 150.000,0000 EA150.000,00 ERROR
F000006310.000,00 EUR110 EA620.000,00 ERROR
F000007310.000,00 EUR270 EA1.240.000,00 ERROR
F000008310.000,00 EUR174 EA620.000,00 ERROR

This is an example of what I did, the first column is the right value, it shows the unaggregated data from master data of ZVEND even if there are several rows for eache material.

The last column is (Cost SUM) is the aggregated data, which is wrong, because the Cost is summed for every row in the report.

Regards

Stefano

Former Member
0 Kudos

Hi ,

Can you try to create a formula and put zcost in it . then use exception aggregation on Zvend in Bex query designer.

Answers (1)

Answers (1)

former_member285493
Participant
0 Kudos

I did try this and i think is working, that should do the trick.

Thanks