BusinessObjects Board

Getting Actual Tables used by Universe from BOMM repository?

I need to get a list of all tables used by each Univserse from the BOMM repo.
I’m using the mmrv_universe_model view but that only gives me alias names where a table is used more than once.

Does anyone know which tables to link to so I can get the ACTUAL table?
I’m assuming its stored somewhere in there order to figure out the lineage links through from BODI jobs.

Thanks


ScoobyDoo :uk: (BOB member since 2007-05-10)

mmd_universe - List of all the universes
data_group_id - Universe ID
technical_name - Universe Name

mmd_universe_class - List of Classes in a universe
data_group_id - Class ID
technical_name - Class Name
parent_group_id - Universe ID

mmd_universe_object - List of objects in a class
data_element_id - Object ID
technical_name - Object Name
data_group_id - Class ID


SumithaKM (BOB member since 2012-02-29)