BusinessObjects Board

query to get

security CMC
#1

Hi All,

What is the query to get universe and universe connections in the query
builder? I am on BO XI 3.1.

hena

hena (BOB member since 2010-08-17)

#2

This post should help you.

#3

It does not have the query to get connections for a universe.

hena (BOB member since 2010-08-17)

#4

You can use this to get the universe name and associated connections, however, you can only get the connection id’s, not the names. To get the names you need to use another query.

There are tools in BOB’s Downloads that will document your universes for you, might want to take a look there.

select si_name, si_dataconnection from ci_appobjects where si_kind = 'Universe' order by si_name

jwhite9 :us: (BOB member since 2006-07-28)

#5

Hi,

Thanks for the reply. Is this in XI 3.1 as I do not see it when I query ci_appobjects?

Also, what is the query to get data connection name from connection id?

hena

hena (BOB member since 2010-08-17)

#6

That query will work in 3.x, I have verified it in my environment.

What are you not seeing?

To get the connection name use this query

select si_name from ci_appobjects where si_id=<id from first query>

jwhite9 :us: (BOB member since 2006-07-28)