Posts Categorized: Business Objects

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

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

Join and Synchronization in Web Intelligence

Posted by & filed under Web Intelligence.

When objects are merged in a Webi document there are two possible types of the merge operation: join and synchronization. The type depends on the objects selected in a data block. To achieve expectable result, it is important to understand the difference between these operations. Let's consider examples of each operation. Join The document use […]

How to print SQL queries of Webi 4.0 document using Java

Posted by & filed under Business Objects, SDK.

The current public BO BI 4.0 SDK does not include functionality that allows to print SQL queries of a Webi 4.0 document, but this is still possible. UPDATE: BO BI 4.1 SDK contains RESTful web services for Webi. It allows you to do the below without hacks. Disclaimer: Use it on your own risk. The […]

Java code to list the objects used in a Webi 4.0 document

Posted by & filed under Business Objects, SDK.

The current public BO BI 4.0 SDK does not include any features that allows to list objects used in a Webi 4.0 document or access variables. But this is still possible. UPDATE: Please consider 4.1 RESTful Web Services SDK Developer Guides and API References http://scn.sap.com/docs/DOC-27465. It might be more convenient than hacking internal SDKs. The […]

Hack of Webi prompts

Posted by & filed under Web Intelligence.

Prompts can be used to select a value from the list of values. What about selecting a field from a list of fields? Say you have FIELD1 and FIELD2 in SOMETABLE. You want to display FIELD1 or FIELD2 depending on the user answer. You can write a long select using CASE WHEN, but that is […]

Command line InfoStore Query Builder with export to Excel

Posted by & filed under Tools.

A free command line tool that runs query against CMS database and saves the result in Excel or CSV. Options -cms: BO server. Default is localhost -username: BO user name. Default is Administrator -password: User password. Default is blank -auth: Authentification. Default is secEnterprise -query: CMS query (the same as you run in Query Builder). […]