Skip to Content
0
Jun 24, 2018 at 07:38 AM

Derived and Raw Table SQL

145 Views Last edit Jun 24, 2018 at 07:52 AM 2 rev

Hi.

New to Business Objects unverses.

I just wondering what is the best way to get a list of ALL tables that are used within a Universe - including within a derived table?

When exporting to pdf I get list of tables but where a derived table has been used I only get it at that level - I need to understand the tables that make up the derived tables too.

I can go an get the SQL script for each individual table but there are hundreds of derived tables in the universe I've inherited. Is there a way of bulk downloading the SQL script or the tables?

Thanks