Skip to Content
0

Overall Result coming blank in BEx Report

Apr 04, 2017 at 06:17 PM

130

avatar image

Hi,

I am facing problem in the result of the difference in days.

Our requirement is to get difference no. of days where posting date – clearing date & if the document is not cleared then calculate as report run date i.e. posting date – report run date. I am getting the figures correctly but the total is coming blank. I cannot use SUM from properties because I require the total to be calculated automatically. Please HELP!!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Loed Despuig Apr 05, 2017 at 07:26 AM
0

Hi,

Can you post a sample scenario?

Regards,

Loed

Share
10 |10000 characters needed characters left characters exceeded
John Hawk Apr 18, 2017 at 09:38 PM
0

Hi Arapn,

My guess is that you need Exception aggregation to the level of calculation and a bunch of Boolean logic.

John Hawk

Share
10 |10000 characters needed characters left characters exceeded
Szabolcs Cseh
Apr 20, 2017 at 01:54 PM
0

Hello Arpan,

With the information available so far, I would say that either exception aggregation (mentioned by John) or local calculations could be used to ensure the desired results in the result rows. What should be kept in mind is that the OLAP engine by default does the aggregation first and then calculates the defined formula using the aggregated results of the operands.

You can find examples and a detailed description of the mentioned features in the following wiki pages:

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

Local calculations ("calculate results as:", this is just a display feature so further calculations would not be available with the value):
https://wiki.scn.sap.com/wiki/display/BI/OT-OLAP-LO

This is just a suggestion of course based on the available information, if you can post a bit more detail regarding the query design maybe we can provide a more exact anwer.

Best Regards,
Szabolcs Cseh
SAP Product Support

Share
10 |10000 characters needed characters left characters exceeded