Skip to Content
0
Former Member
Nov 02, 2015 at 11:03 PM

Create Webi Report from scratch using BO SDK and API?

102 Views

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?