""

How to approach a Social Media Analytics project?

In previous occasions we have dedicated blog posts to the Social Media analytics topic, however we still had not written about which are the most common questions our projects must answer or which are the objectives we should aim for when we plan to extract insights from a Social Media network.

 

What you should deliver

Last year, SAP gave a series of webinars focused on Social Media (that you can find here if you have a valid SAP user) where they shared some interesting ideas about what a social media project should deliver to a customer. As consultants, we put a great portion of our efforts in endorsing our projects with as much value as possible, which was one of the topics discussed in these webinars. From them I extracted 4 principles that we should try to align our projects with in order to accomplish our goal of delivering value from Social Media analytics.

  • Speed: Social Media analytics must enable the customer to solve challenges faster through a comprehensive understanding of the technologies and experts related to their business. On the other hand, in a world where we have 6000+ tweets per second in average (source: https://twitter.com/TPS_watcher) there is a lot of information to analyze and not enough time to digest all of it, so we have to make sure that whatever our customer is analyzing from their social networks we are able to do faster!
  • Impact: The data that you extract and produce needs to give the necessary information to the customer to enable them to drive higher quality outcomes and build a reputation among their targets in the social networks. If you know what your target is hungry for, the easier it gets to satisfy their needs. Your analytics must be capable of making the customer understand how much they stand out and to monitor their presence in the social networks.
  • Insight: This principle is also related with the above in the sense that when your customers are constantly listening to what experts in their industry are talking about, they could benefit from that collective wisdom to innovate and differentiate themselves from other competitors. It is not just a matter of gathering data, it is also necessary to gather knowledge and trends. It also comes without saying that this also applies to monitoring what your customers' prospects are saying, an accurate and timely understanding of their needs or opinions, increases your customer’s probabilities of delivering what they want.
  • Efficiency: With all the information that you deliver from the Social Media analytics, you can make it possible for your customer to reduce time and investments spent in the monitoring of their Social Media activity. You should deliver with a server in minutes (why not in real-time?) what several brains take to process in many hours of work.

What you should be asking

One of the main risks of these projects is that it is very easy to lose yourself in the gigantic amount of information that you can extract, so from the very beginning you have to determine the main questions that your customer wants answered and solely focus on them. In my opinion, the most common key points that you should always look for are:

  • Who are the business influencers and what are they talking about?
  • What is the competition doing and how are they using their Social Networks? How big is their impact compared to your customer's?
  • Which are the Social Media networks that are best suited for your customer's needs?  Are they being used enough?

 

What are the benefits for your customer

Now, imagine yourself in a position where you have to sell the key benefits to a potential customer. He does not want to hear the whole “Social Media is the future” speech, he just wants you to get to the point… If your project can deliver these points below, you will be indubitably in good shape:

  • Discover key business influencers and reach them
  • Design effective strategies assessing the competition’s activities
  • Understand if the message sent to the target has good visibility

If you have any questions or anything to add to help improve this post, please feel free to leave your comments. You may also find other interesting articles related to this topic in our blog here.

Providing SSM data to SAP BusinessObjects reporting tools - Exhausting all scenarios

In the last two months I have been in a couple of customers who were interested in the integration of SAP Strategy Management 10.0 with SAP BusinessObjects BI Platform 4.0. In this post I would like to explain what that integration is about.

First of all, a brief introduction about the solution. The SAP Strategy Management (SSM) software allows aligning the Strategy Plan of the company and its key objectives and spread it across all the organization. It is an out of the box Enterprise Performance Management solution in which you can insert the most important KPIs of your company in Balanced Scorecards or Strategy Maps and control their performance in relation to the Strategy of the company. Within SSM you can also create initiatives to implement improvements or corrective actions and link them to the objectives or KPIs.

Sometimes the customer has requirements to implement reports or further analysis on top of SSM and these cannot be covered with the standard functionality of the solution. In that case, the best option is to implement the integration between SSM and SAP BusinessObects reporting tools. Some examples of what you can do with that integration:

  • Implement bespoke Dashboards with your SSM KPIs and Objectives
  • Implement universes and allow users to exploit information from SSM with Web Intelligence without consuming additional SSM licenses
  • Implement pixel-perfect Crystal Reports on top of the SSM
  • Foster ownership with Publications. For example, send a list of KPI’s that are not performing well to their responsible users

For implementing such integration, you can follow the SAP SSM Configuration guide. However, in some cases, there is lack of documentation and you have to do things outside the script. In other cases, the existing documentation has not been updated yet to BI 4.0 and SSM 10.0. And finally, sometimes the documentation is wrong or the software has bugs and you cannot setup the integration.

In this post we will analyze following scenarios:

  1. Web Intelligence reporting on top of a SSM Models
  2. Web Intelligence reporting on top of a SSM Data Model (Clariba-developed solution)
  3. Crystal Reports on top of SSM (exploring different options)
  4. Dashboards on top of SSM (exploring different options)

These scenarios have been implemented with following software components:

  • SAP NetWeaver 7.3 SP08
  • SAP SSM 10.0 SP06
  • SAP BusinessObjects BI Platform 4.0 SP05
  • Crystal Reports 2011 SP05
  • Dashboards 4.0 SP05

1. Web Intelligence reporting on top of a SSM Model

As per SAP documentation, we can setup the ODBO Provider in order to build a Universe on top of SSM Models. The problem is we still have to use the Universe Designer instead of the Information Design Tool of the BI 4.0. Bellow are the steps for setting up the ODBO Provider and implementing your first report on top of the SSM:

  • Go to your BO 4.0 server and make sure you have a Multimensional Analysis Service in the BO server. Stop the MDAS Server and the Connection Server in the Central Configuration Manager
  • Copy the ODBOProvider folder from the <drive>:Program files (x86)SAP BusinessObjectsStrategy ManagementInternetPub path of your SSM server to the BO server
  • In the SSM server, run the SSMProviderReg.bat file in the BO server. Make sure you have administrator rights in the BO server. Once completed, check in the regedit that you are able to find the register SSMProvider.1 in the Windows register
  • Modify the windows register to insert following string in that path (assuming that you are using a 64-bit Windows): HKEY_LOCAL_MACHINESOFTWAREWow6432NodeSAPSSMODBOProvider "servletUri"="/strategyServer/ODBOProviderServlet"
  • Access the following path in BO server: <drive>:Program Files (x86)SAP BusinessObjectsSAP BusinessObjects Enterprise XI 4.0dataAccessconnectionServeroledb_olap

<DataBase Active="Yes" Name="Strategy Management 10.0">

<Aliases>

<Alias>Strategy Management 10.0</Alias>

</Aliases>

<Library>dbd_sqlsrvas</Library>

<Parameter Name="Family">SAP BusinessObjects</Parameter>

<Parameter Name="Extensions">sqlsrv_as2005,sqlsrv_as,oledb_olap</Parameter>

<Parameter Name="MSOlap CLSID">SSMProvider.1</Parameter>

</DataBase>

  • Start the MDAS Server and the Connection Server
  • Now we can go to the Universe Designer and start implementing a Universe on top of our Model. The first step is defining the connection. In the connection list (retrieved from the Connection Server) we can see now the new register we have inserted, Strategy Management 10.0:
  • Define the connection parameters. You must be an SSM user with proper permissions and you must inform the server's complete address (FQDN) and its port.
  • Once connected to the SSM server, you will see the list of available Cubes. The AS category allows access to the measures (based on attributes and dimensions) in the Application Server model.The SM Adapter allows access to the strategy dimension, which represents the strategy management dimensions Scorecard and Initiative. Scorecard detail not relating to the KPI such as comments are not presented.
  • And finally we will see our universe with the available dimensions, the standard classes (Time and Scorecards) and the measures. You can display the technical names of the objects as detail or you can define hierarchies of Perspectives, Objectives and KPIs.
  • Now we can publish the universe and go to the Web Intelligence to start implementing our reports on top of the SSM models.

2. Web Intelligence reporting on top of SSM Data Model

That is a solution you can implement if you have an advanced knowledge of the SSM Data Model. You can implement a UNX Universe with the Information Design Tool by linking all the tables of the Entry and Approval, the Nodes of the Scorecard, the Cube Builder or the Initiatives. The advantages of that option is that you have access to extra information not available in the SSM Cube,  such as the Initiatives, the users related to specific KPIs, the attributes of the KPIs etc.

If you are interested in such an option, please, contact us. Keep in mind that it is not a supported option from SAP but we have implemented it many times and we know it works.

3. Crystal Reports on top of SSM

The integration of SAP Crystal Reports with SSM can be done by 4 different ways:

  • Implementing a Query as a Web Service from the Universe, built in previous steps: we have managed to implement that scenario
  • Connecting Crystal Reports to the Universe on top of the SSM Models we have built in the first step: that scenario is not working although we followed the instructions from SAP
  • Using an OLE DB (ADO) connection: this option, not explained by SAP, is available if we install the ODBO provider but we have not managed to make it work
  • Using the OLAP Connection: according to SAP Documentation, we can build an OLAP Cube Report in Crystal Reports. We should be able to select the Strategy Management option in following screen to inserts SSM connection data, but we have not been able to find that option

4. Dashboards using Web Services Connections

Using Dashboards, you have two different ways to implement the access to data:

  • Implement a Query as a Web Service (QaaWS) to retrieve the relevant information from the Universes we had implemented before.
  • Use Web Services available in the SAP NetWeaver to retrieve information from the SSM:  according SAP documentation you need to download the WSDL file SMDataServiceService and CubeServiceService applications and call the functions within them. With our Dashboards 4.0 SP05 we have not been able to process the WSDL files as the tool is unable to load the URL.

Summary

Providing SAP Strategy Management information to SAP BusinessObjects BI Platform 4.0 can enhance the capabilities of your Strategy system. However that integration is not so easy given the lack of information on that topic and the quality of the existing information. We tried to implement all possible integration scenarios and we have succeeded with Web Intelligence and this is the route we recommend  as the scenarios related to Crystal Reports and Dashboards the integration were not working when using SSM 10.0 and BI 4.0.

We will be following-up these issues and let you know if we finally manage to solve them. If you have any suggestions or if you found a workaround to these issues please leave a comment bellow.

Join Clariba at the SAP Forum Oman on March 6

Clariba is pleased to sponsor SAP Forum in Muscat. This is the first SAP Forum event to take place in Oman, following the recent opening of SAP offices in the country in 2012 to better serve local clients.

Aimed  at C-level executives, IT decision makers and Business managers, SAP Forum is an unmatched chance to investigate the entire SAP ecosystem in one day, and understand the value it can bring to your business.

At the SAP Forum Oman you will be able to:

      • Network with industry peers
      • Hear about the experiences of SAP customers and how SAP solutions have been helping them run their business better
      • Gain insight from thought leadership keynotes from SAP´s top level management
      • Catch focused presentations on  topics like Rapid Deployment solutions, Cloud, In-Memory, Analytics and Mobility
      • Meet Clariba and other SAP partners at the exhibition area

 

A recognized SAP Gold Partner, Clariba is a leading SAP Business Intelligence consultancy in MENA and a specialist in SAP BusinessObjects and SAP HANA technologies. You are invited to meet the Clariba team at our booth at the exhibition area. There you will be able to see our dashboard and reporting solutions developed for our clients - leaders in a variety of industries such as telco, banking and oil & gas.

“Clariba is excited to take part in the first SAP Forum Oman, says Marc Haberland, Managing Director of Clariba. “Clariba is already working in Oman and we are thrilled to see SAP investing in the region as well. Come meet us at the Exhibition Zone for insights in innovative business intelligenceenterprise performance and information management solutions."


Attendance at the SAP Forum Oman is free of charge. 
Register now to secure your place.

Details of SAP Forum Oman

Date: March 6th
Time: From 8:30 a.m. to 4:30 p.m.
Location: Al Bustan Palace, A Ritz-Carlton Hotel, PO Box 1998, Muscat 114 Oman 
Register now

 

Your Invitation to SAP Forum Oman on March 6

 
 

SAP FORUM, Oman

Join Clariba at the first

SAP Forum in Oman

Register Now

 

Mark your calendar

Date: 6 March, 2013
Timings: 08:00 – 17:00
Venue: Al Bustan Palace-Ritz-Carlton 
Cost: Free to attend

Find out more ›

We are ready to inspire innovation at the SAP FORUM Oman. This time it is coming to Muscat, Oman on 6 March, 2013. Experience the most awaited annual SAP event focused on expanding your technology knowledge, enriching your business value and discovering how SAP solutions can help companies like yours run like never before.Here’s a brief intake on what you can experience at this year’s SAP FORUM:

    Hear from SAP executives and thought-leaders about the latest essential business technology trends and innovations like Mobile, Cloud and Analytics
 
      Participate in highly informative, collaborative panel discussions and breakout sessions, led by today’s leading SAP evangelists and experts who can help you transform the way technological innovation is leveraged for ongoing business value
 
      Gain valuable insights by listening to the real-world experiences of SAP customers who will share their experiences in successfully implementing SAP solutions
 
       Get an in-depth look at future SAP applications that support your growth strategies, create a competitive advantage and provide positive impact for your business
 
      Interact with our Partner Ecosystem in our Exhibition Showcase to experience current SAP-supporting technologies and services

This is your time to network with SAP executives, meet our entire ecosystem in one place and learn how SAP can help companies like yours Run like never before.

Attend our Dubai event - Taking your business to new heights with SAP HANA & Business Intelligence

Taking your business to new heights with SAP HANA & Business Intelligence.

Hands-on experience on how convergence to in-memory, real-time analytics can help accelerate your business.

 

Register Now

SAP, Clariba & Fujitsu cordially invite you to learn SAP’s strategy to fast-forward your business to real-time analytics with this session on SAP HANA & Business Intelligence.
You will experience how your end-users can leverage the power of SAP HANA for instant analysis of structured and unstructured data with SAP's leading BI solutions. Furthermore learn how business users can easily extract actionable insight from vast amounts of data with speed-of-thought analytics and predictive analysis
.

Agenda Overview

08:30am - Registration & Coffee Break

09:00am - Welcome & Introduction

09:15am - Where is SAP going with BI? (SAP)

10:00am - Real-Time Data Platform (SAP)

10:45am - Mid-Morning Coffee Break

11:00am - Taking Your Business to New Heights with SAP HANA (Clariba)

11:45am - Introduction to SAP HANA Infrastructure (Fujitsu)

12:30pm - Wrap-Up

12:45pm - Lunch

02:00pm - SAP HANA Hands-On Session (HANA Technical Academy) for up to 10 participants* 

We look forward to seeing you there.

* fully booked

Dubai, UAE

March 13th, 2013

8:30am - 05:00pm
Radisson Blu Hotel
Dubai Media City

Click here to register

Attend our Event - Real Time Business Visibility with SAP BusinessObjects & SAP HANA- Kuwait and Bahrain

.

 

Real-Time Business Visibility  with SAP BusinessObjects and SAP HANA. Join SAP and Clariba and discover how to gain actionable insights from your Oracle eBusiness Suite and other mission-critical systems.

. . Register Now

We would like to invite you to learn how to put enterprise-wide data on your Oracle eBusiness Suite (EBS) to use in order to make timely decisions, using SAP BusinessObjects revolutionary real-time processing technology. The detailed agenda for this half-day event is the following: - Registration & networking breakfast: 8:30- Welcome & overview: 9:00

- Real-time business intelligence: 9:15

Demo of Real-time Business Intelligence (BI) dashboard and reports, running in real time

Brief introduction to SAP BI Suite

Discover self-service analytics with Visual Intelligence

- Predictive analytics in real-time: 10:00

Demo of trend and scenario analysis

Decisions on-the-go with SAP BI Mobility solutions

- The real-time technology revolution:10:45

Business case for SAP Real-Time Data Platform (RTDP)

Building a solid data integration strategy

- Coffee & networking break: 11:00 - Taking your business to the next level with SAP HANA for Oracle EBS by SAP Gold Partner Clariba: 11:15

Challenges today (explosion of data, complex data sources, need for agility and rapid deployment of solutions

Business case including demo with Oracle EBS data

Business benefits and time-to-value

Brief talk on abundance of hardware solutions that match any requirement and existing install base

- Best time-to-value with SAP Rapid Deployment Solutions (RDS) by SAP Gold Partner Clariba: 11:45                              

Overview of RDS

Fixed price, fixed time, fixed scope projects

Examples of RDS & benefits to customers

- Wrap up: 12:15                                      - Lunch: 12:30  

Meet the experts over lunch

We look forward to seeing you there.

Kuwait March 4th, 2013

Venue: Courtyard Mariott

Time: 9:00am to 2:00pm

Kuwait City, Kuwait

To register click here

March 5th, 2013

Venue: Ritz-Carlton Hotel

Time: 9:00am to 2:00pm

Manama, Bahrain

To register click here

For more Information

www.sap.com/mena

Using Google Chrome with SAP BusinessObjects

We all know that there are many internet browsers available, but definitely Google Chrome is one of the most used nowadays and therefore we have had a lot of feedback from our customers related to using chrome with SAP BusinessObjects.

A main problem found by users is that when using Google Chrome on InfoView or BiLaunchPad a missing plug-in error screen appears when you are trying to modify a report and it also shows a HTTP Status 500 error screen when trying to log in to SAP BusinessObjects Explorer. In this blog I will provide a solution these issues.

Issue when login to InfoView or BILaunchPad in GoogleChrome
Issue when login to InfoView or BILaunchPad in GoogleChrome
Issue when accessing SAP BusinessObjects Explorer
Issue when accessing SAP BusinessObjects Explorer

The solution we have found is to use a Google Chrome add-on called “IE tab”, which emulates Internet Explorer on Chrome.

Steps to install it:

  1. From Google Chrome, introduce the link in the url bar and install the add-on.                                                                                       https://chrome.google.com/webstore/detail/hehijbfgiekmjfkfjpbkbammjbdenadd
  1. Once installed you will see a small folder with the IExplorer logo on the top right corner of google chrome.
Folder with Explorer logo
Folder with Explorer logo
  1. Click on the folder and another url bar will appear
URL bar appears
URL bar appears
  1. Introduce the Infoview / BI LaunchPad link in the new bar and start working with it.

Moreover, in case you need to click on an Open Document link and you want Google Chrome to be opened up automatically with it you will need to add your server’s url so it can open successfully, for this you need to follow these steps:

  1. Right click on the small folder with the IExplorer logo
  1. Choose Options
  1. Add the server’s address text in the Auto URL’s field

The outcome

SAP BusinessObjects web based applications can be successfully used with Google Chrome, see below the following examples:

Modifying a report on InfoView
Modifying a report on InfoView
Viewing and managing spaces from SAP BusinessObjects Explorer
Viewing and managing spaces from SAP BusinessObjects Explorer

Summary

The main benefits of applying these tips are, with the help of Google Chrome:

  • Modify documents on Infoview / BILaunchPad
  • Log in and manage spaces in SAP BusinessObjects Explorer
  • Increase the speed of navigation while going through the platform folders

According to the SAP’s official PAM (Product Availability Matrix), Google Chrome is not entirely supported due to its fast development speed, so the use and frequent update of this add on is highly recommended.

Hope this will help you have a better experience when working with SAP BusinessObjects. If any doubts or suggestions please leave a comment below.

How to configure SQL Server connectivity for WebI from SAP BusinessObjects BI4.0 in Linux

Nowadays we have noticed some of our customers are following the trend of open source products. Indeed, Linux is a great choice of operating system due to the fact it is totally compatible with SAP BusinessObjects BI 4 and it also help companies to cut costs.  However, Linux has retained the way the classical Unix operating system works and therefore everything is about rights and batch commands. Therefore an advanced Linux technical know-how is compulsory before getting into it.

The purpose of this blog entry is to share the issues we faced in one of our customers running SAP BusinessObjects BI4 SP4 in a Red Hat Enterprise Linux Server release 6.3 using MySQL 5.1.61 as the system database and how we solved them.

The issue came out when right after a production database migration (a brand new SQL Server 2008) all their WebI documents stopped running from the SAP BI4 Launchpad with an unusual error "Database Error .[ (IES 10901)" blocking every single WebI to run and the whole core business was jeopardized. Rich Client did not experience any problem in Windows. After the first analysis, we discovered that default SQL Server ODBC driver installation was only configured properly for 32bit connections in the Linux server whereas WebI requires 64bit ODBC driver connectivity for running in the SAP BI4 Launchpad.

When it came to this point we had to apply a couple of OSS notes. The first one was OSS 1607125 "How to configure SQL Server connectivity for WebI from a BI4.0 unix environment". Resolution is:

1. Open env.sh under <install directory>/sap_bobj/setup/

2. Search for the following line

LIBRARYPATH="$LIBDIR:$LIBDIR32:$WCSCOMPONENTDIR:$PLUGINDIST/auth/secEnterprise:${CRPEPATH64}:${CRPEPATH}:${MWHOME}:$PLUGINDIST/desktop/CrystalEnterprise.Report:${BOBJEDIR}enterprise_xi40/$SOFTWAREPATH32/ras:${BOBJEDIR}mysql/lib”

3. Modify the line above by adding the following

":${BOBJEDIR}enterprise_xi40/linux_x64/odbc/lib:${BOBJEDIR}enterprise_xi40/$SOFTWAREPATH32/odbc/lib"

The line should look like this

LIBRARYPATH="$LIBDIR:$LIBDIR32:$WCSCOMPONENTDIR:$PLUGINDIST/auth/secEnterprise:${CRPEPATH64}:${CRPEPATH}:${MWHOME}:$PLUGINDIST/desktop/CrystalEnterprise.Report:${BOBJEDIR}enterprise_xi40/$SOFTWAREPATH32/ras:${BOBJEDIR}mysql/lib:${BOBJEDIR}enterprise_xi40/linux_x64/odbc/lib:${BOBJEDIR}enterprise_xi40/$SOFTWAREPATH32/odbc/lib”

4. Navigate to <install directory>sap_bobjenterprise_Xi40

5. Open odbc.ini file using vi or other text editor tools.

6. Find the entry for Sql Server DSN.  The default DSN entry in the odbc.ini is called "[SQL Server Native Wire Protocol]" but it's recommended that you create your own DSN entry using the same parameters specified in the default DSN.

7. Update the "Driver" section of the DSN to point to 64 bit version of SQL Server ODBC drivers

Driver=<install directory>/sap_bobj/enterprise_xi40/linux_x64/odbc/lib/CRsqls24.so

8. Restart the SIA

However the issue was not resolved completely. We received a new error with the following description whenever we tried to run a WebI "Receive the error : Database error: [DataDirect][ODBC lib] System information file not found. Please check the ODBCINI environment  variable.. (IES 10901) (WIS 10901)". This is a configuration issue on the Linux operating system with the environment variable ODBCINI.  Please make sure your environment variables are set correctly according to OSS note 1291142 - "Web Intelligence reporting using DataDirect drivers in Unix" (as of today it still applies to BI4). Resolution is:

1. In the Bobje user's Unix profile, add/modify the following environment variables and source the profile

BOBJEDIR=<install_path>/bobje export BOBJEDIR ODBC_HOME=$BOBJEDIR/enterprise120/<platform>/odbc export ODBC_HOME ODBCINI=$BOBJEDIR/odbc.ini export ODBCINI LD_LIBRARY_PATH=$BOBJEDIR/enterprise120/<platform>/dataAccess/RDBMS/connectionServer:$       ODBC_HOME/lib:$BOBJEDIR/enterprise120/<platform>/:$LD_LIBRARY_PATH export LD_LIBRARY_PATH

NOTE: For AIX replace LD_LIBRARY_PATH with LIBPATH, For HP-UX use SHLIB_PATH NOTE: Replace <platform> with linux_x86, solaris_sparc, aix_rs6000, hpux_pa-risc depending on your specific Linux platform. NOTE: You must set/export the above env variables in the same order as shown.

Please make sure to use the file $HOME/.odbc.ini as your default source for ODBC settings. Therefore, modify the ODBCINI variable in the following way:

ODBCINI=$HOME/.odbc.ini export ODBCINI

2. Modify the odbc.ini to add the DSN

                  [TestDSN] Driver=<install_path>/enterprise120/<platform>/odbc/lib/CRmsss23.so Description=DataDirect 5.3 SQLServer Wire Protocol Driver Address=<sql_server host or ip>, <port> Database=<db_name> QuotedId=Yes AnsiNPW=No

NOTE: Your DSN name (TestDSN) must be the same DSN name you used when creating the ODBC connection in Windows

3. DataDirect provides both NON-OEM drivers and OEM drivers

The drivers provided by BI4 are OEM drivers. Basically the WebI is dependent on the ConnectionServer.  By default the ConnectionServer is set to use NON-OEM drivers. Thus, we edited the connection server to allow the use of the OEM branded DD driver. The steps are:

  • Make a backup copy of $BOBJEDIR/enterprise120/<platform>/dataAccess/RDBMS/connectionServer/odbc/odbc.sbo
  • Open odbc.sbo with VI, search for DataDirect, there are 4 entries one for each MSSQL server we support.
  • Change all 4 from No to Yes <Parameter Name="Use DataDirect OEM Driver" Platform="Unix">Yes</Parameter>

 4. Stop all XI servers

Run ./stopservers, log out completely from your unix shell and log back in (to make sure new environment variables are setup), start all BI4 servers again.

After applying the OSS note we were able to retrieve data from SQL Server 2008 refreshing our WebI documents, however we noticed that CPU was reaching 100% every time we used a WebI in any way. Going through the log files we found errors such as "MS SQL Server 2008 |JobId:61340512 |EXIT SQLGetDiagRec with return code -1 (SQL_ERROR)" .

We took a look at the odbc.ini file and we found out that QWESD entry that was not initially there somehow appeared. As long as we were copying the information from an existing datasource we didn't need it all and we decided to remove the QEWSD=<random string> from the ini file.

Finally double check that <Parameter Name="Use DataDirect OEM Driver" Platform="Unix">Yes</Parameter> located at sqlsrv.sbo file in /opt/bi40/sap_bobj/enterprise_xi40/dataAccess/connectionServer/odbc is set to Yes.

We hope that our experience is a rapid problem solving approach for you. If you have any tips or suggestions to improve this article, please leave a comment below.

Tomcat Upgrade from version 5 to 6 in BOXI 3.x: close the security risk

This post will guide you through the steps on how to successfully make the upgrade of your Tomcat from version 5 to 6 in BOXI 3.x to remove the risk produced by a security hole. The process was done in an environment with Windows Server, SAP BusinessObjects Enterprise XI 3.1 SP3 and Apache Tomcat 5.5. The new Apache Tomcat used was version 6.0.36.

Resolution and steps

All instructions below are using default paths for SAP BusinessObjects and Tomcat 6 installations on a Windows system where the files are put in to “C:Program Files”;  you can change replace these folders with your own ones.

1) Download Tomcat 6.0.x service installer (Where the x is the version that you want).

2) This step is only needed if your SAP BusinessObjects installation does not have the Java JDK installed:

2a) Download the JDK 5.0 Update 22.

2b) Install the JDK 5.0 Update 22 package.

3) Run and install the Tomcat 6.0.x executable. The Welcome screen will appear. Click Next.

4) Click "I Agree" on the License Agreement screen.

5) Select the install type from drop down box & click Next.

6) Enter the destination folder where Tomcat 6 is to be installed. Click Next

7) Enter the user name & password for Administrator login & click Next.

8) Enter the below mentioned path that points to JRE supplied with BOE XI 3.1 (or the JDK in “C:Program FilesJavajdk1.5.0_22” that was installed in step 2). Click Install.

9) Uncheck the "Show Readme" check box. Click Finish.

10) Tomcat will now start. There will be a small icon in the system tray as shown below.

Tomcat Icon in the system tray
Tomcat Icon in the system tray

11) In case that your system is 64bit you can download the Tomcat 6.0.x 64 bit binaries. You need both the tomcat.exe and tomcat6.exe files.

11a) Stop Tomcat and then overwrite your tomcat.exe and tomcat6.exe files in the directory where you installed Tomcat to “C:Program FilesApache Software FoundationTomcat 6.0bin” after backing up the current files.

11b) Start Tomcat service again.

12) Right click on the icon & click Configure.

13) The Apache Tomcat Properties screen will appear. Click on Java tab.

Apache Tomcat Properties screen
Apache Tomcat Properties screen

14) Add the path "C:Program FilesBusiness Objectsjavasdklibtools.jar" in Java Classpath field after the existing entry separated by a semi-colon (;).

15) Add the value 1024 (the value depends on your RAM) in Minimum and Maximum memory pool field.

16) Add the following values in the Java Options field.

-Dbobj.enterprise.home=C:/Program Files/Business Objects/BusinessObjects Enterprise 12.0/ -Xrs -XX:MaxPermSize=512M -Dbusinessobjects.olap.bin= -Dbusinessobjects.olap.stylesheets=C:/Program Files/Business ObjectsOLAP Intelligence 12.0/stylesheets/ -Djava.awt.headless=true -Daf.configdir=C:/Program Files/Business Objects/Dashboard and Analytics 12.0

17) Click on Apply, OK and restart the Tomcat service.

18) Open the file config.tomcat6 in Notepad. It can be located in "C:Program FilesBusiness Objectsdeployment" folder.

19) Uncomment the variable "as_service_name".

20) Assign the following values to the respective variables:

  • as_dir=<installation directory of Tomcat 6>
  • as_instance=localhost
  • as_service_name=Tomcat6

21) The file should look something like this:

##

## Business Objects Configuration Utility

##

# as_dir: the installation directory of the application server

as_dir=C:Program FilesApache Software FoundationTomcat 6.0

# as_instance: the application server instance to deploy to (represents the name of a folder in the conf/Catalina directory)

as_instance=localhost

# as_service_name: on windows, the name of the tomcat service when tomcat is installed as a service

as_service_name=Tomcat6

# as_service_key: on windows, when tomcat is installed as a service, the name of the key where the java startup parameters are stored

# (there is generally no need to touch this)

as_service_key=HKLMSOFTWAREApache Software FoundationProcrun 2.0${as_service_name}ParametersJava

# as_service_key_value: name of the String value where the java startup parameters are stored, in the key pointed to by as_service_key

# (there is generally no need to touch this)

as_service_key_value=Options

22) Save & close the file.

23) Open the file tomcat6.xml in Notepad. It can be located in "C:Program FilesBusiness Objectsdeployment" folder.

24) Make sure that the file has the correct path to the Tomcat6.0.x executable. This path is the one where Apache Tomcat was installed.

<exec dir="${as_dir}/bin" executable="${as_dir}/bin/Tomcat6.0.36.exe" failonerror="false">

25) Assign the right value to the respective variable in case it does not have it.

26) Save & close the file.

27) In the “C:Program FilesApache Software FoundationTomcat 6.0conf” directory create a folder called Catalina. Within the Catalina folder create another folder called localhost

“C:Program FilesApache Software FoundationTomcat 6.0confCatalinalocalhost”

28) Open Command Prompt (Always as Administrator) by clicking Start, Run, type "cmd" and click OK.

29) Change the deployment directory within the SAP BusinessObjects installation path you installed to ("C:Program FilesBusiness Objectsdeployment").

30) Run the command "wdeploy tomcat6 deployall".

31) A BUILD SUCCESSFUL message will appear once deployment of all WAR files is successful. If not, you need to review the failures and correct as needed.

32) Apache Tomcat 6.0.x is now deployed to and configured for usage with SAP BusinessObjects Enterprise XI 3.1 SP3.

33) You can now use the Windows Services management tool or the Tomcat Configuration tool to set Tomcat to automatically start on system boot if you wish.

With this easy guide for the upgrade you should be all set for your installation. We hope that this helps you make a fast transition for your applications by closing the security risk.

If you have any questions or anything to add to help improve this post, please feel free to leave your comments.

Managing ETL dependencies with BusinessObjects Data Services (Part 1)

Are you satisfied with the way you currently manage the dependencies in your ETL? Dependencies between jobs (or parts of jobs) are an important aspect of the ETL management. It pertains to questions like: Do you want to execute job B if job A failed? Imagine that you have a job C with sub-job 1 (usual runtime: 3 hours) and sub-job 2 (usual runtime: 2 minutes). If sub-job 1 was successful and sub-job 2 failed, can you gracefully restart job C without the sub-job 1 being restarted again?

As soon as you have more than 1 simple job, you have to manage your dependencies. In this article (part 1 of a series of articles about ETL Dependencies Management) I’ll first list some of the characteristics I’m looking for in an ideal dependency management system. I will then have a look at some of the possibilities offered by SAP Data Services 4. In part 2 (my next post), I will propose the architecture of a possible dependency management system. In part 3, I will go into the details of the implementation in Data Services. I’ll finish with part 4 by telling you about how the implementation went, and if some improvements are possible.

The ideal dependency management system

In this post I will use the word “process” to design a series of ETL operations that have a meaning together. Example: extract a source table, create a dimension, or update a fact table. The objective here is to manage the dependencies between the processes: updating a fact table should probably only be allowed if updating the corresponding dimensions was successful.

A dependency management system should ideally have at least the following characteristics:

  • Run a process only if its prerequisites ran correctly
  • After a failure, offer the option to re-run all the processes or only the processes which failed
  • Trace the outcome of each process (ran successfully, failed, did not run)
  • Run dependent processes dynamically (rather than statically, i.e. based on date/time)

The possibilities

Let’s enumerate some of the possibilities offered by Data Services, with their respective pros and cons.

1) One job with all processes inside. This is very easy to implement, dynamic in terms of run times, but it doesn’t allow for concurrent runs. Most importantly, it means that failures have to be managed so that the failure of one process does not stop the whole job.

2) One process per job, with jobs scheduled at specific times. This is very easy to implement, allows concurrent runs, but is not dynamic enough. If the process durations increase with the months/years, jobs may overlap.

3) One main job calling other jobs (for example with execution commands or Web Services).

4) One process per job, all the jobs being scheduled at specific times, but checking in a control table if the pre-requisites ran fine. Otherwise they just sleep for some time before checking again.

5) Use the BOE Scheduler to manage jobs based on events (how-to is well described on the SCN). I’ve not tested it yet, but I like this approach.

By default, the first two possibilities only manage the “flow” side of the dependency management (after A, do B). But they do not manage the conditional side of the dependency management (do B only if A was successful). In both cases, a control table updated by SQL scripts would allow the ETL to check if the prerequisite processes have been run correctly.

What I don’t really like in the solutions 2 to 5 is the fact that it’s difficult to have an overview of what’s going on. You cannot really navigate within the whole ETL easily. The solution 1 gives you this overview, but at the cost of having a potentially huge job (without the possibility of processes running concurrently).

Also note that the solutions with multiple jobs will need to manage the initialization of the global variables.

What I miss in all these solutions is an optimal re-start of the ETL. If 10 of my 50 processes failed, and I want to restart these 10 only, do I really have to start them manually?

In my next blog post I’ll propose an architecture that addresses this optimal restart.

Until then, please let me know your thoughts about how you manage your ETL dependencies. Any of the 5 solutions mentioned before? A mix? Something else? And how well does it work for you.