BO4 - Synonyms + idt

[former_member272336]

Hi,

We currently use tables and views in our universe.

Being proposed to use synonyms which in turn point to tables/views.

Using idt tool (unx universe ) - assume this is possible - any issues.

Trying this out looks to work however we donnot see the columns listed on the synonym looks to work ok but donnot see them so need go back to database to see what they are.

Anyone seen this behaviour and any way to see column names for synonyms.

Thanks

[former_member683001 · Accepted solution]

Hello

See Note SAP 1622792 - BI 4.x Columns from Oracle synonym tables are not visible in data foundation and universe structure

that did the tricks !

Pascal

[former_member4998]

Hi

Please check the below links

https://scn.sap.com/thread/3207128

http://stackoverflow.com/questions/20679768/use-different-schema-name-than-the-username

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_7001.htm

[former_member272336]

Thanks for replies.

Changed sbo file toinclude sysnonyms with True parameter and after refresh structure can see columns