Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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
Aparajit

Former Member
Not what you were looking for? View more on this topic or Ask a question