Where Can I Find the Sizing Companion for SAP BusinessObjects Business Intelligence 4.2?

After a three-year hiatus, the SAP BusinessObjects BI4 Sizing Guide receives some much-needed updates.

For those of you living with the previous edition of the sizing guide, last updated on February 20, 2014, you’ll be pleased to know that an update is now available.

The new version of the sizing guide is dated “June 2017” and has been updated with information about the latest release of SAP BusinessObjects BI 4.2 support pack 4. The old Xcelsius-based BI4 Resource Usage Estimator, also known as the BI4 Sizing Estimator, has been retired in favor of the standard SAP Quick Sizer. The document also includes updated sizing guidance for Web Intelligence.

For more information on sizing SAP analytics products, visit Sizing SAP Solutions at http://www.service.sap.com/sizing on the SAP Service Marketplace (S-ID required). Go to Sizing -> Sizing Guidelines -> Analytics, as shown below.

SAP Sizing Site

But you won’t find the updated SAP BusinessObjects BI4 Sizing Guide there. At least not yet. But you can find it at a new wiki, on the Sizing and Deploying SAP BusinessObjects BI 4.x Platform and Add-Ons page.

SAP Sizing Wiki for SAP BusinessObjects

This sizing document is extremely important to SAP BI professionals and we’re grateful to see it continue to receive updates. Much thanks to Sathish Rajagopal and everyone at SAP who had a hand in creating the latest iteration of the SAP BusinessObjects BI4 Sizing Guide!

SAP BusinessObjects BI 4.0 Turns 3!

After the candles are blown out, here are some things to work on during the next year.

Happy Third Birthday, SAP BusinessObjects BI 4.0! You came into the world on September 16, 2011, after a lengthy gestation. We’ve made a lot of memories together, from your birth to taking your first steps. Potty training took a bit longer than expected, but we eventually got there with your BI 4.1 release. And I’ve mostly gotten over that time you pooped in the bathtub. As the parent of three children, I’m familiar with children moving from “baby” to “toddler” to “preschooler”. Software doesn’t mature in the same way as human children. But just like with humans, some things that were expected, manageable or even “cute” in earlier years become wearisome after three years. So I’d like to mention ten things that I hope you’ll work on before your fourth birthday.

10. Group Hierarchy tree control with “too many objects”

We’re thankful that after three years, the “too many objects” error is largely solved in the BI Launch Pad (see related article, Too Many Objects in Your BI Launch Pad). I realize that BI Launch Pad users outnumber Central Management Console users. But any administrator with a large BI installation knows how tedious it is to live without a decent tree control.

Top 10 annoyances of SAP BI4

9. User search feature in CMC

There are a lot of user attributes beyond just title and description. And I’d like to search any of them, thank you. Isn’t this just a few extra lines of code?

Top 10 annoyances of SAP BI4

8. Server search feature in CMC

Although most servers are appropriately named, sometimes they just aren’t. Please make it easier to find a server by type (Adaptive Processing Server, Crystal Reports Cache Server) regardless of what somebody else decided to name it.

Top 10 annoyances of SAP BI4

7. SAP BusinessObjects Design Studio server installation

If Design Studio is the future of SAP dashboards, then please take the time to integrate the required server features directly into the BI platform. The separate (and frequently changing) server components are a huge barrier to adoption (see related articles, Please Integrate the Integrated BI Platform and Over Designing BI Architecture for Design Studio).

Top 10 annoyances of SAP BI4

6. SAP BusinessObjects Explorer administration

We’ve suffered through poor SAP BusinessObjects Explorer administration since Explorer debuted as Polestar on the XI R2 platform. As you fold Explorer functionality into Lumira, please fold its administrative tasks into the Central Management Console (see related article, Family Planning).

Top 10 annoyances of SAP BI4

5. Web Intelligence panel preference

Thankfully you provide a script, setGroupPreferences (see SAP KB 1659566 or SAP KB 1816617), but even simpler would be the ability to set the default Web Intelligence report panel via the CMC. But even better would be retiring the Java report panel in favor of a single kick-a__ HTML 5 panel. Which leads us to number 4.
Top 10 annoyances of SAP BI4

4. Web Intelligence Java Report Panel

Who can forget WebiJavaGeddon (see related article, Never Let a Serious Crisis Go to Waste)?  I’ve logged hundreds of hours in the Web Intelligence Java Report Panel. But with security and performance concerns, it’s time to move on to a plug-in free future (see related article, Is it Time for Caffeine-Free Web Intelligence).

Top 10 annoyances of SAP BI4

3. Monitoring

Monitoring was a big marquee feature of the BI 4.0 launch. It’s a great first step, but it’s time to show us a more mature second generation of this important feature. Oh, and the Adobe Flash interface needs to go (see related article, Adobe Flash- Dying but not Dead Just Yet).

Top 10 annoyances of SAP BI4

2. Promotion Management/Lifecycle Management

Everyone thought the Import Wizard was evil. Until it went away. Like monitoring, this was a marquee feature of the BI 4.0 and rightly so. Also like monitoring, it re-appeared in BI 4.1 largely unchanged.

While we’re appreciative of the many stability improvements made post-BI 4.1, it’s time for you to show us the next generation of promotion management (see related article, Do I Feel Lucky? Musings on Promotion Management). We’d also be grateful if the user interface was more consistent with the rest of the CMC and eliminated the tiny bit of Adobe Flash that it contains (see related article, Adobe Flash- Dying but not Dead Just Yet).

Top 10 annoyances of SAP BI4

1. Platform Search

There are over 80 articles in the SAP knowledge base about platform search. Most of them highlight a design flaw or document a workaround, which isn’t terribly flattering. Given that platform search is often the first feature a new user will try, it’s time to put away the duct tape and introduce the next generation of platform search to the SAP BI platform.

Top 10 annoyances of SAP BI4

Make a wish, blow out the candles, and enjoy some well-deserved cake. But I hope you’ll take these things to heart over the next year.

What are your thoughts after three years of the SAP BI4 platform?

SAP BusinessObjects BI 4.1 Build Date and Version

Where is the build date and version in BI 4.1?

In SAP BusinessObjects Business Intelligence 4.1, the build date, build number, and product version no longer appear in the Central Management Console (CMC) under Settings -> Properties as they did in prior releases. Instead, the version number can be determined from Help -> About.

SAP BI 4.1 About Box

And the build date, build number, and product version can be found under Servers > Central Management Server > Metrics.

SAP BI 4.1 Build Version
Thanks to SAP Product Support for helping me find the alternate locations.

No More Splitting Headaches From the Adaptive Job Server

Sometimes just one is enough.

Man with headache

When SAP BusinessObjects Business Intelligence 4.0 first went into general availability in 2011, SAP recommended splitting both the Adaptive Processing Server (APS) and Adaptive Job Server (AJS) into smaller pieces. However SAP KB 1868751 with the chipper title of Sporadic and Random Scheduling Failures now recommends a single Adaptive Job Server per node. The difficulty with splitting the Adaptive Job Server is that “This [configuration] will result in errors due to the additional complexity and cross communication” and also cause splitting headaches for the BI administrator.

You should have confidence in a single Adaptive Job Server because each job is forked off as a separate child process by the operating system. But having multiple Adaptive Job Servers if you really want them sounds like something that should work on paper but doesn’t in practice. The cynical part of my brain wonders if Apache Derby is responsible, as it is with BI4 monitoring.

If you currently have multiple Adaptive Job Servers per node in your business intelligence cluster, consider converting one of them to manage all services then disabling and eventually stopping the rest. Be sure to review the maximum jobs setting on each service type according to the number of CPUs per node. And verify that its destinations (BI Inbox, Email, FTP, and File System) are both enabled and configured identical to the multiple Adaptive Job Servers it replaces.

What is your experience with the Adaptive Job Server?

Customizing SAP BusinessObjects BI 4.1 and BI 4.2

SAP BI 4.1 introduces a new look and a new wrinkle to the customization process.

NOTE: The techniques described here also work with SAP BusinessObjects Business Intelligence 4.2.

SAP BusinessObjects Business Intelligence 4.1 went into general availability on August 29, 2013 (see related EV Technologies article, SAP BusinessObjects BI 4.1 Now in General Availability). In addition to combining fixes from previous releases and introducing new features and platform support, there were some minor changes in how the BI Launchpad can be customized. I’ll walk through the changes in the properties file in this article and address the CSS customization features introduced in SAP BusinessObjects BI 4.0 Support Pack 4 in a future article.

Apache Tomcat

The first thing to notice about SAP BusinessObjects Business Intelligence 4.1 is that it installs Apache Tomcat 7 as the default web application server in place of Apache Tomcat 6 (SAP BusinessObjects BI 4.2 uses Tomcat 8). For upgrades to earlier versions, the installer will leave the Apache 6 files at C:\Program Files (x86)\SAP BusinessObjects\Tomcat6 and install Apache Tomcat 7 in the adjacent C:\Program Files (x86)\SAP BusinessObjects\tomcat.

Customization Basics

Starting with BI 4.0, SAP uses properties files that can be easily changed using a text editor instead of the XML files used by XI 3.1. These files can be preserved during patch updates by following some simple steps.

The default location for properties files is the C:\Program Files (x86)\SAP BusinessObjects\tomcat\webapps\BOE\WEB-INF\config\default directory. To modify properties from their defaults, copy the desired properties file from the default directory to the adjacent custom directory, which is C:\Program Files (x86)\SAP BusinessObjects\tomcat\webapps\BOE\WEB-INF\config\custom.  To make sure your changes are preserved and not lost the next time the WAR files are deployed (typically during patch upgrades), be sure to follow SAP Note 1615492 and copy the custom files to SAP BusinessObjects Enterprise XI 4.0\warfiles\webapps\BOE\WEB-INF\config.

Customizing the BI Launchpad Login Page

The new BI 4.1 BI Launch Pad login has been streamlined in appearance from earlier versions. Long-time fans of the BusinessObjects brand will notice that the SAP BusinessObjects logo has disappeared in favor of the SAP logo (see related article, First Impressions of SAP BusinessObjects 4.1). In fact, the only mention of “BusinessObjects” is in a text string that we’re about to customize.

SAP BI Launch Pad customizationThe appearance of the login screen is controlled by the default BIlaunchpad.properties file, located at C:\Program Files (x86)\SAP Business Objects\tomcat\webapps\BOE\WEB-INF\config\default.

In addition to the existing app.name, app.name.short, and app.name.greeting properties from previous releases, BI 4.1 introduces a new property, app.custom.product.name. It’s left unspecified but currently defaults to SAP BusinessObjects, which appears on the first line of the logon screen. The app.name.short parameter is also unspecified but defaults to BI Launch pad. The app.name property is not used on the login screen but instead is used for the <TITLE> of all interior pages of the BI Launch pad.

To customize the properties file, do not modify the original but instead copy it to adjacent directory C:\Program Files (x86)\SAP Business Objects\tomcat\webapps\BOE\WEB-INF\config\custom. I’ve shown the modifications below.After restarting Apache Tomcat, I can see the result of my customizations.



Once I log in, I can see the effect of the app.name parameter.


The rest of the customizations such as system name and authentication type are identical to previous versions.

Adding or changing Favicons
If you want to dress up your users’ browser with a favicon, overwrite the standard Tomcat favicon.ico file with your own at <INSTALLDIR>/tomcat/webapps/ROOT then restart Tomcat.

There are unique icons for the BI Launchpad, Central Management Console (CMC), and Explorer.  I like to replace the BI Launchpad and Explorer favicons. I prefer to leave the CMC favicon as-is, as only a few people see it and it’s easier to find when multiple browser tabs are in use.

Place new InfoView.ico in C:Program Files (x86)\SAP BusinessObjects\tomcat\webapps\BOE\WEB-INF\eclips\plugins\webpath.InfoViewwebimages. Place new explorer.ico in C:Program Files (x86)\SAP BusinessObjects\tomcat\webapps\explorer.

Be sure to clear Tomcat cache C:\Program Files (x86)\SAP BusinessObjects\tomcat\work\Catalina\localhost before restarting.

NOTE: The favicon can now be set as part of the BI Launch Pad branding kit. See Christina Obry’s article Branding and Theming of BI launch pad for details.

Changing the Default Web Intelligence Paper Size
When SAP BusinessObjects Business Intelligence 4.1 is initially installed, the default page size is A4.  This international standard (see Wikipedia) is used nearly around the world but is not the same as the standard Letter size used in the United States and Canada.

Prior to BI 4.0, the default paper size was set in a file named defaultconfig.xml. But BI 4.x no longer uses this file to define default paper size. Instead, Web Intelligence now derives attributes like page size, header size, footer size, and margins from a Cascading Style Sheet (CSS), not the old XML configuration file. The procedure for changing the default paper size from A4 to Letter can be found on this article I wrote for the EV Technologies blog.

NOTE: Existing reports will still have the page size set when the document was saved; however, this modification will change the default page size setting for all new documents.

SAP BusinessObjects Business Intelligence 4.1 Launch Pad Default Preferences

My colleague Chris Greer has a write-up on setting default user preferences, either by user or group, which was introduced as a new feature of the SAP BI 4.0 platform.


So that explains the mechanics of customization. But how to use it practically? Use the upgrade as an opportunity to educate your customers about your brand (see related article, Business Intelligence Branding). Don’t lose sleep over retraining users that the InfoView portal has been renamed as the BI Launch pad. Or wondering if and when SAP will finally pull the plug on the BusinessObjects brand.

I’m sure I’ll have more to share about BI 4.1 as I begin working daily with the new release. And I hope to write soon about using the CSS customization features recently introduced in BI 4.0 SP4. In the meantime, Christine Obry has provided some great information on the SAP Community Network and you can find the links below.


SAP BusinessObjects and Antivirus Software

Best practices for SAP BusinessObjects and antivirus software.

Founder of antivirus software company? Or overworked SAP BusinessObjects administrator? You decide.

I’ve always had a love/hate relationship with SAP BusinessObjects installations and antivirus software. My first experiences with installing XI R2 went badly when antivirus software was still running, frequently resulting in botched WAR file deployments. And who can forget the joy of SAP BusinessObjects Enterprise XI 3.1 SP2 and its crawling installation process? Although the root cause was the Microsoft installer, SAP also advised in KB 1374386 to“disable the antivirus before starting the install so that this does not interfere with the install process”.

While most organizations rely on the big vendors like Symantec or McAfee (the latter company has a more colorful history than the former- hence the photo above), I recently had a situation with Trend Micro antivirus preventing the installation program from running properly. The installer would fail with a “failed to update cache for execution” error. The error can either be triggered by antivirus software (see SAP KB 1781641) although it can also be triggered by the Microsoft User Account Control (UAC) setting (see SAP KB 1671421).

Let’s review some best practices for working with SAP BusinessObjects and antivirus software.

Pre-installation Best Practices

During the kickoff meeting for an installation or upgrade project, determine the vendor and version of the antivirus software in use. Next, identify the person who administers the antivirus software who will assist, if necessary, during the installation process. It’s really important to identify this person, even if everyone in the kickoff meeting begins to stare uncomfortably at their shoes when you pose the question. Determine if the software can either be disabled for the duration of the installation process or if the folder location of the installation can be permanently exempted from scans. Lastly, find out if you can make the necessary changes yourself or if you’ll need to ask a system administrator. With my recent Trend Micro experience, I could see the antivirus software running in the Windows system tray but not any active exemptions. In addition, I had to ask an administrator to make the necessary exemptions from a centralized console that I did not have access to.

Installation Best Practices

Disable the services associated with the antivirus program so they are not running during the installation process. Work with your organization’s system administration team if you’re unable to figure out how to do this. It’s critical that the antivirus program doesn’t interfere with a successful installation of SAP BusinessObjects. The installation will be faster if the antivirus program isn’t analyzing it.

Post-installation Best Practices

Determine what the permanent solution for antivirus software will be after the installation of SAP BusinessObjects. Will the SAP installation folder be exempted from scans? Will specific SAP programs be exempted? Look for a permanent solution for dealing with antivirus software during the project kickoff meeting. If the exemptions are only temporary during the installation process, it is likely that they’ll become a thorn in somebody’s side when it comes time to apply a support pack or patch.

Thus Saith SAP

In many cases, it takes documentation from the vendor to successfully lobby for an exemption to corporate security policies. Here are some relevant knowledge base articles from SAP that you can reference to help your organization work toward a solution.

  • SAP KB 106267 – generic note about SAP and antivirus software, not specific to SAP BusinessObjects
  • SAP KB 1497394 – Configuring antivirus software to support SAP BusinessObjects XI 3.1 and BI 4.0
  • SAP KB 1781641 – “Failed to update cache for execution” error occurred while installing SAP BusinessObjects Business Intelligence 4.0.

Do you have horror stories of SAP BusinessObjects installations gone bad due to antivirus software? Any best practices that I haven’t mentioned? Please share your thoughts below.

Do I Feel Lucky? Musings on Promotion Management

Do you feel lucky? Well, do ya, punk?

Nothing as exhilarating as having all eyes of the project team on you as you use Promotion Management (formerly known as Lifecycle Manager) to move SAP BusinessObjects universes and reports into production at the 11th hour.

Do you feel lucky?

I know what you’re thinking. “Did he create six Web Intelligence reports or only five?” Well, to tell you the truth, in all this excitement I kind of lost track myself. But being as this is Promotion Management, the lifecycle management tool for the most powerful business intelligence suite in the world, and would blow your promotion job clean off, you’ve got to ask yourself one question: Do I feel lucky?

Well, do ya, punk?

Today when I create and run a Promotion Management job, I get nervous, say a prayer, and hope I get lucky. I’m currently helping a customer apply a patch from BI 4.0 Support Pack 5 Patch 6 to Support Pack 6. Unfortunately, Promotion Management does not correctly calculate linked universe dependencies and the core universe does not get promoted to its proper destination (refer to SAP KB 1767657 for details). The issue was corrected in Support Pack 4 Patch 4; however, that patch- and many others- was forward fit to SP6 (refer to SAP BusinessObjects maintenance schedule and forward fit plan), not to SP5.

Let’s hope that SAP BusinessObjects Business Intelligence 4.1– which was released to customers (RTC) and into ramp-up this week- brings some improvements to the promotion management process when it goes into general availability (GA), expected in late Q3 2013.

Viewing Large Web Intelligence Documents with Mobile BI

Keep the dreaded ERR_WIS_30272 error away from your mobile devices.

Are your Mobile BI users seeing a ERR_WIS_30272 error on their iPhone or iPad when viewing Web Intelligence documents?

Maximum character output size limit reached. Contact your BusinessObjects administrator. (Error: ERR_WIS_30272)

The error is triggered by large temporary XML files, particularly when Web Intelligence is working with large data sets. SAP Note 1370045 describes how to correct the error by increasing the size of the Maximum Character Stream Size of the Web Intelligence Processing Server.

Web Intelligence Stream Size 02

The default value is 5 MB (shown), but a value of 10 or even 20 MB is recommended. According to SAP Note 1826015, SAP Lumira can also benefit from a larger Maximum Character Stream Size when working with data sourced from a universe. And blogger Femke Kooij describes situations where the error can show up in Dashboards (formerly known as Xcelsius) that use Query as a Web Service (QaaWS) or BI Web Services (BIWS) (see related article, Maximum character output size limit reached).

Remember that you’ll need to adjust the settings of each Web Intelligence Processing Server in the cluster. Setting and using the service configuration template is a good way to keep these settings in sync across all Web Intelligence servers in your cluster.

Interested in tuning other Web Intelligence Processing Server settings? Matthew Shaw has an excellent article on the SAP Community Network (SCN) entitled Getting the most out of your Web Intelligence Processing Servers.

The Fun Never Ends with 64-bit Windows and ODBC

Still making fun of the Microsoft Windows ODBC panel.

The new Information Design Tool (IDT) in SAP BusinessObjects Business Intelligence 4.0, like the other client tools in the suite, is a 32-bit application. Even if the IDT is installed on a 64-bit version of Microsoft Windows, it wants to use 32-bit ODBC DSN’s created with the 32-bit ODBC panel, not 64-bit DSN’s. If you attempt to create a new universe connection and specify a 64-bit DSN name, the following error appears.

[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

To resolve the issue, make sure you’re using the 32-bit ODBC panel (see related article) at C:WindowsSysWoW64Odbcad32.exe. If you are running the client tools and server on the same platform, create a 32-bit ODBC DSN for the Information Design Tool and a 64-bit ODBC DSN for the server (BI Launchpad, Web Intelligence Processing Server, etc.). Make sure both DSN’s have identical names.

Remember that Crystal Reports 2011, Crystal Reports 2013, and Crystal Reports for Enterprise clients are also 32-bit. If they are installed on the BI4 server (which is supported, but oddly enough not recommended), they will also require 32-bit ODBC connections even though the Crystal Reports Processing Server requires 64-bit ODBC connections. Note that the legacy Crystal Reports 2011/2013 Processing Server will also require 32-bit ODBC connections.

Having fun with 64-bit Windows and ODBC?  You may find my other articles on ODBC helpful.

Going from Stock to Custom

Take your BI portal from stock to custom.

Customizing BI 4.0 is one of my most widely read articles.  Next Thursday, November 8, 2012, I’ll be presenting a free webinar entitled Going from Stock to Custom: Customizing BI 4.0.  It’s part of EV Technologies “Be a Better SAP BOBJ Admin” webinar series.  I’ll cover a variety of techniques (many that I’ve not yet written about here) that can be used to customize the SAP BusinessObjects BI Launch Pad and mobile applications like Mobile BI and Explorer into something uniquely suited for your organization.

If you can’t make the November 8 webinar, I’ll be presenting a repeat session one week later on November 15.

Visit the EV Technologies site to register for this webinar and check out the rest of the series.