This website is not affiliated with, sponsored by, or approved by SAP AG.

Bex: Supress line items - show only results

Business Warehouse

Moderators: Snowy, thx4allthefish

Bex: Supress line items - show only results

Postby xmchx » Thu Feb 28, 2013 4:35 am

Dear all,
I have a bex-query for customer open items. There is a variable for the date of open items. The query has the following structure:

Customer / Invoice No. / Open item amount (based on date variable) / days overdue / amount overdue / calculated interest
IT10 / 1001 / 100,- / 360 / 100,- / 8,-
IT10 / 1002 / 200,- / 360 / 200,- / 16,-
IT10 / 1003 / 400,- / 360 / 400,- / 32,-

The first tree columns are based on our loaded data. The days overdue, amount overdue and calculated interest colums are calculated in the query on each line!

For the calculated columns, we have set the definiton of the keyfigures (local calculation) with the option "calculate Results as Summation".

So far everything works fine! The result is:

Customer / Invoice No. / Open item amount (based on date variable) / days overdue / amount overdue / calculated interest
IT10 / 1001 / 100,- / 360 / 100,- / 8,-
IT10 / 1002 / 200,- / 360 / 200,- / 16,-
IT10 / 1003 / 400,- / 360 / 400,- / 32,-
IT10 Result 700,- - 700,- / 46,-

Now the problem: I would like to show only the result line! - I can not find an option to shwo only the result line. I also can not reduce the characteristics (delete Invoice no for example), because I need the detailed calculation on each line item.

Do you have an idea how to do this?

Advanced question: in the next step I would like to show only the TOP-10 overdue customers (based on the overdue amount in the result line)

We are on BW 7.0.

Thanks vor your feedback!

xmchx
xmchx
 
Posts: 73
Joined: Sun Apr 05, 2009 11:10 pm

Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 3 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.