This post describes how to get started with 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 SDK […]
Author Archives: dmytro
How to Allow Remote TCP/IP Connections for SQL Server
SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for SQLEXPRESS > TCP/IP TCP/IP Enabled IPAll > TCP Dynamic Ports is blank IPAll > TCP Port = 1433 SQL Server Management Studio > Server Properties > Security Server authentication = SQL Server and Windows Authentication mode Services > SQL Server Browser Enable and […]
Tool for updating non-Administrator group
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
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 businessobjects.connectivity.directory should be set to the connection server folder -Dbusinessobjects.connectivity.directory="C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer" The system […]
List of all relations in BusinessObjects
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
HTTP Status 500 – com.wedgetail.idm.sso.ProtocolException: com.wedgetail.idm.spnego.server.SpnegoException: com.dstc.security.util.asn1.Asn1Exception: 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
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 […]
How to Delete Files Older Than 30 Days from Windows Command Line
forfiles -p F:\Logs -s -m *.log /D -30 /C "cmd /c del @path"
Refresh button text in Web Intelligence reading mode
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 […]
Unx Documenter
There is a free tool for extracting UNX universe metadata available on http://biclever.com/software/unx-universe-documenter/. It also allows comparing universes.