BusinessObjects Board

Repository tables in XI

server administration XI Server Discussion
#20

Hi,
Can any one tell me name of the metadata table and column name behind BO which stores the universe column name and column description.

Thanks in Advance

CTuser (BOB member since 2007-04-10)

#21

Hi,

I think you cannot find these informations.

Regards

#22

On the XI platform, the universe is stored as a binary file on the filesystem part of the repository. Other than a very few pieces of information used for managing security, little is stored in the database part of the repository. In other words, the universe details are not able to be queried.

You can use the Designer SDK to extract the information from a local copy of the universe, however. See this utility … Document a universe using Excel and the Designer SDK … for an example.

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

#23

Hello,
Is it possible to list the classes and objects of a universe? This seems like a basic request, but has been challenging for BO to do. In BO classic, this would have required a custom query against repository tables. In BOXI, we have lost this visibility. When we asked BO, they said Designer can output a hardcopy printout (no sorting, filtering, or file) or we can go buy a MetaData Manager tool. All we want is a list of classes and objects of a universe! Any information would be appreciated, thank you.

bwboxi (BOB member since 2002-09-05)

#24

Did you check out the utility Dwayne linked in the post just prior to yours?

Dave Rathbun :us: (BOB member since 2002-06-06)

#25

Wonderful! What a fantastic tool, this makes my day. Thank you.

bwboxi (BOB member since 2002-09-05)

#26

Does anyone here know of a query in Query Builder that will tell me all universes, and which connection each universe uses?

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

#27

Hi Michael,

Not sure if you can find this info using a single SQL query. Using sdk sure. But for both sdk and sql query you won’t get the info on connection overloads.

Regards
Sebastien

#28

Hi, Sebastien. I don’t need the overloads. I just need a lidt of universes, and the connections used by them. The CMC knows the connection attached to a universe, so there must be some way to query that. :roll_eyes:

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

#29

hi all

do you know which column correspond to the universe keywords ?

theres a method IUniverse.getKeyword() so I guess there’s a way to fill the IInfoObject :slight_smile:

ese-aSH :fr: (BOB member since 2007-05-22)

Sorting universes into folders; print overview
#30

Michael,

To get the universes and their associated connections, you can first query for unv:

select * from ci_appobjects
where si_kind = ‘Universe’

You’ll notice in the results there is a si_dataconnection column. This propertybag stores the si_id of the connection used by the universe.

universe connection query:

select si_name, si_id from ci_appobjects
where si_kind = ‘MetaData.DataConnection’

You can either take a pull of both 1) universes and 2) connections and link them yourself manually on the contents of the si_dataconnection field to find the lineage, or you can combine the two programatically. If you’re going to do it programatically, there’s a method available (getDataConnections() I believe) that will decode the contents for you.

I have written a utility that exposes all of the CMS metadata for reporting with an ad-hoc universe, if you are interested in hearing more.

Hope this helps.

crystal01 :us: (BOB member since 2006-08-30)

#31

Hi, I’m very interested in your utility that exposes all of the CMS metadata for reporting with an ad-hoc universe. Can you give more information on this ?

Thanks,

eocula (BOB member since 2005-04-01)

#32

Hi,
I have installed BOXIR2 for the first time and I heard that BO will create 5 tables but strange thing has happend in my installation:
I have 6 tables created:
CMS_ALIASES5 TABLE
CMS_CCFRONTIER5 TABLE
CMS_FRONTIER5 TABLE
CMS_IDNUMBERS5 TABLE
CMS_INFOOBJECTS5 TABLE
CMS_ROOTFRONTIER5 TABLE

Can someone throw some light on this.

Thanks in advance
Cheers,
Uday

udayboxi (BOB member since 2008-06-21)

#33

what is strange ? I think it is the normal new xi repository tables.

bernard timbal :fr: (BOB member since 2003-05-26)

#34

Eocula,

Since you asked, more information / free trial can be found be clicking the System Profiler BOB banner, or by going to http://www.analytics8.com/systemprofiler

crystal01 :us: (BOB member since 2006-08-30)

#35

Hello,

Going thru this thread I came to know that CI_INFOOBJECTS is one of the “hidden” tables in XI repository. Are there any more? Is there any documents/write-up that lists & talks about these tables and their usage?
Does anyone know? Please share.

Thanks,
Buddy!

Buddy :india: (BOB member since 2006-08-04)

#36

Before pointing the CMS to a new data source, I viewed the CMS table in MySQL (database wherein repository database resides) and it has 8 tables.

cms_aliases5
cms_ccfrontier5
cms_frontier5
cms_idnumber5
cms_infoobjects5
cms_relations5
cms_rfrontier5
cms_versioninfo

But when I pointed the CMS to the new data source (MS SQL Server 2005), All tables except cms_ccfrontier5, cms_frontier5 and cms_rfrontier5 were visible. What are the roles of this 3 tables in CMS database?

Xtin :philippines: (BOB member since 2009-05-20)

#37

How to query BO Metadata to fetch the following information:

Class Name
Class Description
SubClass Name
SubClass Description

Abhishek Tandon :switzerland: (BOB member since 2008-05-19)

#38

I don’t believe that information is available in XI, only 6.x and earlier.

Dave Rathbun :us: (BOB member since 2002-06-06)

#39

is there anyway to pull the list of universe and reports using specific database tables? for example, i need to find a db table “db1” from a the list of available universe and reports in Dev.

mizu_chil (BOB member since 2011-05-12)