SAP Knowledge Base Article - Preview

1199607 - Converting a Desktop Intelligence report to Web Intelligence report when the filter contains a measure and the Scope of Analysis is set results in a different query being generated

Symptom

A different query is generated after converting a Desktop Intelligence report to Web Intelligence report when the filter contains a measure and the Scope of Analysis is set. For example, on Desktop Intelligence, if the column Col1 is the result object, the measure Sum(Col3) is contained in the filter, the column Col1 and Col2 are set on the Scope of Analysis, the following query is generated:
 
SELECT Col1, Col2
FROM Tab1
GROUP BY Col1, Col2
HAVING ( Sum(Col3) > 100 )
 
After converting it with the Report Conversion Tool, the following query is generated on Web Intelligence:
 
SELECT Col1, Col2
FROM Tab1
WHERE Col1 In
     ( SELECT Col1
       FROM Tab1
       GROUP BY Col1
       HAVING Sum(Col3) > 100 )
 
This could cause the converted report to return different results than the original.
 


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI

Keywords

deski webi RCT , 4335465 , KBA , BI-RA-WBI , Web Intelligence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.