SAP Knowledge Base Article - Preview

1911233 - Hint Parameter is not working In Universe Design Tool and Information Design tool

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.