Skip to Content

how to get the Non Cumulative value in Bex Query

Dec 03, 2016 at 12:22 PM


avatar image


I am create Bex Report based on the Infocube.

Cube Structure like.

Dealer ID Material Labour Rate Spare Rate

101 M1 100 200

101 M2 100 100

101 M3 100 200

101 M4 100 300

when create a Bex Query it's showing cumulative value.

I want result like this

Dealer Id Labour Rate Spare Rate

101 100 800

How to Get this result.

10 |10000 characters needed characters left characters exceeded

Hello Vinod - I changed your primary tag to Business Explorer for faster response; please use the right tag in the future for faster replies. A list of tags can be found here:

Please also search before you post according to the site's rules

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Diego Seben
Dec 03, 2016 at 07:32 PM


For helping out here read the following information from links below:

Non-Cumulative Key Figures

2290290 - Non-Cumulative keyfigure value calculation Report

Modeling Non-Cumulatives with Non-Cumulative Key Figures

Diego Seben.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks for your support