Skip to Content

how to get the Non Cumulative value in Bex Query

HI,

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Dec 03, 2016 at 07:32 PM

    Hi,

    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

    Thanks,
    Diego Seben.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.