Question:
Hi,
We have infocube ZTC_COPC3 (T: Material Ledger Cost Component Split) with key figure "ZQTY_CCMP - Quantity".
ZQTY_CCMP - Infoobject properties
Aggregation Summation
Exception aggregat. Maximum
Agg.referen.char. ZCCOMPHLP
where ZCCOMPHLP is compounded by:
0CCOMPSTRUC Cost Component Structure 0CCOMPSTRUC
0COSTCOMP Cost Component 0COSTCOMP
0CLEVEL_IND Level/Lower Level Indicator 0CLEVEL_IND
THe data into infocube is already loaded for the last 2 years and when we run query using this keyfigure, the summation but it does not add up straight because of "Aggregation" properties.
Now the question is:
Can we define a new(Calculated key figure) keyfigure at query level, where it adds up the rows straight? (i.e. using user exits, etc.)
If the answer is "YES", How do we do it?
NOTE: The only keyfigure available from the BW infocube on quantity is "ZQTY_CCMP" which is listed above.
We could see the rows in the "LISTCUBE" tcode in the BW, but when we run the query it is coming up with diff. totals.
Thanks for your help.
Answer:
Why do you have Acception Aggregation set up to Maximum?