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 […]
Author Archives: dmytro
BusinessObjects BI Tomcat logs
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
How to disable version check in Upgrade Management Tool
To avoid error "Version check failed. The source system or source BIAR file must be of an older version. The destination system system must be of the current version. (UMT 20012)" you can use (at own risk) the option -internal_use_only_noversioncheck
Web Intelligence RESTful Web Services SDK with Java
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
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
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
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
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
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 […]
Image with Hyperlink in Webi report
We want to add hyperlink to an image in Webi document. Here I am using an image with name UserLogo1.png that has size 165 x 25. Copy your image to the server to the folder: C:\BusinessObjects\BusinessObjects Enterprise 12.0\images Create a cell and set properties to the following. Text: <a href='http://google.com' style='width:165px; height:25px;' target='_blank'> </a> Width: 165 Height: 25 Read cell […]