Skip to Content
0
Former Member
Dec 30, 2015 at 07:33 AM

Number of tables, classes, objects associated to universes

20 Views

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