Posts Categorized: Business Objects

"Relationship would not be a tree after update so bailing"

Posted by & filed under Administration.

Sometimes a connection cannot be promoted by Promotion Management with the error: Resolution Status=Copied, Dependency Status=All the required dependencies are included., Commit Status=Commit attempted and failed., Promotion Status=Failure : Relationship would not be a tree after update so bailing. It may help to promote connection using BiarEngine. This can display a better message explicitly saying […]

Weird issue in Webi

Posted by & filed under Web Intelligence.

A query is based on eFashion universe and returns two objects: measure [Promotion Cost USD] and dimension [Duration]. The variable [Cost] is defined as =If [Duration]>0 Then [Promotion Cost USD]/[Duration] The following formula in report’s cell returns #MULTIVALUE =Sum([Cost]) If I just replace the variable with the expression, it will return correct value =Sum(If [Duration]>0 […]

How to Use Reposcan to Repair CMS and FRS

Posted by & filed under Administration.

This post describes the steps to repair CMS database and Filestore using SAP BusinessObjects reposcan.exe. Note that this may delete some items from CMS or Filestore if the dependencies are not found. Make sure that you have made necessary backups before applying reposcan. You can run the tool without repairing option (or with -repair off). This […]

Getting Started with BusinessObjects Semantic Layer SDK

Posted by & filed under SDK.

This post describes how to get started with a BO Semantic Layer SDK in Eclipse. It explains the steps to setup a project and provides an example of the code that imports, modifies and exports a UNX universe. You will also find instructions how to run JAR from command line. BO Client Tools and SL […]

Tool for updating non-Administrator group

Posted by & filed under Administration, SDK.

BO 4.x has a possibility to customize the user interface of Web Intelligence for specific groups of users. For instance, you may want to hide "Design Mode" interface elements for report viewers who are not supposed to edit reports. This can be done in Central Configuration Management in Groups: The problem is that the change […]

Semantic Layer SDK – check java bitness, path variable and connectivity property

Posted by & filed under SDK.

There are three things that are important when you build a program that uses Semantic Layer SDK. You need to include sl_sdk.jar to the class path. You need to use 32 bit java The system property should be set to the connection server folder"C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer" The system […]

List of all relations in BusinessObjects

Posted by & filed under Administration.

Below is the list of all relations in BusinessObjects 4.1 SP7. The relations are useful if you need to find dependent objects in Query Builder. A relations have a type and a name. Here is how to use it. The relation Webi-Universe is Parent-Child, so Webi is Parent and Universe is Child. If you want […]

HTTP Status 500 Bad tag encountered: 78

Posted by & filed under Administration.

HTTP Status 500 – com.wedgetail.idm.sso.ProtocolException: com.wedgetail.idm.spnego.server.SpnegoException: Bad tag encountered: 78 See SAP Note 1799488. Single sign on does not work by default for LaunchPad on the server machine. This behavior is by design as the servers are unable to pass Vintela filter. Use the following URL to access LaunchPad on the server: http://localhost:8080/BOE/BI/logonNoSso.jsp You […]

How to Change Banner in LaunchPad

Posted by & filed under Administration.

This is a quick and dirty solution to change the banner in LaunchPad. Do not forget to backup the files before any change. See SAP note 1659690 for a better solution. Stop Tomcat. Replace the file C:\Program Files (x86)\SAP BusinessObjects\tomcat\webapps\BOE\WEB-INF\eclipse\plugins\webpath.InfoView\web\images\SAP_logo_reg.png with desired logo (preferred dimensions: 63 x 31 px). Delete all folders under C:\Program Files […]

Refresh button text in Web Intelligence reading mode

Posted by & filed under Administration.

The Refresh button in 4.1 looks quite anonymous. It is possible to get the "Refresh" text back. You can edit file C:\Program Files (x86)\SAP BusinessObjects\tomcat\webapps\BOE\WEB-INF\eclipse\plugins\webpath.AnalyticalReporting\web\webiDHTML\viewer\language\en\scripts\UIDefinition.js and change the line ,{actionId:"refreshDPMenu", text:"} to ,{actionId:"refreshDPMenu"} The button has actually text but it is overriden with empty string. You will also need to update this file in tomcat […]