Unable to see Synonyms columns for Oracle driver

building semantic layer
1

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 other parameters should I change in client to view synonyms columns using oracle client driver? Pl. help.

Thanks
Venkat

[Moderator note: Edited, removed blank lines :? for easier reading. Thanks, Andreas.]

venkat4838 (BOB member since 2013-03-19)

2

This link may help:-

http://rakshits-bi.blogspot.co.uk/2011/09/sbo-designer-enable-use-of-synonyms-in.html

Mak 1 :uk: (BOB member since 2005-01-06)

3

Thank you for response.

Even I didn’t as it mentioned , it didn’t resolve the issue.

We are on Oracle and BI4 SP04.

Not sure we need to change the strategy to external in Universe parameter. In IDT, we don’t have these strategy option.

Any other suggestions?

Thanks
Venkat

venkat4838 (BOB member since 2013-03-19)

4

You mean you see the grant’names’ but not the columns?

Same here, but also for my tables and views my BO-account is allowed to use.
I need to go via the owner of the table or view to see the columns.
Looks like something has changed for the oracle-user.

Silly thing is that in UDT deleting the owner after you dragged it in then still works, you do see the columns :roll_eyes:

So if anybody knows how to fix this i’d love to know as well…

IngeH :netherlands: (BOB member since 2004-06-22)

5

Has anyone found a solution to this? My problem does not exactly match the above – I can’t even see the tables listed in the table browser after setting Include Synonyms" to True.

Joe

joepeters :us: (BOB member since 2002-08-29)

6

Has anyone found a solution for this? I cannot see columns even after changing the Synonym parameter to “True”.

Thank you. :hb:

soulie :us: (BOB member since 2005-03-15)

7

There were a number of fixes along the way. We’re on SP05 now and it seems to be working.

joepeters :us: (BOB member since 2002-08-29)

8

In :\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\oracle\oracle.sbo change False to True that fixed it in my environment.

Additional info available at https://launchpad.support.sap.com/#/notes/1835823/E

triniman8 :trinidad_tobago: (BOB member since 2004-08-22)