Skip to Content
avatar image
Former Member

How to get information from Universe about objects

I know that similar topics have been addressed but I do not find answer for my questions. We use SAP BO 4.2 SP3 in production. I know that "new" connector to Universe was delivered. I would like to obtain information from repository about using objects, generally about Universe metadata. Data are encrypted when I'm using SQL Management Studio and simple SQL code. Is it possible to get all information from repository directly? It was not possible in previous versions.

As I said i would like to know which objects are using in specified Universes, where some objects are stored, in which Universes etc.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 23 at 01:32 PM

    You cannot use new metadata universe which is avaible with BI 4.2. You can use some 3rd party tools like 360 (Paid), will be able to use it to extract this information

    Add comment
    10|10000 characters needed characters exceeded

    • But this universe does not provide the metadata of universe objects. Either you use the product I mentioned above or resful SDK to develop on your own to extract the universe objects as referred by Bharath.

  • Feb 23 at 01:36 PM

    There are some REST APIs which gives info about universe and objects used in it.

    This URL returns a list of universes (sorted by name) that the user making the request has access to.
    URL:
    
    [GET] http://**********/biprws/raylight/v1/universes
    
    Response type:
    
    application/xml or application/json
    
    Parameters:
    
    limit: max number of universes to return (default is 10)
    
    offset: offset from the beginning of the list (default is 0)
    
    type: type of the universes : unv/unx/all (default is all)
    
    
    This URL returns the detail of a WebI universe, referenced by its ID.
    URL:
    [GET] http://**********/biprws/raylight/v1/universes/{universeId}
    Response type:
    application/xml or application/json
    Parameters:
    universeId: a valid ID identifier of a WebI universe
    
    Add comment
    10|10000 characters needed characters exceeded

  • Feb 23 at 01:42 PM
    Add comment
    10|10000 characters needed characters exceeded