on 12-12-2014 10:00 AM
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
Month | ZCOST | Ordered € | KPI_2 |
---|---|---|---|
11.2014 | 9500 € | 15000 € | OK |
12.2014 | 6200 € | 5000 € | KO |
This is just an example of master data of infoobject ZVEND:
ZVEND | ZCOST |
---|---|
1100000090 | 3000 € |
1100000091 | 6500 € |
1100000092 | 3200 € |
The detail in the infocube for the months is this:
0CALMONTH | ZVEND |
---|---|
11.2014 | 1100000090 |
11.2014 | 1100000091 |
12.2014 | 1100000090 |
12.2014 | 1100000092 |
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 | |||||
| Cost | No of PO items | PO quantity | Cost SUM | |
F000000 | 310.000,00 EUR | 0 | 0 EA | 310.000,00 ERROR | |
F000001 | 99.000,00 EUR | 2 | 20 EA | 396.000,00 ERROR | |
F000002 | $ 150.000,00 | 1 | 10 EA | 300.000,00 ERROR | |
F000003 | 310.000,00 EUR | 1 | 51 EA | 620.000,00 ERROR | |
F000004 | $ 150.000,00 | 0 | 0 EA | 150.000,00 ERROR | |
F000005 | $ 150.000,00 | 0 | 0 EA | 150.000,00 ERROR | |
F000006 | $ 150.000,00 | 0 | 0 EA | 150.000,00 ERROR | |
F000006 | 310.000,00 EUR | 1 | 10 EA | 620.000,00 ERROR | |
F000007 | 310.000,00 EUR | 2 | 70 EA | 1.240.000,00 ERROR | |
F000008 | 310.000,00 EUR | 1 | 74 EA | 620.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
I did try this and i think is working, that should do the trick.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.