Symptom
- SQL generation in WebI report is different From Designer when using Hint parameter for indexing in connection details.
- The SQL generation in WebI report is different that SQL generation of universe designer. Due to which the indexing is failing.
- Hint parameter appears before DISTINCT in designer query panel; however Hint parameter appears after DISTINCT in WebI report when ‘Retrieve duplicate rows’ option is unchecked.
- Below are the SQL generated when we use hint parameter on Oracle default EMP and DEPT tables.
Universe(UDT):
SELECT/*+ Index (SCOTT.EMP.EMPNO) */ DISTINCT
SCOTT.DEPT.DEPTNO
FROM
SCOTT.DEPT
Webi report:
SELECT DISTINCT /*+ Index (SCOTT.EMP.EMPNO) */
SCOTT.DEPT.DEPTNO
FROM
SCOTT.DEPT
Read more...
Environment
- SAP BusinessObjects Business Intelligence platform 4.x
- Information Design Tool
- Web Intelligence
- Universe Design Tool
Product
SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3
Keywords
Hint, HINT_BEFORE_DISTINCT, DISTINCT clause , KBA , BI-BIP-SL , Semantic Layer , Bug Filed
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.