Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Create Webi Report from scratch using BO SDK and API?

Im trying to develop a JAVA application to create a Webi Report from scratch using BO SDK and BO Restful API. I managed to create an empty Webi Report using the API but I cannot create a report based on a universe or add data provider information to it. Since im a beginner with SAP BO and Webi reports I tried creating some simple webi report by using the API but the API can only create empty dataproviders. Unlike other webi reports that have dataproviders, I cannot define the dictionary structure like in this example or add queries for that matter:

<dataprovider>

    <id>DP0</id>

    <name>Query 1</name>

    <dataSourceId>XXX</dataSourceId>

    <dataSourceType>unx</dataSourceType>

    <updated>2015-10-28T13:32:16.000-06:00</updated>

    <duration>1</duration>

    <isPartial>false</isPartial>

    <rowCount>1</rowCount>

    <flowCount>1</flowCount>

    <dictionary>

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

            <id>DP0.DO1</id>

            <name>Created Date</name>

            <dataSourceObjectId>_VSOYIHgkEeWtif1OTxsWsd</dataSourceObjectId>

            <formulaLanguageId>[Created Date]</formulaLanguageId>

        </expression>

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

            <id>DP0.DO2</id>

            <name>First Name</name>

            <dataSourceObjectId>_VSrEEHgkEeWtif1OTxsWsd</dataSourceObjectId>

            <formulaLanguageId>[First Name]</formulaLanguageId>

        </expression>

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

            <id>DP0.DO4</id>

            <name>Name</name>

            <dataSourceObjectId>_nZicMH2dEeWPGK6C47h-TY</dataSourceObjectId>

            <formulaLanguageId>[Name]</formulaLanguageId>

        </expression>

    </dictionary>

    <query>SELECT  event.createdDate,  event.firstName,  event.name FROM  event</query>

</dataprovider>

How can I create a Webi document off a universe or create an empty webi document and add dataprovider and query information to it?

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question