Posts Categorized: Business Objects

Use of Outer Joins in Combination with Self Restricting Joins

Posted by & filed under Universe Designer.

Problem BusinessObjects use some algorithm for SQL generation based on objects selected in the query and the universe. There are a number of parameters that control SQL generation. The problem is that in some cases BO generates SQL that is not intuitively expected. What we would expect is that the self restricting joins are applied […]

Is the use of Enterprise SDKs in a thick-client/desktop application supported

Posted by & filed under SDK.

Question: BusinessObjects Enterprise XI, Crystal Reports Server XI, and Crystal Enterprise contain COM, .NET, and Java SDKs. Is the use of these SDKs in a thick-client or desktop application supported? Answer: No, the use of BusinessObjects Enterprise SDKs is not supported in a thick-client or desktop application because the BusinessObjects Enterprise SDK is only intended […]

How to retrieve Wid file for a Web Intelligence document

Posted by & filed under SDK.

public static boolean downloadWid(IInfoObject infoObject, String filename) throws SDKException { if (infoObject.getKind() != "Webi") return false; IFiles files = infoObject.getFiles(); IRemoteFile file = (IRemoteFile) files.get(0); file.download(filename); file.commit(); return true; }

BusinessObjects Enterprise XI 3.1 – Supported Platforms

Posted by & filed under Administration.

Links BusinessObjects Enterprise XI 3.1 SP3 for Windows – Supported Platforms BusinessObjects Enterprise XI 3.1 SP5 for Windows – Supported Platforms BusinessObjects Enterprise XI 3.1 SP3 for Linux – Supported Platforms BusinessObjects Enterprise XI 3.1 SP5 for Linux – Supported Platforms Search on SAP Supported Browsers BOE XI 3.1 SP3 Supported Browsers BOE XI 3.1 […]

Removing the Failed Instances Manually From the Database

Posted by & filed under Administration.

The error in BO XI 3.1 SP3 causes millions of failed instances generated (SAP note 1448881 "Multiple instances spawned after daylight savings time change"). If the problem is not solved timely, the BO is getting slow, services is starting to fail often. It is usually possible to remove the instances programmically (SAP note 1568718 "How […]

How to Upload an Excel File to CMS Programmatically Using BO Java SDK

Posted by & filed under SDK.

static public void uploadFile(IInfoStore infoStore, String filename, String title, int parentId) throws SDKException { IInfoObjects infoObjects = infoStore.newInfoObjectCollection(); IInfoObject newInfoObject = infoObjects.add(CeKind.EXCEL); newInfoObject.setTitle(title); newInfoObject.getFiles().addFile(filename); newInfoObject.setParentID(parentId); infoStore.commit(infoObjects); }

Example of Token Generation

Posted by & filed under SDK.

The following JSP page generates a token and logs on to the InfoView with the token. The following file logonAuto.jsp can be placed into the folder: [BOInstallationFolder]\Tomcat55\webapps\InfoViewApp logonAuto.jsp <%@ page language="java" contentType="text/html;charset=UTF-8"%> <%@ page import="com.crystaldecisions.sdk.exception.SDKException"%> <%@ page import="com.crystaldecisions.sdk.framework.CrystalEnterprise"%> <%@ page import="com.crystaldecisions.sdk.framework.IEnterpriseSession"%> <%@ page import="com.crystaldecisions.sdk.framework.ISessionMgr"%> <%@ page import="com.crystaldecisions.sdk.occa.security.ILogonTokenMgr"%> <% String url = "http://servername:8080"; IEnterpriseSession enterpriseSession = […]

CMS operation timed out after 9 minutes

Posted by & filed under Administration.

The error "CMS operation timed out after 9 minutes" (see below) means that the BO was not able to complete a query to a CMS database. This could be the case when the CMS database became too large (e.g. if the system is affected by the issue described on the SAP note 1448881). A workaround is […]

Undocumented parameters of BIAR Command Line Tool

Posted by & filed under Administration.

There are a number of undocumented parameters of BIAR Command Line Tool. You might find some of them interesting. Documented Parameter Default Comment yes action  null importXML/exportXML yes userName  null yes password  null yes CMS  null yes authentication  null yes includeSecurity  true yes exportBiarLocation  null yes exportDependencies  false yes importBiarLocation  null yes exportQuery yes exportQueriesTotal […]