Posts Categorized: Business Objects

Weird merging issue in BO XI 3.1 SP5

Posted by & filed under Web Intelligence.

SP3 FP5.3 Create a report that contains 3 objects: Country, Year, Revenue Add table with expression =Sum(If([Year] Between ("FY2004";"FY2006"); [Revenue]; 0)) Add section by Country Everything looks nice Now add new query with only Year. Now the expression produces null result. But why??? To see the numbers again, you can either unmerge Year (which is […]

Difference between Where and If in Webi

Posted by & filed under Web Intelligence.

Two expressions =[Revenue] Where ([Country]="US") and =Sum(If [Country]="US" Then [Revenue]) might look similar. They produce the same result if Country is not used in the table: However with Country the result is slightly different The expression with Where removes Country from the context, i.e. something like =Sum(If [Country]="US" Then [Revenue]) ForAll([Country])

XI 3.1 OpenDocument URLs for copy-paste

Posted by & filed under Administration.

Here are some simple templates for OpenDocument links http://localhost:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&iDocID=00000 http://localhost:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&sIDType=CUID&iDocID=AAAAAAAAAAAAAAA http://localhost:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&sPath=[Folder],[Subfolder]&sDocName=Document http://localhost:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&sIDType=CUID&iDocID=AAAAAAAAAAAAAAA&sInstance=Last ="<a target='_blank' href='" +"../../opendoc/openDocument.jsp?sType=wid&sDocName=" + URLEncode("Document") +"&lsSPrompt:="+UserResponse("Prompt:") +"'>"+Text +"</a>"  

Infostore Page Query

Posted by & filed under SDK.

Here is some code for paged querying InfoStore (BO XI 3.1): String uri = "path://InfoObjects/**[si_kind='Webi' and si_instance=0]"; PagingQueryOptions options = new PagingQueryOptions(); IPageResult ips = infoStore.getPagingQuery(uri, options); Iterator<String> pageResultIter = ips.iterator(); while (pageResultIter.hasNext()) { String pageQuery = pageResultIter.next(); IStatelessPageInfo pageInfo = infoStore.getStatelessPageInfo(pageQuery, options); String sql = pageInfo.getPageSQL(); System.out.println(sql); IInfoObjects infoobjects = infoStore.query(sql); // do something […]

Export Webi to MHTML

Posted by & filed under SDK.

To export Webi report to MHTML, the function HTMLView.getContent(Writer,String,String) should be used. // widoc is an instance of DocumentInstance Reports reports = widoc.getReports(); HTMLView htmlView = (HTMLView) reports.getItem(0).getView(OutputFormatType.MHTML); FileWriter fw = new FileWriter("report.mhtml"); htmlView.getContent(fw,"",""); fw.close(); Make sure that libraries xpp3.jar, xpp3_min.jar, xalan.jar and xercesImpl.jar from common\4.0\java\lib\external are included in the class path.

SQL Anywhere iSQL

Posted by & filed under Administration.

Starting from BusinessObjects XI SP5, SAP Sybase SQL Anywhere is used as default database for BusinessObjects system databases (CMS and Audit). This post describes basics how to connect to the system databases using iSQL.

How to add new SQLAnywhere database

Posted by & filed under Administration.

Starting from BusinessObjects XI SP5, SAP Sybase SQL Anywhere is used as default database for BusinessObjects system databases (CMS and Audit). This post describes steps how to add a new database and provides some information about SQLAnywhere tools.

InfoStore URI queries

Posted by & filed under SDK.

There is an alternative to InfoStore sql query – it is BO URI queries. In some situations URI queries are significantly shorter and clearer. For instance, if we need to find all Webi document in folder Test, we will have to run multiple queries to get the result with SQL queries. First you need to […]

How to create a webi document using Java Report Engine SDK

Posted by & filed under SDK.

This post describes the typical workflow required to create a new Webi document in BO XI 3.1. You can download the compete code here . We will consider an example how to create a simple Webi document based on Island Resorts Marketing universe that will display resort service and revenue from that service for US. Connect to […]