SQL from Derived Tables in Universe

[Former Member]

I have about 85 Derived tables in my universe. I want to get SQL behind all the derived tables to search for a string. Is there a way to get sql query exported to a PDF document. I saved the universe as PDF but it does not have the sql behind the derived table. please advice

[MariannevL · Accepted solution]

Hi,

Actually as a best practise, I always save the derived table sql separately as a .sql file too.

I can use it to run them separately, explain a little bit about the use etc.

So going through the excercize of editing/copying/saving might be of use.

If this is a one time only thing, here's a work around;

copy the universe, make sure it has a 'readable' name that tells this is just a work-version.

delete all joins, yes ALL joins.

enable the generation of cartesian product (warn iso prevent).

create a dummy object any valid select will do, like 'x'.

enter the tables... button

select all derived tables.

save the changes.

go to the lov query of the object, show the sql and select&copy everything in the from clause.

This is a full list of all the sql contained in the derived tables

tagged with the name you gave them in the universe.

Paste&save in a word or text document and search away...

Good luck,

Marianne