Skip to Content

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

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 09 at 01:26 PM

    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”

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 09 at 12:27 PM

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

    Add comment
    10|10000 characters needed characters exceeded