SAP Knowledge Base Article - Preview

1835823 - Oracle Synonym Column Not Displayed in Universe Design Tool

Symptom

  • Oracle synonym columns in Universe Design Tool missing
  • Synonyms are not visible in UDT 4.0 and worked fine in Designer 3.1 with same connection from Oracle.
  • In UDT 4.0 synonym name is visible and column values, but not column name 
  • Private synonyms belonging to other users are not visible in table browser of Universe Designer Tool.
  • You can see public synonyms by setting the <Parameter Name="OWNER">N</Parameter> in oracle.prm file.
  • In XI 3.1 all BO versions you can see private synonyms of other users.
  • You can see the private synonyms belonging to the user whose credentials we are specified in the Universe connection.
  • Missing synonyms in multisource universe


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform 4.x
  • Information Design Tool (IDT)
  • Universe Design Tool (UDT)
  • Oracle Native Client

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1

Keywords

Synonym, column values, not displayed, Universe Designer, Universe Design Tool , KBA , BI-BIP-UDT , Universe Design Tool , 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.