Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 19, 2018 at 08:35 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 20, 2018 at 04:24 AM

    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

    Add comment
    10|10000 characters needed characters exceeded