SAP BW 7.4 - Web results differ from RSRT (HTML) results

[Former Member]

Hey Guru´s

We are running SAP 7.4 under SP7. When we execute queries in web environement (IE, Chrome, etc) the results do not match the data in the cube. Furthermore when running the same query under RSRT using the HTML option, the results are correct. Has anyone encountered this issue? If so, what were the correction steps?

Below our SPs.

SAP_BASIS 740 0007 SAPKB74007

SAP_ABA 740 0007 SAPKA74007

SAP_GWFND 740 0007 SAPK-74007INSAPGWFND

SAP_UI 740 0009 SAPK-74009INSAPUI

PI_BASIS 740 0007 SAPK-74007INPIBASIS

ST-PI 2008_1_710 0009 SAPKITLRE9

BI_CONT 757 0002 SAPK-75702INBICONT

BI_CONT_XT 757 0002 SAPK-75702INBICONTXT

SAP_BW 740 0007 SAPKW74007

CPMBPC 810 0002 SAPK-81002INCPMBPC

POASBC 100_731 0005 SAPK-10205INPOASBC

HANABPC 810 0002 SAPK-81002INHANABPC

Thanks,

Alex

[Former Member · Accepted solution]

After analysis, we found out that the reason we were having misplaced results under the web environment was due to having our JAVA SP7 contente under patch level 0. After updating the patch level of the JAVA componente, the issue was solved.

[Former Member]

Can you provide more details concerning what is different between RSRT and BEx Web (Is it just the values in the report?).  You can try regenerating the query in RSRT (click on the generate button).

If the results are different in BEx Web, I'm wondering if there are authorizations on BW data which could be filtering the results of your report.  Are you using the same selection criteria in RSRT as you are using in BEx Web?

[Former Member]

The difference is exclusive to the values. Column and line layouts are ok. The values in the web environment are plotted randomly in wrong columns and possibly lines.

Also the result differs when filtering a single item (0sem_posit in this case). In other words, when running the report with all item the line for a specific item shows one result, and when filtered to that item, the result is different. The query is not input ready either.

We are running under dev environment with a SAP_ALL user, authorization should not be an issue. The selection under both executions (RSRT and Web) are exactly the same.

The original query has selection on hierarchy nodes and hierarchy is active under drilldown. Created a test query removing all user-exit variables and hierarchy, cleaned the cache, but the problem persists. It seems that it may be related to the Java/Webdynpro componentes used in the front-end.

Regards,

Alex

[Former Member]

Are you using IE 10 x64 per chance?

[Former Member]

We are running under IE 10 and Chrome, both show the same result. Windows is 32-bits.

Just installed Firefox to test the cenário as well, but unfortunately we got the same result.

[Former Member]

Further analysus indicates that the Web front end has issues treating a dynamic selection (fiscyear) for example followed by a structure.

If the scenario is reversed, the results are correct.