Posts By: dmytro

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

InfoStore Query Builder to Check Relations

Posted by & filed under Tools.

There is a nice tool in CMC that allows to check relations between objects. Something similar can be done in the query builder with some non documented features. For instance, to find all reports that use a universe Finance, you can write: SELECT * FROM ci_infoobjects, ci_appobjects, ci_systemobjects WHERE PARENTS("si_name='Webi-Universe'","si_name='Finance'") PARENTS has two arguments. First […]

Problem with OpenDocument inside IFrame in Internet Explorer

Posted by & filed under Administration.

Symptoms It is not possible to login to BusinessObjects using Internet Explorer when the report is embedded into another web page using IFRAME and OpenDocument link. <iframe width=100% height=100% src="http://SERVERNAME:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&sDocName=Balance+Sheet"> You get the login screen but nothing happens when you try to login (you are staying on the same page). The OpenDocument link works when […]

Fun with NULL

Posted by & filed under Oracle.

I think this is interesting: SELECT * FROM dual WHERE (1 BETWEEN 0 AND NULL) — FALSE SELECT * FROM dual WHERE (0 BETWEEN 1 AND NULL) — FALSE SELECT * FROM dual WHERE NOT (1 BETWEEN 0 AND NULL) — FALSE SELECT * FROM dual WHERE NOT (0 BETWEEN 1 AND NULL) — TRUE […]

How to Replace a Table with a Derived Table

Posted by & filed under Tools, Universe Designer.

This post describes the detailed steps to replace a database table with a derived table. Also it describes how Universe Documenter can help to achieve the perfect quality even for such complex modification of a universe. You may need to replace a table with a derived table if your universe is affected by the self-outer […]

Problem of using self joins in combination with outer joins

Posted by & filed under Universe Designer.

Problem (It is assumed that the parameter ANSI92 of the universe is set to Yes, the parameter SELFJOINS_IN_WHERE is either not set or is set to No.) The table A is affected by the self/outer join issue if it has a self join and it is joined to a table B with the following outer […]