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.