Posts Categorized: Business Objects

BO XI 3.1 SP3 issue related to daylight savings time change

Posted by & filed under Administration, SDK.

There is a quite serious issue in BO XI 3.1 SP3 related to the daylight savings time change. See the SAP note 1448881 for details. After time change, BO generates thousands of failed instances for scheduled reports.  The CMS database is growing very fast. BO system becomes very slow and stops working because of lack […]

Fun with Query Builder

Posted by & filed under SDK.

I cannot explain this. SELECT SI_ID, SI_NAME, SI_CUID FROM CI_INFOOBJECTS WHERE SI_ID=23 1/1 Properties SI_NAME Root Folder SI_CUID ASHnC0S_Pw5LhKFbZ.iA_j4 SI_ID 23 SELECT SI_ID, SI_NAME, SI_CUID, SI_PARENTID, SI_PARENT_CUID FROM CI_INFOOBJECTS WHERE SI_PARENTID=23 1/10 Properties SI_NAME Report Conversion Tool SI_CUID AY9zJ8BgaF9OucZ2h2slcJM SI_PARENT_CUID ASHnC0S_Pw5LhKFbZ.iA_j4 SI_PARENTID 0 SI_ID 123 Why the hell SI_PARENTID=0 in the result if SI_PARENTID=23 is […]

Hierarchies in Webi

Posted by & filed under Web Intelligence.

The task is to display a fixed level hierarchy together with totals for each level. This can be done using breaks. The most straightforward implementation might look like this: If there are many levels and the level names are long, the table will be very wide, with a lot of empty space. It would be better […]

Calculated Default Value for a Prompt

Posted by & filed under Web Intelligence.

It is possible to specify a constant default value for a prompt. But what if the default value need to be calculated. For example, there should be an optional prompt for the statement date in the report. If the date is not specified by the user, the current date should be used. It is possible […]

Time Sheet Status – Webi Exercise

Posted by & filed under Web Intelligence.

It seems to be a good Webi exercise (for beginners). Employees submit weekly time sheets. Each time sheet has time sheet lines. Time sheet line can have one of three statuses: Submitted, Approved and Rejected. The status of the time sheet is defined by the statuses of the time sheet lines: When for a week one […]

Break on Measure in Web Intelligence

Posted by & filed under Web Intelligence.

Sometimes it makes good sense to apply break on measures. Let's build a query based on the eFashion universe that contains product Lines, product Promotion Cost, Store Name, and Sales Revenue. Promotion cost is money spent for advertising a product, it is not directly related to stores. So the report is showing the same product promotion […]

How to Change SQL in Webi Document Using Java RE SDK

Posted by & filed under SDK.

This post briefly describes how to change SQL in Webi document. The following code will work for a Webi document with one simple query (say one object, without subqueries, combined queries, etc): DocumentInstance widoc = wiRepEngine.openDocument(31223); // 31223 is ID of the webi document SQLDataProvider sdp = (SQLDataProvider)(widoc.getDataProviders().getItem(0)); SQLSelectStatement sss = (SQLSelectStatement)(sdp.getSQLContainer().getChildAt(0)); sss.setSQL("SELECT * FROM […]

Use OLE DB instead of ODBC for SQL Server

Posted by & filed under Administration.

The quickest way to set up connection to SQL Server database from BusinessObjects is to create 32 bit System ODBC data source. The most irritating drawback of this approach is that if there is an error in universe, it is not possible to see the real error message. For all kinds of errors, you will […]