Column Names for Synonyms not displayed in IDT

[system]

Hi,
I am trying to create a new data foundation using IDT.
BO 4.0 SP 9
Tool IDT
Connection - Oracle 11 ODBC

I added a few synonyms and I cannot see the column names under the tables.
We have had this issue in Designer 4.0 SP9 and we modified the orable.sbo files synonym parameter to True.
It was fixed in Designer. But IDT still has this issue.

Is there any other place we need to fix the parameter?

---

bobj_user_a (BOB member since 2010-03-25)

[system]

Found these posts on searching semantic layer forum with keywords “synonyms”

120×120 10.4 KB

Hi, We are trying to insert Synonyms in the universes (UNV/UNX). As per SAP suggestion, we changed the oracle.sbo file for below parameter in both server and client: <Parameter Name="Include Synonyms">True</Parameter> In Client tool (UDT ), if I use ODBC driver to connect to database, then I was able to see the columns. If I user Oracle client driver to connect to database, then I was NOT able see the columns. In Server, we have UDT installed. It is working fine for both cases. Is any othe…

120×120 10.4 KB

I’ve converted a .unv universe to .unx. The universe is built on Oracle synonyms of materialized views. The .unv (3.1) version works correctly. Completing integrity checkings on the new .unx version I receive error messages like: “Table AAA referenced in data foundation BBB does not exist in the database.” I suppose the error messages like below are only consequencies: “Failed to execute the expression for business object ‘CCC’. Check the object properties.” It is maybe surprising that I can…

---

haider (BOB member since 2005-07-18)

[system]

Found the cause and resolution -

Doing some research, I noticed that modified Oracle.sbo file on the client machine fixed the synonyms issue in Designer unv and Single Source unx…

For Multisource enabled Unv, oracle.sbo files need to be altered on the server.
We tried and it worked for us.

http://www.botrainingonline.com/sap-business-objects/synonym-columns-are-not-visible-in-data-foundation-of-multisource-universe/

---

bobj_user_a (BOB member since 2010-03-25)

[system]

Changing in ‘Oracle.sbo’ the synonyms-parameter to

<Parameter Name="Include Synonyms">True</Parameter>

appears to work in many early BO 4.x versions.

Unfortunately it looks like SAP has re-introduced the missing-columns bug in IDT Version 4.2 Support Pack 3 Patch 5 (Build: 14.2.3.2351). This time the resolution above has no effect.

Anyone else experiencing the same?

Update 24-05-2018: Issue is resolved. It appears the change to ‘Oracle.sbo’ was done post-installation of Support Pack 3 Patch 5. After restarting Server Intelligence Agent the synonym-columns are visible.

---

Tim Janssen (BOB member since 2004-09-10)