How to get the universe metadata information (class , tables...) through JSP coding ?

[Former Member]

Hi,

I am new to BO. I am developing tool which will extract the metadat information of report and universe using JSP (java ) in BO XI R2 . My problem is how to get universe metadata ? i listed the universe name by quering the CI_APPOBJECTS table. i couldn't get other information (Class and objects in the universe ).. I need the advice or idea or code to complete work... Please help to resolve my problem..

Thanks Advance

[Former Member]

hello i want to retrieve all the universe names and then all reports in each universe using REBean java sdk. Is it possible? can any1 help me...

[Former Member]

Well i retrieved all the universes list with the following query.

String queryUniverseList = "SELECT SI_ID, SI_NAME, SI_PARENTID FROM "

+ "CI_APPOBJECTS WHERE "

+ "SI_KIND=\'" + CeKind.UNIVERSE + "\' ORDER BY SI_NAME ASC";

IInfoObjects queryForUniverse = iInfoStoreService

.query(queryUniverseList);

IProperty universeNameProperty = infoOnObjectReport

.properties().getProperty("SI_NAME");

universeNames = universeNames + ","

+ universeNameProperty.getValue();

But i am still stuck in the retrieval of reports in the universes...

What about getting the list of reports...

Edited by: anusha.srs on Mar 23, 2010 6:24 AM

[Former Member]

Hi,

I guess you can get the reports in the universe by

SELECT SI_WEBI FROM CI_APPOBJECTS WHERE SI_KIND = 'Universe'

Even if the name of the attribute is SI_WEBI it appears to return all report type (i got DeskI and WebI reports).

regards,

Ralf

[Former Member]

Could you please let me know the name space for IProperty object also please let me know the data type for the below infoOnObjectReport used. Thank you

IProperty universeNameProperty = infoOnObjectReport

.properties().getProperty("SI_NAME");

universeNames = universeNames + ","

+ universeNameProperty.getValue();

[aasavaribhave]

infoOnObjectReport is InfoObject type and IProperty is in com.crystaldecisions.sdk.properties package.

[former_member203619]

As Ted mentioned, your other option is to use the Universe COM SDK. I have attached a VB6 sample that lists a lot of the properties in the Universe. If you absolutely have to use .NET - you could use COM interop to run the code - but if you do that then you need to make sure you do proper error trapping.

Shawn

[Former Member]

Shawn,

i dont see the attachement. can you attach the VB script

please

thanks

Rakesh

[Former Member]

Have you had any luck with this? I am trying to do something similiar - get the names of objects, classes and subclasses when given a Universe Name. I don't care if it is a JSP or a .NET program but my understanding is that I would still need a query (runnable in QueryBuilder) first that can fetch Universe Metadata in BOXI.

[Former Member]

There's three ways to get the Universe Class/Object info:

1. Use the Universe Designer SDK. This is COM-based, so you'd write VBScript, VBA or VB6 code.

2. Use the ReportEngine Java (REBean) API. Programmatically create a Web Intelligence document, specify the Universe as DataProvider, then get the DataSource, which holds the Classes/Objects hierarchy.

3. Use the QueryService Service in the BusinessObjects Web Service (via Java or .NET Consumer API) to do something similar to 2.

Sincerely,

Ted Ueda

[Former Member]

I tried to use the second method and I managed to fetch information about universes and the classes and objects of the universes.

But I don't find how to get information about the database tables and columns linked to the classes and objects. Is this possible in java?

[ted_ueda]

A good rule of thumb is that, if you can't access a particular bit of info in the Web Intelligence Java Report Panel, then the info isn't exposed in the REBean SDK - the panel uses REBean to implement functionality.

I'm not aware of any methods that would get you info behind the semantic layer, other than using the COM-based Universe Designer SDK.

Sincerely,

Ted Ueda

[Former Member]

Does anyone know which SDK should be used to retrieve the metadata information(objects,formula,prompt,etc) from a WEBI report. Thanks in advance.

[atul_chowdhury2]

Does anyone know which SDK should be used to retrieve the metadata information(objects,formula,prompt,etc) from a WEBI report. Thanks in advance.

REBean will provide the greatest reach for obtaining this type of information. WSSDK too, but I believe it leaves out a few things, like cell expressions and such (I think).