Skip to Content
avatar image
Former Member

BO 4.1 Universe Metadata extraction using Java Restful Webservice


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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 09, 2014 at 07:57 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Jun 02, 2014 at 08:59 PM

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

    Please find the correct forum here:

    SCN Site Index

    - Ludek

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2015 at 01:43 PM

    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

    Add comment
    10|10000 characters needed characters exceeded