Skip to Content

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


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 !



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • 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 ( 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.


    Add comment
    10|10000 characters needed characters exceeded

  • Dec 20, 2018 at 04:24 AM


    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.


    Add comment
    10|10000 characters needed characters exceeded