BO 4.1 Universe Metadata extraction using Java Restful Webservice

[Former Member]

Hi

We are building an application using the Restful webservice and are trying to extract the metadata from the Universe.

We are using BO4.1 SP3 pack.We are able to extract details of universe(unx),but we intend to extract tables and joins in universe.

Whether there is any URL to retrieve Tables and joins from Data Foundation Layer.

Please help.

Regards,

Kavitha S

[former_member197386 · Accepted solution]

Hello,

You can get access to universe metadata using:

<url>/raylight/v1/universes/1234

Do you have an access to the RESTful webservices documentation?

Regards,

Anthony

[Former Member · Accepted solution]

Hi Anthony,

Thanks for your reply.I have access to the RESTful webservice documentation.

I retrieved all the Universe details by using

          <slURL>/universes

By using this url, I am getting only  folder details and  not tables and joins.

Now, we are looking to extract tables and joins in universe.

We would like to know whether there is any URL to retrieve Tables and joins from universe using BI Semantic Layer Restful Web Service. We have checked the documents but could not get detailed info on it – any other documents or reference will be helpful..

Regards,

Kavitha S

[former_member197386 · Accepted solution]

Hey Kavitha,

Actually, there is no RESTful API to get this information... However, you could get this by using SL Authoring SDK (in Java).

Best regards,

Anthony

[Former Member · Accepted solution]

Hi,

I referred this link for BI Semantic Layer RESTful Web Service

http://help.sap.com/saphelpiis_sbo41wi-sdk/frameset.htm?ec558f026fdb101497906a7cb0e91070.html#

Regards,

kavitha S

[former_member197386 · Accepted solution]

Hello Kavitha,

Using this RESTful API, there is no way to get information about tables and joins.

Only the SL Authoring Java SDK should allow to get this information.

Regards,

Anthony

[Former Member · Accepted solution]

Hi Anthony, 

Thanks for your help.

I will try in SL_SDK Authoring.

Regards,

Kavitha S

[Former Member · Accepted solution]

Hi Anthony,

Can we get universe path details ,where universe is stored in cms repository?

By using this  URL

     <slURL>/universes and  <webiURL>/universes

Regards,

Kavitha S

[former_member197386 · Accepted solution]

Hi Kavitha,

since 4.S SP4 Patch 1 (and 4.1 SP5), the universe path in the CMS is also returned.

Best regards,

Anthony

[Former Member · Accepted solution]

Hi Anthony,

Thanks for your reply.

Regards,

Kavitha S

[Former Member · Accepted solution]

Hi Kavitha,

We are also trying to build a java sdk to extract universe metadata (Tables,Joins,Contexts,Derived tables,..) using SL SDK.

Can you please provide me sl sdk code to retrieve these information.

I didnt find any sample code to start with sl sdk.

Thanks,

Preethi

[daniel_paulsen · Accepted solution]

Hi Preethi,

the SL Java SDK documentation has very detailed steps on where to find and how to install the samples that ship with BOE.   The samples do cover the information you are looking for.

Dan

[Former Member]

Hi

to extract the metadata information unx, I use this source code.

Retrieves the metadata information from Webi Doc unx

I simulate a change universe, the result is an XML as shown below

BO Version  4.1.4

baseWebiURL + "/" + documentID + "/dataproviders/mappings?originDataproviderIds=" + nodeID + "&targetDatasourceId=" + destUniverseID

result example

<dataprovider>

    <id>DP0</id>

    <name>Query 1</name>

    <dataSourceId>1234</dataSourceId>

    <dataSourcePrefix>DS0</dataSourcePrefix>

    <updated>2015-01-12T15:44:25.000+02:00</updated>

    <duration>1</duration>

    <isPartial>false</isPartial>

    <rowCount>3450</rowCount>

    <flowCount>1</flowCount>

    <dictionary>

    <expression dataType="String" qualification="Dimension">

    <id>DP1.DO1</id>

    <name>Year</name>

    <description>Year</description>

    <dataSourceObjectId>AZ_YEAR</dataSourceObjectId>

    <formulaLanguageId>[YEAR]</formulaLanguageId>

   </expression>

..............

but even I have managed to extract the table and join

Regards

Emiliano

[former_member183750]

It must be retrieved using the java Semantic Layer SDK  (this is Java only and not Restful)

Please find the correct forum here:

- Ludek