How to get information from Universe about objects

[Former Member]

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.

[former_member230921]

For more info on REST SDK for universes :

https://help.sap.com/http.svc/rc/1eeee826c0154c62a5cbd29359ecbc18/4.2.5/en-US/sbo42sp5_webi_restws_d...

Page No: 163

[Former Member]

Is it possible to do something here if I'm not Java developer? :)) Is it simple to implement? 🙂

[former_member230921]

I suggest you to first try it out the APIs to make sure these APIs fulfill your requirements.

How to use the SAP BI REST APIs:

https://www.youtube.com/watch?v=d0FjJ4Jqjfs

https://www.youtube.com/watch?v=Y3d5lGsuE98

[former_member230921]

To test, use some browser plugins like Postman , Rest Client .........

[former_member230921]

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

[former_member185603]

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

[Former Member]

Could you look at:

https://wiki.scn.sap.com/wiki/display/BOBJ/Unlock+the+CMS+database+with+new+data+access+driver+for+B...

On the beggining you will find:

"With the new CMS data access driver introduced in SAP BI 4.2 SP3 (see SAP BI 4.2 SP3: What’s New In Semantic Layer) you can use a universe and native reporting clients to query the metadata of the CMS repository database.".

[former_member185603]

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.