Posts By: dmytro

Unx Documenter

Posted by & filed under Business Objects.

There is a free tool for extracting UNX universe metadata available on http://biclever.com/software/unx-universe-documenter/. It also allows comparing universes.

Calculation contexts issue with Sum, Where and If

Posted by & filed under Web Intelligence.

Make a report based on eFashion universe with [Year], [City], and [Sales revenue]. Now we will try to calculate total Sales revenue for Austin in 2004 but in two steps. Where and If Define variables as: [Sales Austin] =[Sales revenue] Where([City]="Austin") [Sales Austin 2004] =Sum(If [Year]="2004" Then [Sales Austin]) The expected value for [Sales Austin […]

BusinessObjects BI Tomcat logs

Posted by & filed under Administration.

BO BI 4 Tomcat generates some logs in the root folder such as SBOPWebapp_BIlaunchpad, SBOPWebapp_CMC, SBOPWebapp_Mobi_Server: To move the logs to another folder, add Tomcat Java option -Duser.home=C:\Program Files (x86)\SAP BusinessObjects\BO Logs

Web Intelligence RESTful Web Services SDK with Java

Posted by & filed under SDK.

In this post you will find an example of how to use Web Intelligence RESTful Web Services SDK with Java. The code displays names of the variables for each web intelligence document. To run the code, you will need json library that can be found for instance on http://mvnrepository.com/artifact/org.json/json/20160212 Example (Program.java) import org.json.JSONArray; import org.json.JSONObject; public class Program { public […]

Re-deploying BusinessObjects XI 3.1 web applications

Posted by & filed under Administration.

These steps describe the procedure for re-deploying web applications for BO XI 3.1 with Tomcat 7. Re-deploying is required, for instance, if you uninstall a language pack from Business Objects. Stop Tomcat Backup Tomcat7 folder located in Business Objects folder Remove all applications except ROOT, manager, host-manager, docs, examples (these are Tomcat applications) from Tomcat7\webapps Remove all subfolders from Tomcat7\work\Catalina\localhost Start […]

How to edit merged dimensions in BO BI 4.x

Posted by & filed under Web Intelligence.

In BO XI 3.1, to edit a merged dimension, we could right click on a merged dimension, and select "Edit merged dimension" from pop up menu, this would open a dialog for editing merged dimensions. This has changed in BI 4.x, and it might be not obvious how to adjust merged dimensions. Add dimensions to a […]

Referencing to a document's block in OpenDocument link

Posted by & filed under Web Intelligence.

When we use a OpenDocument link to open a Webi document, the report is displayed with a number of controls. http://localhost:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&sIDType=CUID&iDocID=Aan15wubifNFikJjmlT.LVU   Sometimes we want to get rid of the controls and display only specific block (for instance, when it needs to be embedded into another application). This can be done with undocumented parameter sReportPart The link will […]

Short TNS for Oracle connection

Posted by & filed under Uncategorized.

To change server name for an Oracle connection in BusinessObjects, we need to update the definition of SID in tnsnames.ora file. You can specify the server name, port and instance in the connection:

Webi – Validate value in Webi report

Posted by & filed under Uncategorized.

We want to validate values of the dimension [Job No.] from Query 1 against values of [Job No.] from query Valid within Webi report. We can create a detail object [Valid Job Name] for merged object [Job No.] that points to unmerged dimension from the query Valid [Valid].[Job Name] and use it in the following […]