SAP Knowledge Base Article - Preview

2153553 - DISTINCT keyword in the SQL statement is missing when viewing query script in IDT

Symptom

  • The keyword "DISTINCT" is missing when viewing the query script in IDT.
  • No issue in UDT.
  • Same issue converting a .unv universe to a .unx.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.x
  • Information Design Tool (IDT)

Product

SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3

Keywords

bi 4.2, bi 4.3, sql, distinct, difference, diffrent, incorrect, idt, udt, conversion , KBA , BI-BIP-SL , Semantic Layer , 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.