Question:
Hi,
My client needs an report which is using multiprovider from cubes:
Profit center: Transaction data 0EC_PCA_1
Profit center: Statistical Key Figures 0EC_PCA_2
Ok, everything simple for now..
In 0EC_PCA_1 we have an currency type keyfigures
and in 0EC_PCA_2 we have MWh kind of keyfigure (quantity).
We need to compare and do calculations between these two keyfigures.
And then report should look like this:
...................Amount.....Type
-------------|-----------|-----------|
Keyfigure 1.......2000...Eur.............<- From 0EC_PCA_1
-------------|-----------|-----------|
Keyfigure 2........120...MWh...........<- From 0EC_PCA_2
-------------|-----------|-----------|
KF1 / KF2..........16,6...Eur/MWh
-------------|-----------|-----------|
How can i use different types of keyfigures in one column?
One solution I thought, was to add one more column to 0EC_PCA_2
which is same kind than 0EC_PCA_1-"currency" and with ABAP code
move this MWh keyfigure into that field and so on and so on...
...but I hate to do this kind of hacking...
Is there someting I am missing about using Bex?? Please help...
Answer:
No! You're only messing about
_________________
Keep smiling
Answer:
No! You're only messing about
So is this possible or not? Please help..
Answer:
just use the 'NODIM' function in your BEX formulas...