How to print SQL queries of Webi 4.0 document using Java

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

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

Command line InfoStore Query Builder with export to Excel

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

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

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

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

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

Example of sub-query in Webi

The post describes an interesting example of use of subqueries in Web Intelligence. The task is to display year-to-day revenue figures. The universe database structure is the following: The universe contains the following objects: Revenue defined as SUM(INVOICE_LINE.DAYS * INVOICE_LINE.NB_GUESTS * SERVICE.PRICE) Invoice Date objects such as Invoice Date, Month, Quarter, Year. Today object defined […]