BusinessObjects Board

where can I see the Repository in B.O Xir2

general discussion
#1

Hi, my question where I can see the Repository of B.O Xir2 Environment as I am new to B.O xir2.

canrizt :us: (BOB member since 2008-02-05)

#2

Repository in XIR2 is split into System Datbase(CMS database) and File Store.
Go to CCM - CMS server , hit the configuration tab to see the Data Source. Same applies to FRS as well.

zack :us: (BOB member since 2007-08-02)

#3

Also, the repository is not readable at all via SQL. It’s encrypted.

Steve Krandel :us: (BOB member since 2002-06-25)

#4

… but you can query it using the query builder or the CMS sdk.

BR
Sebastien

#5

Hi,

I can’t see any query builder in my CMC ??? where is it ??

Regards.

Uik (BOB member since 2007-06-22)

#6

http://yourservername:8080/businessobjects/enterprise115/adminlaunch/launchpad.html

You’ll find it at this local url respective to your environment, under admin tools on the left

Diane1969 :uk: (BOB member since 2007-01-18)

#7

Thx Diane1969 for your reply i found the requester there !!

Do u know where i can find a description of each table in the XI repository ??

Regards.

Uik (BOB member since 2007-06-22)

#8

As Steve mentioned, the table names and descriptions will do you little or no good, the repository itself is encrypted.

What is it you are try to achieve?

SonnyWinston :uk: (BOB member since 2005-04-07)

#9

If you do a search on BOB, someone has posted a bunch of SQL scripts to query the system database for information, using Query Builder. This is one of the postings…

Now, if you need to do more than that, you have to use the SDK. There is a java_docs that provides you the APIs and interfaces. But of course, you need programming skill in order to understand all that.

Hope this helps.

substring :us: (BOB member since 2004-01-16)

#10

Hi all,

Thanks for both replies. I wanted the description of the repository to list the category and sub categories of documents and i found that in the table ci_infoobjects.

Let’s use SDK to retrieve my XI documents in a J2EE app. I wrote piece of code to retrieve root category :

public int getRootCategoriesFolderID() throws BEException
	{
		try
		{
			String query = "select SI_OBTYPE from "
					+ BEConstants.TABLE_SYSTEMOBJECTS + " where SI_PROGID='"
					+ this.getCeProgID() + "' and si_plugin_object=1";
			IInfoObjects iios = this.iStore.query(query);
			if (iios.size() > 0)
			{
				IInfoObject iio = (IInfoObject) iios.get(0);
				return ((Integer) iio.properties().getProperty("SI_OBTYPE")
						.getValue()).intValue();
			} else
			{
				throw new BEException("Caterory plugin does not exist.");
			}
		} catch (SDKException e)
		{
			throw new BEException(e);
		}

	}

Thank for the help

Uik (BOB member since 2007-06-22)