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

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.