Skip to Content

Restricting key figures in BEx

Hi,

I've a reporting requirement.

The user wants to display single line item for each invoice document.

tax-1.jpg

So, I removed the Bill document number, but the problem I'm facing is the tax amount is getting summed which shouldn't happen as per requirement.

tax-3.jpg

I want to avoid summing the tax amount and display it as a single amount.The tax amount value is singular for invoice.

Can this be achieved in BEx?

This is the output I want to display

tax-2.jpg

Kindly, please let me know.

tax-1.jpg (26.7 kB)
tax-2.jpg (19.1 kB)
tax-3.jpg (20.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 26, 2017 at 10:36 AM

    Hi,

    please set exception aggregation on your KF, you can set it in your query designer or in BW (this makes sense if it generally the way the use this key figure)

    check out blog:

    https://wiki.scn.sap.com/wiki/display/BI/OT-OLAP+Exception+Aggregation#OT-OLAPExceptionAggregation-ExceptionAggregation

    if you need help, let us know

    grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 28, 2017 at 01:20 PM

    Hi there, you can do it as much complicated as you want (the system has no limits).

    Create a new formula and count on billing doc then divide the tax amount with the counter.

    Yiannis

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 26, 2017 at 02:19 PM

    Hi Koen,

    Thank you for your inputs!

    I’ve applied exception aggregation to the Tax amount at BEx level. There is a small issue here through for certain line items where the bill document number is same, the tax amount is getting summed.

    Source:

    BEx Query:

    tax-4.jpg

    I tried adding Line item as a ref. char in aggregation tab but, the tax amount isn’t showing correct.

    Expected Result:

    tax-6.jpg

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Koen,

      Greetings!
      Our current system is BW 7.3. We are in the process of upgrading our system to BW 7.5.

      Once the system gets upgraded I am sure I'll be able to define more than 1 exception agg char.
      I'll keep you posted on this as & when I resolve this issue.

      Thanks,

      Faheem