Skip to Content
0

How to get information from Universe about objects

Feb 23 at 12:21 PM

45

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Jawahar Konduru Feb 23 at 01:32 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Could you look at:

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

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.".

0

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.

0
Bharath B N
Feb 23 at 01:36 PM
0

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
Share
10 |10000 characters needed characters left characters exceeded
Bharath B N
Feb 23 at 01:42 PM
0
Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0

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

0

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

0