Tables added to the Structure Pane(Universe),but Tables columns are not visible in UDT

[Former Member]

Hi,

I am facing issue with my universe. When i add tables to the structure pane and table it self is visible, but the columns in the table are not visible.But, i am able to see the other table columns.

Do i need to have any special access rights , to see the table columns in the universe structure pane?

[former_member185603 · Accepted solution]

You need to change oracle.sbo file

C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\oracle

update the oracle.sbo file with “Include synonyms= true”

[Joe_Peters]

Are you using Oracle, and are the tables referenced via synonyms? UDT doesn't handle synonyms well by default. See SAP note 1622792.