Posts By: dmytro

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 […]

Alerters & Drilling in Webi

Posted by & filed under Web Intelligence.

It is not possible to use variables as drill object in Webi reports. Here is a clever trick how to overcome this limitation using alerters: http://deltekbpm.blogspot.dk/2013/03/be-alert-part-1-to-drill-or-not-to-drill.html The idea is to define a variable that calculates the drill level using the function DrillFilter() and then to use this variable in alerters to "overwrite" the value of […]

Removing time part of a date fails in Kettle

Posted by & filed under Kettle.

Might be an interesting info. I encountered an error running a Pentaho Data Integration transformation. After simplification I got this: Generate Row creates one row with the date field DATETIME=1981-01-01. Calculator calculates field DATE using operation "Remove time from a date". And this trivial transformation failed with a weird error: Unexpected error : java.lang.IllegalArgumentException: MINUTE […]

How to determine date pattern for a Webi document using Java RE SDK

Posted by & filed under SDK.

… // Determine preferred locale for the user Locale locale = null; try { IUserInfo userInfo; try { userInfo = enterpriseSession.getUserInfo(); } catch (SDKException e) { userInfo = null; } if (null != userInfo) { try { if (userInfo.getPreferredViewingLocale() != null) { locale = userInfo.getPreferredViewingLocale(); } } catch (SDKException.PropertyNotFound e) { locale = Locale.getDefault(); } […]

How to refresh Deski report and export it as PDF and XLS using COM SDK

Posted by & filed under SDK.

Here is an example how to open Deski report and refresh it and export as PDF using COM SDK. You will need Visual Studio 2010 Express, BusinessObjects Enterprise XI 3.1 client tools. 1) Create a Deski report (here C:\Users\dmytro\Desktop\Document1.rep) 2) Create a new Project "RunDeski" in VS 3) Add reference to the Deski COM SDK, […]

Purge or Refresh Universe Lists of Values from Command Line

Posted by & filed under Tools.

The command line tool imports a universe from CMS, refreshes or purges lists of values (LoVs) and exports the universe back to CMS. Downloads Executable for BOE XI 3.1 Source – C# VS 2010 Express solution This software is distributed AS IS with no warranty of any kind, use it on your own risk. Options […]