1 2 3 26 Previous Next

BI Platform

388 Posts

We recently came across an issue where our scheduled jobs on BI 4.1 platform wouldn't run as expected; they would just not start. We have a clustered server setup and the job servers are running on couple of nodes. When this happens, the job server status on CMC would appear to be fine. We have raised this issue with SAP support and working on finding a resolution. In the meantime, we used the below Power Shell script as a work around to restart the job service when the schedules don't run as expected.



We scheduled a simple web intelligence report that runs every 5 mins; Using PS, we checked for the status of this report through Auditing database. When there are no entries made in the auditing database for a set threshold time, we use CCM.exe to restart the JobServer.




#Auditing database credentials
$dataSource = "Auditing Database Server"
$user = "Auditing database user"
$pwd = 'Auditing database password'
$database = "Auditng Database Name"
$threshold_mins = 10
$connectionString = "Server=$dataSource;uid=$user; pwd=$pwd;Database=$database;Integrated Security=False;"
#Win AD authentication to SQL Server
#$connectionString = "Server=$dataSource;Database=$database;Integrated Security=True;"
#Query to check the scheduled report event in auditing database
#-480 mins is to adjust for local time Western Australia Standard Time
$query = "select count(0) from ADS_EVENT where Event_Type_ID=1011 and Object_name='Webi Heart Beat v1.0' and Start_time>=dateadd(minute,-480-$threshold_mins ,getdate())"
$connection = New-Object System.Data.SqlClient.SqlConnection
$connection.ConnectionString = $connectionString
$command = $connection.CreateCommand()
$command.CommandText = $query
$result = $command.ExecuteReader()
#write-output $result.HasRows
    Write-Output $result.GetValue(0)
    if ($result.GetValue(0) -gt 0)
        Write-Output "Job Server Ok"
    //Code to send email
    send-mailmessage -to "abc@xyz.com" -from "abc@xyz.com" -subject "Job Server being restarted" -SmtpServer smtp.xyz.com.au
    //Code to restart the server
  Invoke-Expression '& "C:\Program Files\SAP BusinessObjects Enterprise XI 4.0\win64_x64\ccm.exe" -managedstop SIA_BOBJ_DEV.AdaptiveJobServer -username administrator -password ######'
    Invoke-Expression '& "C:\Program Files\SAP BusinessObjects Enterprise XI 4.0\win64_x64\ccm.exe" -managedstart SIA_BOBJ_DEV.AdaptiveJobServer -username administrator -password ######'

Large, Global SAP BI4.x new deployment

“Humans and data quality errors are inseparable” MIT Symposium

Big data and Business Intelligence

Business Intelligence software and systems created a level of automation to handle the big data revolution. That automation should remove the cognitive biases and confirmation biases humans have evolved dealing with data.

Complex BI systems are designed and implemented by humans. They have the same failings and bad cognitive attributes. A BI system can suffer the same performance problems. The larger the BI program, the greater the data flow. The more chance of performance issues due to errors in design, and implementation. A speaker at an MIT Chief Data Officer Symposium in 2013 said: “if humans are involved in the production of data, you should expect it to be imperfect.”

“Bad data is first and foremost a human phenomenon” MIT Symposium.

Build in the quality

The philosophy of quality control is not new. The aviation industry became a champion in the 1920’s. Aircraft production boomed during that decade. The high human error rate was a sobering statistic. Automation in production eliminated many quality problems. The aim was to build in the quality not inspect it in.

In 2015 Xoomworks BI produced a presentation for SAPinsider at Nice titled “A Step-by-Step Process to Design and Manage Successful SAP BI Implementations and Upgrades for Large Deployments.”(The long title itself could contain human errors.) The aim was to provide a framework to reduce the error rate in design and implementation. Build in the quality, not inspect it in. Following a multi-tiered architecture design also makes the task of troubleshooting easier.

Gartner has been hailing, analysing, and deriding BI software for several years. The analysts often report on poor performance and success rates of BI implementation. Their Magic Quadrant takes a software approach looking at the strengths and weaknesses of their leaders and followers. A useful guide but ignoring the human element in the design and implementation that could mean success or failure of any BI system. And in the final analysis, even the best software will fail when deployed if the system is not well designed.

The Correct Approach Leads To The Right Solution:


Leave questions open, don’t worry about not knowing the answers. Get information, test and prove things yourself. Don’t make decisions based on bad facts that lead to bad conclusions.

Record and share your knowledge. Do it with clear technical documents for all processes. Add who does what, where, and how and keep it updated.

Always put yourself in the customer’s shoes. One single report may have more value than any other. Test and explore all project variables and dependencies.

Be curious when looking for RCA of any issue, starting from OS issues up to app issues.

Just because things look right for the user, it doesn’t mean it is right at the back end.

Five Tier Architecture

An SAP BI4.x implementation depends on everything. Network components, OS settings, authentication, access, security. The implementation depends on all the connected data sources. The implementation on human behaviour and human failings. We have talked previously about human behaviour in the field of Change Management for users, here we look at the design and implementation.

The goal is to have an unbreakable, dynamic configuration. A configuration with the ability to change and remain error free as a BI solution.

“You purposefully need to create standardised systems, processes and methods. Otherwise, you will always have high failure rates and poor performance.” Lifetime Reliability Solutions

The design architecture for a new deployment follows five steps

Sandbox. This environment tests and explores issues within other environments. Sandbox can test new SAP BI4.x functionality, and software upgrades or patches. The test environment can also look at new integration with other software or private fix regression testing.

Development. Developers use this environment to create BI content. Development data sources will be connected. The information doesn’t have to be valid, just be structured as Production data source.

Acceptance. This environment is used to validate the configuration of a build. A comparison is made with connected Acceptance databases before sending the content to the next step, Quality. Data sources will contain an old copy of Production data to allow validation of formatting. That will also allow validation of calculation results and single report performances.

Quality. This environment validates via an internal BI Centre of Excellence (COE). It looks at the quality of the BI content generated. Performance tests need to be carried out in a real-life scenario. Validating production data volumes, testing concurrent usage, scheduling and publication under a worst-case scenario.

Production. This environment is used for the final reporting, consumption, and job processing for the connected Production data sources.

Understanding the full capabilities of SAP BI4.x and the features is a necessity. With that knowledge, the best solution can be found for the requirements of the business. Building relationships with the people who will be involved in design and implementation is another necessity. Understanding their positions and clearly defining their roles and responsibilities.

Post Design

The strategy is to define and run a proof of concept to prove the business requirements are met. This phase will bring out technical issues. Troubleshoot, fix, and document all the issues using a similarly rigorous and defined approach as for the design. There will be configuration after the installation, for success it is important not to take short cuts. Security configuration is vital, how you assign groups and custom access levels.

Existing deployments

A business intelligence system is an existing deployment once it has started running, and it can be monitored as such. SAP BI4.x growth and usage are dynamic. The situation can change daily depending on the type and level of controls which are implemented. There will be ongoing maintenance and software upgrades to undertake.

An example

The problem wasn’t with the processor speed but the channel throughput specification for that CPU in production. The CPU with a higher frequency had 100MHz Front-Side Bus, whereas the CPU model used on the test system had a 400MHz FSB.

Intel and AMD noticed the speed problem many years ago for simple calculations on a large data set. The FSB couldn’t keep up with the CPU. Whereas with complex calculations, the greater time spent in the CPU meant the FSB could keep up. The human error in this example was a failure to have detailed information on the chosen hardware.

Errors do not have to end in failure

It is important not to design an over-complex BI system architecture. An architecture proposal may look good on paper. If a system has installed components surplus to the business requirement, redundant issues may be raised during a proof of concept phase. The redundancy may be enough to jeopardise a new project.

Human design and involvement will produce errors using any approach to design and deployment. If the correct procedures are followed fixing them becomes part of that procedure. Errors do not have to end in failure.

A step by-step process to design and manage a successful sap bi implementation or upgrade for large deployments v2 from Xoomworks Business Intelligence

Learn More:

Big Data’s Human Error Problem, Information Week, 10/2013

2013 MIT CDOIQ Symposium, 2013

The hidden truths in human error rate tables, Lifetime Reliability Solutions

Frontside BUS, Technopedia

IBM Security Services 2014 Cyber Security Intelligence Index, IBM Security, 2014

The Frontside Bus Bottleneck, Technewsworld, 09/2013

Xoomworks BI


Since upgrading to BI 4.2 and Tomcat 8 we observed in Analysis Office (Version 2.2) a Single Sign On problem when would like to connect to BI platform via Windows AD and Kerberos (Vintela). In prior versions SSO worked without any problems.


The error message was the following (error occurs only when opening a workbook via Analysis Office; opening a workbook directly from BI launchpad works as usual):

Logon to BIP-server failed. The server did not provide a meaningful reply; this might be caused by a contract mismatch, a premature session shutdown or an internal server error.


To solve this problem you have to add the following command line parameter in the JAVA Options within the tomcat configuration.






On Apache Tomcat 8 Configuration Reference you can find addtional information about this parameter.



SAP BO BI 4 Security – Quick & dirty security: the short-cut can become the longest cut

“Your security model is a living breathing entity.” Xoomworks BI 2015

“Oil and Gas organisations must move beyond operating strategies based on myths and confusion about SAP security.” CEO Onapsis, Gartner Security & Risk Management Summit 2015.

“Research findings show the vast majority of SAP systems evaluated contained critical vulnerabilities that exposed them to espionage, sabotage, and fraud.” Onapsis research labs.

“The criticality of the threat to infrastructure was recognised by the FBI.”  Nasdaq

“We found one of the biggest problems was shortcuts being taken.” Xoomworks BI 2015

Onapsis were Silver Sponsors at 2015 Gartner Security & Risk Management Summit. They revealed some salutary research. They identified common threats to SAP BI systems. They are the threats to business-critical data.

In the oil and gas industry threats came from:

  • Competitors.
  • Disgruntled employees.
  • Foreign states.
  • Hacktivists.

They identified four common approaches:

  • Customer information.
  • Credit card breaches.
  • Customer and supplier portals.
  • Database warehousing.

Breaches in security could be accidental. For example, 30,000 users receiving 16 reports due to a stray “view” permission, causing a production outage, and causing a data breach.

Breaches in security could be corruption. A recent high-profile security breach; U.S. Secretary of State Hillary Rodham Clinton is an example of bad practice. She wilfully strayed outside the parameters of accepted behaviour with no adequate monitoring. In Clinton’s case, she physically extracted material with a high-security rating and placed them on a personal server. The leaks were traced from emails. The FBI’s current investigation into Mrs. Clinton involves over 100 agents.

Business Intelligence tools have many functions. They organise, extract and analyse data. The data resides in complex systems. Security (or the strong right arm of BI) reflects that complexity. We often deal with security in SAP Business Objects. When we break down the function or the output we require from security and adapt to how it is designed, organisations and users simplify their task.

Complex processes have always needed a way to be drawn. Frank Gilbreth the process analyst of the 20th Century created a flow-process chart. He broke down complex tasks into individual parts. The parts to be examined and improved. Computer programmers of the 1970’s borrowed the idea. They used the IPO (Input-Process-Output) chart. The commonality was starting with the Output. Then designing the system to deliver it. No different to security in a complex Business Intelligence system. Start with the desired result and design a flexible system to deliver it. A system that grows with an organisation.

Follow some simple rules, I would go so far as to say axioms. Doing so reduces the chance of something going wrong. BI deals with massive amounts of data. Security must secure the data and control the access to it. The access will mean the data is available only to the right person, at the right time, for the chosen purpose.

In 2015, Xoomworks BI gave a presentation on SAP BusinessObjects Security: Authentication, Security Token Service Problems, Pitfalls, Tips & Tricks. It was one of numerous “how to”, “help me please” presentations by experts. These include the definitive guides produced by SAP. Here we are extracting a few of the general principles.

AT Xoomworks BI, we found one of the biggest problems was shortcuts being taken. Rather than following a security structure and keeping to the good path. Complexity is part of the story with security; it impacts performance as the structure grows and stays flexible.


As far back as 2011 SAP was publishing 65 security notes per month. That is Microsoft and Oracle level. Demonstrating how seriously they considered security. SAP BusinessObjects security is now an Object based system, not user-centric. Everything in BO is an object. That means everything to which security can be applied. Not just data, users are also nothing but objects. Permissions are granted to these objects. They can be folders, groups, servers, and more.

Users will reside within a group. That group resides in your user and group structure. SAP BO has predefined access rights and the ability to assign granular rights. Predefined access levels: No Access, View, Schedule, View On Demand, Full Control. No Access is not a denial; it sets permission to “Not Specified” which can be overridden. Full control means a user can modify an object up to its deletion. The others lie in between.

Never assign granular rights to content. That is the easiest way for information to go to the wrong people. Keep to groups, and give them Custom Access Levels (CAL). If you have a user with a specialised security requirement, set up a group for them. Then assign security for the group. You can add people to the group when you need. They’re in that group so they can have the group permissions.


Content Groups: Grants rights to folders. The folders contain the content. For example, the marketing group will have access to the marketing folders.

Application Groups: Grants rights to applications. For example, the members of marketing will have permission to create documents in the marketing group.

Split groups in to two defined sections. This is a step towards simplifying your security model. Every user becomes a member of a content group, and an application group. As required they become members of other groups. If a user leaves a group, he loses permissions for that group. The replacement user adopts the permissions when they enter the group. Permissions never rest with the user, but with the group. Documents follow the same pattern. Permissions never rest with a document. Folders are created with appropriate security and the documents live within that.

Custom Access Levels

“We can say that securing SAP Business Objects properly is not possible if custom access levels are not used.” GB & Smith. They go on to say “Complexity arises from the fact that a custom access level is applied to a resource. Calculating the impact, it could have on sub-resources, sub-groups, and users is thus required.” CAL’s are apart from the pre-defined access levels in BO security.

Building CAL’s is sequential and cumulative for any object

Each access level builds on the rights granted by the previous level. Administrators can set frequently needed or common security levels uniformly. A better and safer option than setting individual rights or trawling through the 1,000 granular rights.

Tip: Assign each right in only one CAL. Build up a user type’s permission by assigning multiple CAL’s. If Info Consumer is your lowest level, an info worker will have both info Consumer and info Worker CAL’s assigned to them.

For example, two groups, procurement managers, and procurement employees. As two groups they require access to 20 documents. The documents are in the BO enterprise system. But the managers require more rights than the employees. Rights not covered by the pre-defined levels. Don’t add groups to 20 documents. That would require modifying their rights in 20 places.

Rather two new custom access levels can be created. Call them Procurement Managers and Procurement Employees. Both groups are added as principles to the documents. Their rights can be modified when needed. The access levels apply to both groups across the 20 documents.

Application and Content CAL’s

While it is possible to create a single CAL which covers both Application and Content permissions, it is better to ensure the CALs satisfy a single purpose.

Create separate CALs for Application (e.g., WebI, CMC, Crystal Reports) and Content (e.g., reports, universes, connections.)

CALs should be broken down into the various functional areas as well as being modular.

Info Worker should have all previous access levels as well as the CALs named after their user types.

Security Token Service – Brokered Authentication

Security Token Service (STS) is not a new concept. Brokered authentication has been used to grant access to applications and web services for many years. STS was introduced in SAP BO BI 4.0. It is a one-way trust; BW systems trust BI4, but it does not trust the BW systems. A neat idea to place an intermediary.

In a multi BW system, a user logs in with one method and can still use another method’s functionality. So sign on with a single sign-on (SSO) to one BW, and connect to another with the same SSO as the credentials are brokered. In a complex environment, an STS can streamline authentication. In fact, the more complex, the more STS helps.

The STS can replace a Secure Network Configuration (SNC) setup between BI 4 and a BW. The SNC will only be used for legacy workflows; new workflows will use the STS. You can see detailed setup guides on our slide presentation, and on the links within that document.

The last but not final words

Keeping on top of your requirements is vital. Adjust the security model as and when required. Never assume that shortcuts are not being taken.

It is a fact that the more complex security and authentication are, the greater the impact on performance. Security Token Services and aliasing users can make your security solution simpler.

Make your security model as flexible as possible.

Finally, If you intend to run for the U.S. Presidency, treat your data security with some respect.

For further reading:

Discussing the complex challenges of SAP Security, MWR Info Security, August, 2013

SAP BusinessObjects Security: Authentication, Security Token Service Problems, Pitfalls, Tips & Tricks, XWBI, 2015

The Gilbreth Network, Frank and Lillian Gilbreth brief biographical information.

SAP BusinessObjects Security: implementation, issues and challenges, GB & Smith, November 2015, Drouvin

Brokered Authentication: Security Token Service (STS), Microsoft Patterns & Practices, December 2005

Onapsis announces Oil and Gas Companies at Risk from SAP Vulnerabilities, Nasdaq Globe Newswire, June 2015

From Gartner Security & Risk Managament Summit 2015, SAP Vulnerabilities, June, 2015

State Department Confirms FBI Investigation, Washington Times, February 2016.

Trip Report, Gartner Security & Risk Management Summit 2015, Gartner June 2015

For any questions: drop us a line

It is a fact; many SME’s continue to postpone their BusinessObjects upgrades despite the platform being unsupported.

Many old BusinessObjects customers continue to use BO 6.5 or BOXlr2, again despite the fact prices for SME’s have dropped enormously. We looked into the phenomenon to gain an understanding of it. We wanted to lay down the facts, deliver some home truths, and give SME’s a reality check to dispel the common myths.

There is a perception amongst some SME’s that BusinessObjects, now carrying the SAP label, and described as Enterprise Software, is expensive, and the future unpredictable. Fears exist over how SAP’s investment in BusinessObjects and its development will progress. The fact is BusinessObjects is still here years after the acquisition by SAP, and SAP BusinessObjects Edge is priced for SME’s to offer a fully functioning BI suite of tools, added to which Edge connects to anything not just SAP BW or HANA.

The value of the acquisition of BusinessObjects was over $6.5 billion, at the time SAP CEO Henning Kagermann stated the driver was growing new business. That business was the increasing demand for BI capabilities within the software. Almost a structural change for SAP that is unlikely to be reversed. Analysts at the time saw the future of business applications to be the ability to use them in a more intelligent fashion, a fact in today’s analytical business environment. An IDC analyst put it well at the time “You’ll do your analysis from the BI interface and then dive directly into the transactional data you want to examine.” Those capabilities are increasing and improving, as is the accessibility of BI to SME’s.

It is a false economy to assume the cheaper alternative is to rebuild a BI system using new tools as opposed to renewing. Long term SAP is no more expensive than Tableau or Qlik, and Edge priced as it is can be the first option on the list.

The myths, we discovered five common misconceptions held by SME’s blocking their BusinessObjects upgrades.

  • Software cost
  • Project cost
  • Lack of skills
  • Training impact
  • Looking into other tools

Software Costs

The terms SAP and Enterprise Software do not mean the software will be out of the reach of an SME, nor that a project will be overly complex and take five years to implement. SAP invested in many small companies. For example SAP BI (BusinessObjects), Data Services, and Sybase IQ. All acquisitions, and all with SME versions that easily undercut the cost of the enterprise versions. A complete toolset means building dashboards, producing reports, sharing them via the portal and email, creating a self-service BI approach and an enterprise level security integration.As an example, the pricing below is based on the current standard cost of Edge. Varying discounts are more than likely available based on how many users are required.The fear of SMEs to upgrade from BusinessObjects to SAP
As with any product with a lifecycle, at some stage, the market must be segmented, and the growth and penetration for each assessed and quantified. The old approach was often discriminatory pricing between the segments leading to an uneven value proposition. The modern approach is to offer the high value to all levels of business with appropriate functionality for the pricing. SME’s are a growth segment, and products are designed and priced to offer the highest value. Howard Dresner considered a thought leader in BI put it well “larger enterprises continue to generate the big deals, but they are far fewer in number than SME deals. SME is a growth segment for vendors.”

Project costs

  • The truth of the extent of project cost depends on the complexity of your data and reporting requirements.
  • The installation can be done on premise, on virtual servers or a cloud server.
  • Building the data layer can be very quick with a current DB schema that explains the joins between your tables, or consulting someone that has the knowledge.
  • Creating a report in WebIntelligence is very quick, and easy to use, with a little training business users can take a self-service approach.

SME’s have an agility advantage in coordinating a project; the decision-making tree is shorter than at enterprise level. An assessment of an SME’s data environment will take less time, executives are closer to the data and identify how they wish to utilise their data for best competitive advantage. Factors that keep project costs lower for SME’s than larger businesses that may suffer from bureaucracy.

Lack of skills

There are numerous options to cover this myth. Xoomworks BI itself, as a niche specialised consultancy offers help. The budgets aren’t in the same league as the big players, plus having a near shore office we reduce the overall cost, maintaining the quality of our work.Gartner as early as 2005 identified lack of user skills and knowledge of best practice to be the greatest barrier to deploying business intelligence software. The fact is the democratisation of Business Intelligence within organisations is increasing, due to demand. That demand has led to BI being accessible to all levels of users. Business Intelligence tools must cater to the requirements of business users. The tools are moving towards analysis from reporting, the business use and discovery are succeeding the delivery of information. Business users now require the ability to the full functionality of the analytical tools without having an expert level of data science or high-level IT skills.

Training impact

Taking WebIntelligence as an example, it has improved, the look and feel changed, but it is essentially the same tool. The need for training can be dependent on the version currently being used. The important factor is that training is always available, hands-on and tailored, one to one or groups, and it can be specific to the user levels and their requirements.

The millennial generation seems to be grasping training and its benefits. Recurrent and continued training is essential to the success of a BI project and system, it freshens the skill set and, more importantly, keeps the level of trust in the BI and data high. An analyst at a recent BI conferencepointed out “A lack of understanding about technology can breed distrust. And good communications between all involved can reduce misunderstanding up front.” She went on to say with great prescience in my opinion “everybody is a data generator and consumer. Computing and analysis are no longer synonymous with IT; they are a common way of life for everyone. Millennials change the way data is reported and consumed; a generational shift is changing the importance of training.”

Looking into other tools

I always find this an interesting topic to discuss. I take the approach of going back to the actual requirements. What do you need the tool to deliver. And a complete suite of tools will always offer an advantage regarding economy, utility, and ease of use. Looking at BusinessObjects, it is the complete tool integrating a variety of functions and options. The smaller niche tools tend to do one thing very well but are lacking in overall capabilities, such as security or a self-service approach.

Consider the cost of rebuilding everything, training every employee on a new tool. Then consider the long-term viability of a new tool, will it cater to future requirements, and be scalable. Edge is fully compatible with the Enterprise version of SAP BusinessObjects when an organisation reaches the threshold above SME they can upgrade to the Enterprise version. It is an easy migration for the BI content, the users, groups, reports, dashboards.

Consider the change management implications to an organisation of starting again with a new BI system. Changing the behaviour of the users until they feel comfortable to use and exploit any BI system is vital to the system returning a productive use. Removing that comfort zone takes an organisation back to the level of beginning the change management process. Change management requires the alteration of individual behaviour and as our recent Xoomworks BI State of Business Intelligence Survey showed, cooperation between departments, CIO’s, CFO’s, for the self-service paradigm to be accepted and work. Power users and leaders tend to dictate on a departmental basis their requirements for reporting. Consistent reporting is necessary throughout a business at all levels, an upgrade maintaining the underlying platform keeps that consistency.

In reality, the cost argument, or myth, needs to be removed from the decision to upgrade, the facts don’t support it for SME’s that by their nature and size demand cost-effective solutions. The industry is filling that demand with products that reflect the growth for BI in the SME sector.If you add data governance and security to the equation of upgrade versus rebuilding a BI system with new tools, the upgrade case becomes more powerful. Maintaining a platform, upgrading, keeps existing data governance and reduces the chance of lost or corrupted data. As our BI survey showed, everyone is aware of the importance of data governance, but few feel they are in control of it.

Taking SAP BusinessObjects Edge as an example of a product designed for SME’s it will have a different license structure to the enterprise version, both being licensed based systems. For instance:

  • Single-server installation (no clustering)
  • Edge has a maximum of 50 concurrent licenses. Working by a 10% concurrency this technically allows 500 users to use the platform but only 50 concurrently.
  • Edge has a maximum of 250 named user licenses.


I view that aspect as being in line with the size and structure of an SME; the functionality will offer the same high level as an enterprise version.

I got real problems with performance in BI Launch Pad. For instance, my reports were opening very long time, navigation in BI Launch Pad was awful.

1. Let's modify the Tomcat setting, because by default they have low value.
o JavaHeapSize (-Xmx) from 2G to 4G
o MaxThreads from default (200) to 900
1.1 JavaHeapSize we should modify:
cd <bo inst folder>/sap_bobj/tomcat/bin
modify setenv.sh

# set the JAVA_OPTS for tomcat

JAVA_OPTS="-d64 -Dbobj.enterprise.home=${BOBJEDIR}enterprise_xi40 -Djava.awt.headless=true -Djava.net.preferIPv4Stack=false -Xmx4g -XX:MaxPermSize=384m -XX:+HeapDumpOnOutOfMemoryError -Xloggc:<bo_inst_folder>/sap_bobj/tomcat/logs/tomcat.gc.log -XX:+PrintGCDetails -XX:+UseParallelOldGC"

1.2 MaxThreads we would modify:
cd <bo_inst_folder>/sap_bobj/tomcat/conf modify

Define a non-SSL HTTP/1.1 Connector on port 8080

<Connector port="8080" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="8443" maxThreads="900" URIEncoding="UTF-8"/>
  <!-- A "Connector" using the shared thread pool-->
    <Connector executor="tomcatThreadPool"
               port="8080" protocol="HTTP/1.1"
               redirectPort="8443" />




2. Cleaning of old installed patches and service packs from BO. What does it mean?
Just go to <bo inst folder> and run ./modifyOrRemoveProducts.sh (for Linux):
It is clear that i have many various installation on my server. But it is important to delete old installation!


3. Cleaning of logging directory, in <bo inst folder>/sap_bobj/logging
o Deleting Trace-Files
o Deleting Logs old than 30 days
4. Tuning APS, for start you can use CMC Wizard.
5. APS properties for tracing set to unspecified (-> means bo_trace.ini are used)


Level - Description
Unspecified - Force the use of BO_trace.ini to be used
None - Only critical events such as failures will be logged
Low - Ignores warning and status messages
Medium - Only Status messages with least important will be ignored
High - Includes all the logging messages


6. Disabling of unused services in the CMC, for instance, Crystal, Analyses services.


7. Reorganisation of database statistics of BO-Repository and BO-Auditing.


This one is high important point. As you know, every database has to manage its statistics according to number of rows. And if you do not collect stat, than you performance as well as refresh rate are decreasing.

SAP Design Studio apps, Crystal Reports, Webi reports etc. can now be integrated with the SAP Fiori Launchpad. In this blog we’ll look at how these reports/dashboards from the SAP BusinessObjects BI platform can be integrated with SAP Fiori landscape.


Before you jump on the how-to section, i recommend watching this demo video which shows how the reports/dashboards look in SAP Fiori launchpad.



Ok, I hope you watched the demo, now we’ll look at the how-to part.

The following walks you through the steps to integrate a SAP Design Studio application with SAP Fiori, however you can follow the same steps to integrate any report or dashboard with SAP Fiori.


Step 1: Generate the OpenDoc URL from the SAP BI Launchpad

  • Login to the SAP BI Launchpad and right click on the report or SAP Design Studio app that you want to make it available in SAP Fiori Launchpad, and select Document Link


  • Copy the link to a notepad.


Step 2: Create New Launchpad

  • Login to SAP Fiori front-end server, and run transaction code LPD_CUST
  • Click New Launchpad, and enter the details as shown in the below figure.
  • Click continue


  • Next, create an application by clicking New Application
  • Enter the details as shown in the figure

Link Text: Liquidity Forecast

Application type: URL

Paste the URL which we copied in Step 1 in Additional Parameters

Application Alias: LiquidityForecastApp


Step 3: Create Semantic Object

            In SAP GUI, run transaction code /UI2/SEMOBJ, and add a new semantic object as shown in the figure below.



Step 4:  Create a new Catalog

  • Login to SAP Fiori Launchpad Designer from your browser.


  • Create a new catalog by clicking FIBI5.png
  • Select Standard, and then enter the below details.
  • Click Save


Step 5: Create a New tile and the Target Mapping

  • Add a new tile in the Catalog by clicking FIBI7.png
  • Enter the General and Navigation details as shown below


  • Click Save
  • Now click FIBI9.png to add a target mapping. Enter the following details:



Step 6: Create a New Group

  • Select the Groups tab in the SAP Fiori Launchpad Designer.
  • Create a new group by clicking FIBI5.png
  • Enter the below details and click Save



Step 7: Create New Role for the Catalog and Group

  • In the SAP front-end system, run transaction code PFCG
  • Enter a role name and click Single Role
  • In the role menu add the Catalog and Group which we created in the previous steps.


  • Click Save
  • Select the User tab and enter the user ID/ID’s who needs access to this SAP BI Catalog.


  • Click Save


Login to SAP Fiori Launchpad and you should now see the tile, catalog, and the group. Please watch the complete demo here.  

Happy Learning!


-Anil Bavaraju

SAP Press Author - SAP Fiori Implementation and Development


This article is a continuation of: New complete tutorial for setting up Introscope 9.5 Stand-alone Monitoring for SAP BI Platform 4.x (Part 1)



Step 4:  Configure each BI node and Application Server node using ACTool


ACTool is a free program which automates the BI / Tomcat server configurations for Introscope Monitoring.  In this step, we will configure our BI / Tomcat node using the ACTool program.  For detailed information about ACTool, refer to the ACTool User Guide.pdf under the docs directory of the ACTool download.

  1. Browse to SAP Note 2137275 and click on link provided in the Solution section under Get the tool:


  2. Download the zip file sap_actool-2.24.0-bin.zip and copy it to a temporary directory on your BI / Tomcat servers (in this example, C:\actool)

  3. Extract the contents of sap_actool-2.24.0-bin.zip to your temporary directory.
  4. Browse into the <actool>\conf directory.  Delete the file products.xml and rename the file products_bolight.xml to products.xml (we are replacing the original products.xml).  Then, edit the file boe.properties with a text editor
  5. Enter values for the following properties then save the changes to boe.properties:
    Property NameExample ValueDescription
    boe.systemmycmsnameThis is your CMS server name that you used to logon to the CMS (don't use the @clustername)
    boe.useradministratorThis is your CMS administrator user account
    boe.passwordPassword123The CMS administrator password
    boe.cmc.introscope.hostwiemhostnameThis is the hostname of your Introscope Enterprise Manager
    boe.cmc.introscope.port6001This is the port number of your Introscope Enterprise Manager
    tomcat.service.nameBOEXI40TomcatThis is the service name of the Apache Tomcat server on this host
    tomcat.service.port8080This is the http port number of the Apache Tomcat server
    wily.EM.hostwiemhostnameThis is the hostname of your Introscope Enterprise Manager (same as boe.cmc.introscope.host)
    wily.EM.port6001This is the port number of your Introscope Enterprise Manager (same as boe.cmc.introscope.port)
    smdagent.pathC:\usr\sap\DAA\SMDA98This is the path where you installed the Diagnostic Agent (up to the SMDAxx folder).  In this example, I installed the Diagnostic Agent to the C:\ drive using system DAA and instance 98

  6. In the folder where you extracted ACTool, double click run_actool.bat.  Type 2 and enter to choose the option SAP BI PLATFORM 4.x then type 1 and press enter for the option to Execute.
  7. Next, press enter to start all the configurations or refer to the selective options below:


    - If this host does not have Apache Tomcat, you can enter 2,3,4,8,9,19 to skip the Apache Tomcat setup

    - If this host does not have BI components but only Apache Tomcat, enter options 4,12,14,15 to only setup Apache Tomcat and SAP Host Agent (or if you didn't install the Diagnostic Agent choose options 12,14,15)


  8. When the script is completed, you can close it by typing 'quit' and press enter.  Step 19 may report a failure, this indicates that the SMD Agent must be restarted manually.  Restart the services, SAPDAA_98, and SAPHostControl

  9. Finally, restart the SIA and Apache Tomcat on this server.

Step 5:  Validate the installation/configuration is working


  1. First, logon to your BI Launchpad and refresh some Webi / Crystal / Dashboard documents to generate metrics.
  2. Next, open the Introscope WebView in a web browser (for example http://wiemhostname:8081/webview )
  3. Enter the default logon information (user: Admin password: Admin89)


  4. Click on Investigator, then expand *SuperDomain* and expand the hostname you just configured.

  5. Confim that this host has the SAP HostAgent Process, SBOP ENTERPRISE\HOST, and Tomcat nodes under the host name.

    If there is no Tomcat instance on this node, then only check for SAP HostAgent Process and SBOP ENTERPRISE/HOST
    If there is no SIA on this node then only check for SAP HostAgent Process and Tomcat or if you didn't install the Diagnostic Agent, only check for Tomcat

  6. Next, in the WebView, click on the Console tab, and confirm that metrics appear under dashboards Apache Tomcat Memory, BOE 4.0 PLATFORM, and BOE 4.0 WEBI SERVER DETAIL





Previously, I posted on the SCN an article on how to setup Introscope Monitoring for the BI Platform.  This article is a replacement to the previous article posted here: A complete guide to setup CA APM Introscope 9 for monitoring SAP BI Platform 4.1 on Windows [PART 1/2]


Due to changes in the new SAP Solution Manager Diagnostic Agent 7.4, there has been a period of time where it was not possible to setup Introscope monitoring for the BI Platform unless you had the full SAP Solution Manager stack in your environment.  After some research, testing, and working with various teams here at SAP, I'm happy to announce that you can once again setup Introscope monitoring for your BI landscape.


This article is applicable to those SAP BusinessObjects customers who:


  • Do not have an SAP Solution Manager system
  • Do not have an SAP Basis team or ABAP / Netweaver experience
  • Would prefer to only implement Introscope Monitoring tools without the full SAP Solution Manager stack



BEFORE YOU START:  Please be aware, this article is for setting up CA APM Introscope in stand-alone mode aka BOLight (without Solution Manager).  If your goal is to setup Solution Manager for BI, please check the following SAP Notes for instructions:



Here is the workflow we will follow:


  • Step 1:  Download the installation media from the Software Download Centre
  • Step 2:  Install the Introscope Enterprise Manager
  • Step 3:  Install the Diagnostic Agent on each BI node and application server node
  • Step 4:  Configure each BI node and application server node using AC Tool
  • Step 5:  Validate the installation/configuration is working



Step 1:  Download the installation media from the Software Download Centre


First, we need to download each piece of software from the Service Marketplace.  The files required for this configuration are part of the SAP Solution Manager files on the Software Download Center.   If your company has a Standard or Enterprise Support contract, you should have usage rights and access to download SAP Solution Manager software. If you find that your S-USER does not have access to download one of these files, open a message under component XX-SER-SWFL and request access to download the file.  If you are installing to an operating system other than Windows x64 or if you are having trouble finding the files by browsing, then use the search option to search for the file names under Support Packages and Patches and locate the version appropriate for your platform.  In the table below, you can copy the file name and paste it into the search box as it is the exact search term that should be used.  Furthermore, if you find that the downloads do not complete successfully using the links below, then instead search for the files in the Software Download Center and add them to your download basket.  Once they have been added to your download basket, you can then download them via the software SAP Download Manager.



File NameLinkDetails
SAPCAR 7.20DOWNLOADSAPCAR is used to extract files from SAR archives (similar to winRAR).  Note, this file is platform specific.  The link provided is for Windows x64 platforms.  If you are installing to another platform, please search for and download the SAPCAR version for your specific platform
WILY INTROSCOPE ENTERPRISE MGR 9.5DOWNLOADInstall media for the CA APM Introscope Enterprise Manager.  Note, this file is platform specific.  The link provided is for Windows x64 platforms.  If you are installing to another platform, please search for and download the WIEM version for your specific platform
WILY INTRO EM MGMT MODULES 9.5 SP6DOWNLOADManagement modules and customizations files which contain SAP instrumentation and BOE dashboards
SWPM10SP10DOWNLOADThis is the Software Provisioning Manager (replaces the older sapinst).  Note, this file is platform specific.  The link provided is for Windows x64 platforms.  If you are installing to another platform, please search for and download the SWPM version for your specific platform
721 UC Kernel for SWPM SP10DOWNLOADThis is the Kernel file and includes the Diagnostic Agent 7.4.  Note, this file is platform specific.  The link provided is for Windows x64 platforms.  If you are installing to another platform, please search for and download the Kernel version for your specific platform
(Right click and save target as)
DOWNLOADLicense agreement for CA APM Introscope
osgiPackages.v9.5.6.0.windows.zip  (Right click and save target as)DOWNLOADOSGI Packages required for Introscope Enterprise Manager installation



Step 2:  Install the Introscope Enterprise Manager


SAP provides a read-only version of CA APM Introscope (RTV version) for free as part of your support contract.  This means that you can leverage the monitoring and root cause functionality provided by Introscope, without spending additional money on a full license.  Should you decide that you want to create alerts, customize dashboards, or utilize the Websphere/Weblogic power packs, then I encourage you to contact your account executive about upgrading to the SAP Extended Diagnostics package (SED).


The Introscope Enterprise Manager should be installed on a dedicated server which has 24/7 uptime.  All of the performance metrics are stored in the SmartStor database which is maintained by the Introscope Enterprise Manager.  For best performance, you should install to a dedicated hard disk with plenty of available disk space (300gb or more).  The Introscope Enterprise Manager makes frequent read/writes to this disk and works best if nothing else is reading/writing to this disk in parallel.


  1. Copy the Introscope Enterprise Manager 9.5 SP6 media (WILYISEM06_0-70000324.zip), Introscope 9.5 SP6 customizations (WILYISMM06_0-70000299.zip), eula.txt, and osgiPackages.v9.5.6.0.windows to a temporary folder on the host where you will be installing the Introscope Enterprise Manager


  2. Extract WILYISEM06_0-70000324.zip to a folder WILYISEM06_0-70000324 then move eula.txt and osgiPackages.v9.5.6.0.windows.zip to this folder
  3. Edit the file eula.txt and change "reject" to "accept" to accept the end user license agreement


  4. Edit the file ca-eula.txt and change "reject" to "accept" to accept the end user license agreement


  5. Edit the file installer.properties.  If you want to change the default install location, update the property USER_INSTALL_DIR. Next, set silentInstallChosenFeatures to All


  6. Double-click on the file introscope9.5.6.0windowsAMD64SAP.exe to launch the silent installer.  Wait about 2 minutes and check the install directory for failed log files.  If no failed log is generated then the install worked.  Confirm the install worked by checking your start menu


  7. Next, we need to turn up the Max Java heap setting for Introscope Enterprise Manager.  Browse to your Introscope install bin directory and edit the file C:\usr\sap\ccms\apmintroscope\bin\EMService.conf.  Change the Maximum Java Heap Size to 2048


  8. Next, extract the file WILYISMM06_0-70000299.zip to folder WILYISMM06_0-70000299.  Browse to folder WILYISMM06_0-70000299 then select all files and copy them to your clipboard


  9. Browse to the location where you installed CA APM Introscope Enterprise Manager (by default: C:\usr\sap\ccms\apmintroscope) then paste the contents of your clipboard to this folder.  When prompted, check the option Do this for all current items and select Yes to merge the contents.


  10. Next, go to Administrative Tools and restart the Introscope Enterprise Manager service


  11. Copy the files SAP_BOBJ.jar and SAP_Apache_Tomcat_Basis.jar from <DRIVE>:\usr\sap\ccms\apmintroscope\sap\extra_modules to <DRIVE>:\usr\sap\ccms\apmintroscope\deploy

  12. Open a web browser, then browse to the Introscope WebView.  For example (where wiemhostname is your Introscope Enterprise Manager hostname):  http://wiemhostname:8081/webview
  13. Logon to Introscope using the default credentials.  User: Admin and Password: Admin89


  14. On the Console tab, click the drop-down menu for Dashboard to choose a dashboard
  15. Confirm that the BOE 4.0 dashboards are installed.  Confirm the Apache Tomcat dashboards are installed



Step 3:  Install the Diagnostic Agent on each BI node and application server node


In this step, we will install the Diagnostic Agent 7.4 on each BI node and Web Application Server node.  If the BI node and Web Application Server node are on the same host (as shown in this example), then you only need to install the Diagnostic Agent once.


  1. Copy SAPCAR*.exe, the SWPM (SWPM10SP10_1-20009707.SAR) and Kernel file (51050688_6.zip) to a temporary directory on your BI server (in this example C:\media)

  2. Extract the contents of 51050688_6.zip to this temporary directory.  The extracted Kernel folder will be named Krnl_7.21_WIN__IA32__IA64__x64__SP10_


  3. Open a command prompt and browse to your temporary directory and run the command:

    SAPCAR_617-80000938.EXE -xvf SWPM10SP10_1-20009707.SAR


  4. After the files are extracted, execute the command

    sapinst.exe SMD_INSTALLATION_SCENARIO=ishub


  5. After the Software Provisioning Manager starts, scroll down to the bottom of available options, expand Generic Options, Diagnostics in SAP Solution Manager, then choose Install - Diagnostics Agent and click Next

  6. Next, uncheck the option "Provide the path to each archive seperately" and check "Provide Path to Installation Media".  Click the Add button, then under Media Locations, click the browse button and browse to the location where you extracted the Kernel folder Krnl_7.21_WIN__IA32__IA64__x64__SP10_.  Once you have selected the Kernel folder, click Next.


  7. On the next page, confirm that the hostname is correct and click Next.


  8. By default, the agent installs to the C:\ drive.  Change the Destination Drive if you prefer the files to land on a different drive.  Click Next.


  9. The installer will create 2 user accounts on the localhost for the agent service accounts.  Click Next.


  10. Enter in strong passwords (uppercase and lowercase letters, numbers, special chars etc) for each user account being created by the agent installer

  11. You may receive some warnings about the Operating System Version, it is ok to continue on. Click Next then click No.


  12. Next, enter a strong password to use for the new account sapadm and click Next


  13. When prompted if we want to add SAPServiceDAA to the trusted users list, choose Yes.


  14. You will be prompted to choose an Instance Number, leave this as the default of instance 98 and click Next.


  15. When prompted to Choose the SLD destination, select No SLD Destination and click Next.


  16. When prompted for the Connection of the Diagnostics Agent to SAP Solution Manager, choose Do not configure connection then click Next.

  17. On the Unpack Archives screen, click Next.

  18. On the Parameter Summary page, click Next and the install will begin.

  19. Once the installation finishes, you are done installing the Solution Manager Diagnostic Agent.


Continue to part 2:  New complete tutorial for setting up Introscope 9.5 Stand-alone Monitoring for SAP BI Platform 4.x (Part 2)



The Value Map for Analytics helps you quickly identify the relevant SAP Enterprise Support services, tools, and expertise for a particular objective relating to your SAP Analytics product such as an implementation or upgrade.
Whether you are interested in discovering SAP Best Practices for BI Platform or setting up a BI4 Monitoring solution, you can benefit from our social collaboration platform - SAP Jam.

We can help you to build a road-map to support your whole project with documentation created from customer feedback and with forums to discuss your opinions, challenges or to post your questions to SAP experts and to interact with other customers.

SAP Analytics experts are available via SAP Jam to support you through your project.
Discover best practices, reduce effort and improve results!
It is open for Enterprise Support and PSLE customers to join.


In the Value Map we have put together all of the relevant Empowerment offerings from the SAP Enterprise Support Academy related to BI Platform (and other analytics products). You can work directly with a Focus Adviser to plan a support roadmap of ES deliverables to help ensure your projects are safeguarded, and landscape is operating optimally.  These offerings include:

  • Meet the Expert live meetings and recordings
  • EGI (Expert Guided Implementation) sessions – these are live guided tutorials held over the course of 3-5 days to help you setup BI Platform managed system setup and EWA activation in Solution Manager among other topics.
  • QuickIQ – short tutorials on administrative and operational tasks
  • Best Practice documentation on a wide variety of topics
  • We also have details about remote delivered CQC services to safeguard major events such as a new Implementation or Upgrade project. 

In conjunction with these fixed offerings (all free for Enterprise Support and PSLE customers) you also have the collaboration potential of the SAP JAM infrastructure to give us your feedback and let us know if you feel there are any knowledge gaps that exist. Based on your input we can work to create content you would like to see, when possible.
We also have weekly feed updates to bring you the latest support related news.



For further information on the Enterprise Support Value Map Analytics, please visit our SAP Enterprise Support Academy landing page or register here to join now.
When registering via the link above, select “Analytics Value Map – SAP Enterprise Support” from the drop-down list and fill in your Company details and any objective you may have.

We look forward to working with you!

Here's a quick preview...

Analytics VM preview.PNG


Analytics Value Map Team. 

Hi Folks! Following my initial series of Geek Tweaks on SAP BusinessObjects Lumira today we will be seeing some Geek tweaks on our famous BI Platform. BI Platform at this form of writing is in version 4.2 currently on GA which promises lot of enhancements, improvements and new features which we have been waiting. You can read more about the new features http://scn.sap.com/community/bi-platform/blog/2016/01/11/sap-bi-42--bi-platform-new-features


Some of the tweaks explain the internals of the Platform and are for information purposes and some of them might be dangerous to try in your environment. You are responsible for performing any tweaks related to this.


“God does not make mistakes, the rest of us better take backup”


List all Internal BI Service

SAP BI Platform is built on principle of modular design and exposes its end points as Services so that other applications, clients can consume and communicate with them. Some of the internal SDK operations are also relay on web service to get their job done.

BI Platform uses the famous Apache Axis2 as its engine to process and expose the service. You can find the list of internal services used by the dswsbobje by using the following URL.




This can be also used to check if the service is running or not. If this particular service has issues, SAP BusinessObjects Design Studio may not be able to communicate with BI Platform.

There are some more other services to explore from your webapps folder which is found under <BOBJ Install>\SAP BusinessObjects\tomcat\webapps

Changing the location of Data folder

The Data folder that is present in SAP BI platform acts as a cache and is also responsible for storing the session. Each node in the cluster will have separate folder in the format of hostname_SIAport. In addition to it, some of the services will also have its own folder to store their content.

The data folder should be in a High speed IO disk with less latency for high performance of the BI system. By default, it is located at the following location <BOBJ Install>\ SAP BusinessObjects Enterprise XI 4.0\Data

You can mount a high speed storage on this location so that BOBJ can then take advantage of it. On Linux based deployment it can be done by using the mount command while in Windows it can be done with the power of mklink

mklink /J “<BOBJ Install>\ SAP BusinessObjects Enterprise XI 4.0\Data” “<Destination>”


Finding and changing PID of BOBJ Process

BOBJ platform consists of lot of processing servers which internally spins up numerous process each having unique PID (Process Identifiers). These PID are used to identify the process and start them. You can find the same of each process in your task manager running under the service account which is used to start SIA.




All of the process always run in the same PID. That is because it is easy to operate a process when its PID is known. BOBJ stores all of the PID files in the following location


<BOBJ Install>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\serverpids


Although changing them is not recommended, changing the PID on the process file and restarting SIA would result in the process running with the new PID.


Default Bootstrap BI Platform files

SAP BI platform has a set of default bootstrap files that are created during the install time. Those files hold configuration information and details about the deployment and the instance. The location of these configuration files is

<BOBJ Install>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64

_boe_<nodename>.bootstrap contains the default deployment information in XML, internal Java process configuration and values for various key that the BI Platform uses.

_boe_<nodename>.dbinfo contains the encrypted database information that is used by BOBJ to access the DB

_boe_<nodename>.keyfile contains the encrypted key that is used by BOBJ to encrypt the artefacts in DB


Tweak Advance Configuration

BOBJ is a versatile platform with ever growing features, one of the important aspects of it is the fact that it’s modular and configurable. Hidden amidst of BOBJ files are some advance configurations which can be found at

64 bit

<BOBJ Install>\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\config

32 bit

C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win32_x86\config


The configuration folder contains a lot of configuration information including the version of BI Platform and other XML based configuration used by each process in BI Platform.



WebI Properties

Locate and open the file webiProperties.txt document to find some rendering options that are set for WebI




Apart from this, there are quite a bit of configurations that cannot be covered in this post. Lookout for future posts on those advance configurations.


Starting the CMS in console mode

Console mode is used when the CMS is refused to start or when there are some issues with it which needs some advanced debugging. Often console is used by SAP to debug the CMS when an issue is raised to them. Using the console mode can cause irreparable data corruption or data loss.


More details on the console mode is given on SAP Note 1828536


Securing your BOBJ with FIPS 140-2

BOBJ has support for FIPS based encryption. FIPS stands for Federal Information Processing Standard which is standards that specify requirements for cryptography modules. If your company compiles with this standard, you can enable FIPS to leverage the option in BI Platform.

Simply add the switch –fips to the SIA command in SIA properties to enable fips.


FIPS mode is stricter and prevents old clients that does not follow this to connect to BI Platform. If you are using old clients this may not be an option for you.

That’s all folks in this posts, Keep lookout for more Geek tweaks and if you have any, feel free to post below in comments.


The purpose of this document is to up-grade SAP Business Objects Application from 4.1 SP6 to SAP Business Objects Application from 4.2




Environment Details:

Operating system: Windows Server 2008 64 Bit

Database: Microsoft SQL Server 2012 R2

Web Application: Tomcat 7 & Tomcat 8

SAP Business Objects Tools: SAP Business Objects BI Platform for Enterprise 4.2

Installation & Configuration steps to upgrade BI4.1 SP06 to BI4.2


Pre Installation Check List:


  • Backup of file-store, tomcat configuration files & Data base:
  • Backup of CMS & Audit metadata
  • Backup of Following Configuration Files available at Tomcat (Web Tier) & BOBJ Layer (Management Tier & Processing Tier):
    • web.xml
    • server.xml
    • BILaunchpad.properties
    • Global.properties (If you have done any changes)

  · Make a note of recurring instance available in current environment

    • Pause all instance before doing any upgrade activity


Post Installation Check List:


  • Installation of SAP Business Objects 4.2
  • Validate your configuration with respect to below points:
  • Validate your reports available in your environment
  • SSO (SAP, Windows AD, LDAP, & Others like Oracle SIEBEL)
  • Start all paused instances and check the status after schedule.


SAP Business Objects Platform Services 4.x SPxx PAM Documents:


1338845 - How to find Product Availability Matrix (PAM) / Supported Platforms Document for SAP BusinessObjects Products



1868888 - Where to find Support Packages or Patches for SAP BusinessObjects Business Intelligence Platform 3.x and 4.x? [Video]



SCN Thread related to Pre-requisite:-







Software Path in SAP Market Place:- Please refer above KBA for software detail

Installation & Upgrade:-

Software I.JPG

Support Patches:-

Software II.JPG

Up gradation & Configuration Documents:

When the prerequisite system check completes successfully, click Next


On the "SAP BusinessObjects BI platform services 4.2 setup" page, click Next.


Accept the License Agreement, and click Next.


Type a password for the CMS Administrator account, and click Next


To start the installation, click Next.


Installation is in progress


Updating Repository - Installation is in progress


Post Installation Steps




New Features in SAP Business Objects 4.2 Administration Perspective:-

  • BI Administration Cockpit




Relevant Systems


These enhancements were successfully implemented in the following systems:


  • SAP Business Objects Platform Services 4.2


This document is relevant for:


  • SAP Business Objects Administrator



Reference Material:


SAP BusinessObjects Business Intelligence platform 4.2



SAP BusinessObjects BI4.2 What's New L2



Installation, Upgrade, Deployment:



SAP BusinessObjects What's New Collection:


Updating SAP BusinessObjects BI4.0 or SAP BusinessObjects BI4.1 into SAP BusinessObjects BI4.2 requires a new License Key



How to Upgrade to BI4.0



All you need to know before upgrading to BI4.0



SAP BusinessObjects BI 4.1 Upgrade – Overview



Official Product Tutorials – SAP BusinessObjects Business Intelligence Platform 4.x


SAP BusinessObjects Business Intelligence platform 4.1 Product Availability Matrix:


Overview - Updating SAP BusinessObjects BI 4.x System to BI 4.2 Release



Caching BI 4.2 SP1 Web-Tier for Platform on both Tomcat Machines





1338845 - How to find Product Availability Matrix (PAM) / Supported Platforms Document for SAP BusinessObjects Products



1868888 - Where to find Support Packages or Patches for SAP BusinessObjects Business Intelligence Platform 3.x and 4.x? [Video]



1739722 Upgrade Management Tool - Prerequisites





1654423 Migrations fails or take too long when using SAP BusinessObjects Upgrade Management Tool



1804414 How to increase Upgrade Management Tool timeout?



1863600 - How does session management work with SAP BI Platform 4.0 web application clients?



1837122 - How to increase session timeout value for BI Launchpad and CMC in BI 4.0



1950573 – Is it Necessary to Split the Adaptive Job Server in BI 4.x?



Note 1768713:Crystal report when exported to PDF displays in wrong font in BOE XI 3.1



2144559 Maintenance/Forward Fit Strategy and Schedule for BOE XI3.1 and BI4.x



1724610 How to check the version of SAP BI 4.x installed on UNIX environment



1613846 How to find which fixes are installed on BI 4.x in a Windows environment



1739722 - Upgrade Management Tool - Prerequisites


1904814 - Best practices for a successful migration to BI4 using the upgrade management tool



2047063 - Promotion management services show "The service did not start" on adaptive processing server (APS ) "running with errors"



1602088 - Which version number corresponds to which patch / SP for SAP BusinessObjects BI 4.x ?



2109790 - Error: ‘The action cannot be performed’ when scheduling Webi documents created against unx universes and data tracking is enabled



2297866 - Tomcat8 is no longer to use Permsize and MaxPermsize



2277129 - Unable to access BI Administrators' Cockpit using https in BI 4.2



2266031 - Explorer web application fails to start in Tomcat 8 after configuring for Windows AD SSO in BI 4.2



2228083 - BI 4.2 - Tomcat 8 cannot startup when Wily Introscope Agent is configured



2112338 - List of Bundled Tomcat and JVM versions shipped with each (support pack) SP of SAP BusinessObjects Business Intelligence 4.0/4.1/4.2



Video ( SCN recoded webinar & YouTube):


SAP BI 4.1 - Solution Expert Webinars



BI Upgrade: A Guided Tour of Online Resources



Upgrade Process: Moving from BusinessObjects XI Release 2/3.1 and BI 4.0 to BI 4.1 https://www.youtube.com/watch?v=HWNhWNsnMZI


SAP BusinessObjects BI 4.1 Sizing and Virtualization



SAP BusinessObjects BI 4.1 Installation and Patching


SAP BusinessObjects BI 4.1 Sizing and Virtualization



SAP BusinessObjects BI 4.1 Installation and Patching



SAP BusinessObjects BI 4.1 Upgrade and Update – Best Practices


Another regular day at work. I log into the Customer Support System to see if there are any Customer Incidents assigned to me. I see one new Incident. One customer created the incident to clarify some confusing piece of information in the BIP Administrator Guide. Of course! This is not surprising to me. More often than not I find that customers are unable to understand a crucial step or find that some information is missing in our Admin Guide. Being a part of a Support team, it bothers me more and more to see you - our customers - struggle to understand our Product Documentation. That means our documentation essentially isn’t serving its prime purpose.

Since I know this is not the first time someone needed help understanding our documentation, I find a KBA with a solution. But then something occurred to me:

“What if we could fix our documentation by rewriting the steps from the point view of the customer and by adding screenshots and graphics?”

“Could we collaborate with Documentation team to make our Admin Guide better which as a result would reduce these types of Incidents?”

I talked to my team and found that they had similar frustrations and expressed the same interest in fixing Documentation first hand. That’s how we got working on a project to enhance our Admin Guide. The first call of action was to get the buy-in from Knowledge Management team who create the Admin Guide. I connected with Priyanka and Malavikha and presented our ideas to them. I was so happy when they were on board with us. They appreciated our involvement and we worked on a plan of how we were going to work on the issue. We had great collaboration between the Product Support and the Knowledge Management teams since the beginning of 2015!


Here’s what we did to address our problem:
1. We identified sections of the Admin guide for which the most number of how-to Incidents were created. Naturally, it seemed like a good place to start. We also looked at the most viewed Knowledge Base Articles which were also covered in the Admin Guide. If you were looking at KBAs instead of the Admin Guide for instructions that meant we can write our documentation better.
2. We then tried to test all the documented workflows in the identified sections to see if there was some incorrect or missing information.
3. We also worked with most experienced Support Engineers to re-write the instructions in documentation for the frequently asked how-to questions.
4. After validating all the workflows, we tried to reword the steps to make it clearer and more complete, added images and screenshots to support complex workflows and also linked any related videos or KBAs to the relevant sections.
5. Also, we create HTML versions of the Admin Guide. This way you can view HTML version and go directly to the chapter they need without downloading the entire 20+ MB file.


Here is an example of how the KBA with a video would appear in Admin Guide:



And when you click on the link, you will get this:


As I have also learned, Knowledge Management team is working on some exciting projects to make our documentation even better. Here Malavikha will share some of them with us.


“Working with the Product Support team to enhance the quality of documentation in the BIP Admin guide, I believe, was a much-needed first step towards helping you understand the workflows better. But, that’s not the only thing that the Knowledge Management team is working on in terms of enhancing the documentation.
Here are some of the Initiatives that my team is driving:
1. New-feature demo videos: Well, as they say ‘A picture speaks more than a thousand words’ and a video can only mean more! In order to aid you better, we decided to deliver documentation through a new channel – through videos. We have created new feature how-to demo videos for BI 4.2 release. These videos explain the concept and also demonstrate how users can complete a particular task. It will certainly help users consume documentation better. All these videos are hosted on SAP’s YouTube channel and referenced in the What’s New guide. We plan to continue this initiative for our future releases as well.
2. Error Message Improvement Initiative: Most often, we notice that our error messages go ‘Contact your system administrator’. This doesn’t help you much, as it does not really state the cause of the error or some basic actions that the user can take. Also, what if the user is the Administrator?! So we reworked some error messages in the Error Message guide – identified the cause for these errors and also the immediate actions that the users can perform by self, without actually reaching out to the administrator. This will surely help you to resolve issues faster.
3. Conducting Customer Interviews to obtain feedback on Product Documentation: We are also trying to reach out to you to obtain detailed feedback on product documentation to understand what their pain-points are, and also to hear first-hand from them about what they would like to be improved or enhanced in documentation. Simultaneously, we will collate feedback, analyze them, and work towards incorporating the feedback comments.”



We really hope that you will find our Product Documentation easier to read and understand. This way you can find the answers yourself without having to log an Incident and wait for the answer from us. Our job is nowhere near to be complete as we continuously look for ways to improve our documentation.



What can you do?
Do you have suggestions on where the Admin Guide may be improved/clarified? Please let us know. Add a comment to this blog. We value your input.

Just got a chance  to look at BI 4.2 post GA. Every new feature added in this release looks promising and it will definitely going to add advantage to Platform support teams also it will be a big relief for every administrator/Architect for platform management.


Administrator’s cockpit is one among the impressive feature I can think of. However with the current capability we may not be able to achieve all our day to day monitoring/troubleshooting/Support activities. To know more about Administrator’s cockpit you can view the video here.



You can see 4 different sections when you navigate to Administrator’s cockpit in BI 4.2 CMC






With the current features we can get the overall summary of the Servers status along with an ability to start the server in case if it is down.


My wishlist


It would be good if we have the ability to navigate to Server/Server groups page of the CMC itself as we may required to perform other activities such as Stopping / Disabling currently running services in few scenarios. Along with this if we have the server running pattern over a period of time (time range as in other sections), it might have been very useful as it may help us to do the downtime analysis of each individual server.




Again this is similar to servers with over all summary of schedules with a time range.




My wishlist


Monitoring schedules is one among the key activity in BI platform as it is business critical. The typical expectation would be something like hour by hour analysis as below which will give a complete picture about the report schedules over a period of time.  This will also give us the busiest times which will again help us to fine tune the environment/Adjust the report schedule times/size the BO services accordingly etc.…




Content usage and Applications


I don’t have much expectation from Content usage and Applications sections as of now, however I appreciate comments from other as well.




Disclaimer:  I have written this blog in a view to share my expectation based on my experience and this doesn’t mean that these features will be incorporated in future releases. This blog is neither endorsed by SAP nor by my employer. Please don’t hesitate to comment on your ideas based on your experience.


I am planning to create a Idea place entry based on the response received here. Thanks for reading.


Happy Blogging…




Dear BI Community,

It’s my pleasure to announce the release of Phase 5 of SAP BI Pattern Books project with two books on how to successfully move to the latest SAP BusinessObjects BI 4.2 release. The first book is on “how to upgrade from BOE XI 3.X to BI 4.2” and the second one focuses on “how to update from BI 4.x to BI 4.2”.

Key highlights of the books:

  • These books were developed using system landscapes that is similar to our common install base with more than fifteen servers, thousands of objects and bunch of applications
  • The best practices, recommendations, tips / tricks and including the what’s new in BI 4.2 release are highlighted throughout the sections of these books
  • First time ever, we are releasing pattern books immediately after the GA of BusinessObjects software release


Here are the quick links to the SAP BI Pattern Books;

Pattern Books Home Page


Pattern Book on Upgrading from BOE XI 3.X to BI 4.2


Pattern Book on Updating from BI 4.X to BI 4.2


Please help me spread the news.






Filter Blog

By author:
By date:
By tag: