Number of tables, classes, objects associated to universes

[Former Member]

Hi,

Below SQL shows count of webi reports per Universe in ascending order.

SELECT SI_NAME, SI_WEBI FROM CI_APPOBJECTS WHERE SI_KIND='Universe' AND SI_WEBI.SI_TOTAL >=0 ORDER BY SI_WEBI.SI_TOTAL asc

I want to enhance it to show with columns has No. of Tables, No. of Classes, No. of Objects associated with each universe. Is it possible with above SQL by changing in it ?

Thanks,

Venkat

[former_member205064]

If you are looking for select query then its not possible.

thre is a way to get the data though this tool:-

Universe Documenter

[Adam_Stone]

Short answer - nope.

Long answer - You can change the select to be * to see all that can be returned, but the information you are looking for is not stored at the database level.  Webi documents will store the specifics of what they use in the file directly, the Universes will store this information in the file itself.  The only way to get this information is to open them directly, either manually or through the SDK to inspect them.