BusinessObjects Board

how to find out which tables used in a universe?

sdk development
#1

Hello,

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 ?

thank you very much.

lishuanggen (BOB member since 2007-03-16)

#2

One option using the Designer SDK (COM) can be found here … Document a universe using Excel and the Designer SDK

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

#3

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.

lishuanggen (BOB member since 2007-03-16)

#4

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.

'Application.StatusBar = “Opening universe…”
Set Univ = DesApp.Universes.Open(parameter)
'Set Univ = DesApp.Universes.Open

how to set the parameter ? could you give a exsample .

  • ok, now , i got : OpenFromEnterprise

lishuanggen (BOB member since 2007-03-16)

#5

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.

Rachid

rachidb :morocco: (BOB member since 2006-07-06)

#6

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.

darcstorm :philippines: (BOB member since 2008-07-22)