How to extract a list of tables which belongs to an univers ? Version SAP BO 4.1 SP11patch 6.0.0

[former_member597969]

Hi,

My version SAP BO 4.1 SP11 patch 6.0.0

I would like to know if exists a query which give a list of tables of each univers stored in database ?

Thank sou very much !

Regards,

Olivier

[denis_konovalov]

I have fixed your tags, please select more careful next time.

[former_member456023]

Hi,

This helps.

Using Rest API

Getting the Details of a Universe (Semantic Layer)

Request GET /universes/<universeID>?aggregated=<aggregated>
Where: <aggregated> is an optional, Boolean parameter that indicates if the outline must be aggregated. Default value is false.

Using Java SL SDK

You will need to code some java.

In a nutshell, you do something like this:

SlContext context =SlContext.create();

LocalResourceService service = context.getService(LocalResourceService.class);

String blxFile = service.retrieve("universe.unx","output directory");

RelationalBusinessLayer businessLayer =(RelationalBusinessLayer)service.load(blxFile);

RootFolder rootFolder  = businessLayer.getRootFolder();

Once you have a hook on the rootFolder, you can use the getChildren() method to drill into the folder structure and access the various subfolders/business objects available.

Thanks
Ashraf

[DellSC]

You can't get to that information through Query Builder because it's not stored in the CMS database. You would have to write code or find a utility that will open each universe and get this information for you.

If you're using .unv universes, there is an Excel file in the BOB's Downloads forum (http://www.forumtopics.com/busobj/viewforum.php?f=25&sid=c0276211739304bd2f9a112f090f9d96) that will pull this information for you. You will have to have Universe Designer installed and registered (at a command prompt, move to the win32_x86 folder of your BusinessObjects install and run the command designer.exe /RegServer) in order to use this.

I'm not sure whether there's anything there for .unx universes - the SDK to get that information is very different from the one for .unv universes.

-Dell