BusinessObjects Board

Table Names in Universes

building reports desktopintelligence
#1
  1. We are in the process of changinga very critical and widely used table. I have several Universes and Reports based out of this table. To make an impact analysis I have pulled up the Repository tables and trying to hit the UNV_TABLE.

It is only listing 178 entires. Is there something wrong. We have more than 50K tables in the databases ?

  1. Is there any other way to get all the Universes based on the table name ?

  2. Is there some canned audit reports and Universe for 5i posted in this firun to be used ?

Thank you. :reallymad:

jdrc :us: (BOB member since 2002-09-18)

#2

BO repository table UNV_TABLE contains only those database tables that are used in the BO universes that were exported to the BO repository

Have a look at this BO universe documenting utility

Marek Chladny :slovakia: (BOB member since 2003-11-27)

#3

I am sure the table I’m trying to look up has been used in a Universe that is in the repository. All our Universes are in the repository.

I’m not looking for Universe documentation. A reverse engineering situation where trying to find all the Universes that are attached to a particular table.

Thank you.

jdrc :us: (BOB member since 2002-09-18)

#4

The following query against the repository will return all universe that contain the given table:

SELECT
UNV_UNIVERSE.UNI_FILENAME,
UNV_UNIVERSE.UNI_LONGNAME
FROM
UNV_UNIVERSE,
UNV_TABLE unv_list_of_tables
WHERE
( UNV_UNIVERSE.UNIVERSE_ID=unv_list_of_tables.UNIVERSE_ID(+) )
AND (
unv_list_of_tables.TAB_NAME = ‘YOUR_TABLE_NAME’
)

ronpadz :us: (BOB member since 2005-09-14)