Find a table name in Universe

[former_member1130557]

Hi,

I am new to Universe Design Tool. I am using version 4.0. I import a universe called MyUniverse on C:\Users\Myuser\AppData\Roaming\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\Universes\..\MyUniverse

I can't connect to the database because the database is no long use. I just want the universe because it will mapping to new database. I want to know where a table come from if this table is an alias. Here I would like to know the Temptable_B, Temptable_C, and TableE. How can I check? The universe look like (there are more tables, I just pick some as example):

Thank you in advance!

[daniele_tiles2]

Hi Jennifer,

it's quite easy to understand from the universe which table is a "real" table, and which is an alias.

As an example, look at this:

The Universe table is called L_BEN_BENEFICIARIO_REG_RIT_PAR, and it's an alias of the table L_BEN_BENEFICIARIO (the name between ( and )).

If the backgrouund is darker, then the table is a Derived Table, which means it's a query made on other tables defined in the universe/existing in the connection used in the database:

If you right click on this kind of table and select "Modify Derived Tables" you get the underlying SQL:

I highly recommend to try to switch to UNX (universes developed with Information Design Tool): the Universe Design Tool is an old system, there will be no major updates for it, while for a while the UNX will be enhanced (there are some interesting features in Information Design Tool, like query stripping, and so on...).
HTH (and you didn't post with the right tags I guess).

Daniele

edited for uploading the images, didn't show them...