Skip to Content
Sep 16, 2014 at 06:27 AM

Kig figure Display Requirement in BEx


Dear Experts,
I have a Bex report for Buffer Norm where I have two keyfigures.
1. Maximum Stock Level and 2 Closing Stock
In the report the Maximum Stock level keyfigure is displayed as an aggregated value while the closing stock is okay.
On analysis i found for every material there are four entries of record rows. I need to display only one of them in the report as such to pick only that record for the material where closing stock is not zero.
Attaching the screen shots.
At Cube level:

At Report Level

Need to show:
Maximum Stock Level = 65 and Closing stock = 57
Can you suggest how to pick only those required values from the cube.
I was thinking to use exception aggregation for the keyfigure Maximum Stock Level. But no idea how or if it will work.

Thanks and Regards


buffer norm.png (12.3 kB)