I want to find out which tables be used in a universe , but i can’t get any information from sql
select * from ci_systemobjects
select * from ci_infoobjects
select * from ci_appobjects
who can help me ? where are they stored ?
thanks your reply, do you have any jsp code of dispaly the tables in a universe? my company don’t allow to down load file . i want to create a jsp project to display the relaiton of bo object ,folder,user , reports and so on.
i have read the vba , and have a question ,
i don’t need StatusBar . i want open a cms universe , and the universe name is a parameter. then i will do a loop.
You need to first find the SI_PARENT_FOLDER_CUID of the unvierse, then use the following syntax:
Set Univ = DesApp.Universes.OpenFromEnterprise(unvParent, unvName, False)
where unvParent is SI_PARENT_FOLDER_CUID
unvName is universe name
Hope this helps.
Just one note with openFromEnterprise:
This will download the universe file to your local file system.
If your company policy does not allow you to download files then you will have an issue with this.
However, I don’t think there is alternative.
You can only get the table information using the Designer SDK.