SAP BusinessObjects Dashboards 4.0 Cookbook

Packt Publishing has released SAP BusinessObjects Dashboards 4.0 Cookbook and I am pleased to receive an eBook edition to review. Xcelsius 2008 was recently included in SAP’s BusinessObjects 4.0 family, rebranding “Xcelsius Enterprise” as "SAP BusinessObjects Dashboards 4.0". Two of the top experts in SAP BusinessObjects Dashboards, David Lai(@davidlai101) and Xavier Hacking(@xjhacking), documented their knowledge in this book.

I plan to read the cookbook over the next two weeks and write a detailed review. This is going to be interesting! 

List of Values(LoVs) caching in BO XI 3.1 SP3

Recently, I came across a weird behavior while working with BusinessObjects Web Intelligence. I have divisional hierarchy in the prompts for all the WebI reports. Now, inspite of having SSO as authentication mode for the universe connection, the LoVs were getting cached!! As a result, the users were able to see the divisional hierarchy nodes which they don't have access to.

It was a security nightmare. Alright, it was not that bad. Though users were able see and select the nodes, they were getting authorization error message. The users had to use 'Refresh values' option in the prompt window to get the correct LoVs. While technically good, it was not a very pleasant user experience.

This is a bug in BusinessObjects XI 3.1 SP3. By design, when SSO is defined as universe connection mode, the LoVs should not be cached. This was discovered only recently because it turned out that entire BO community had BI_ALL. I will not dwell much onto that but not sure why everyone had this super privilege. When we started removing BI_ALL, the issue surfaced.

We raised OSS with SAP. They acknowledged it as a bug and suggested to apply FP 3.2/FP 3.6 or even upgrade to SP4. They released a note 1519503 on this.

Here is the interesting part. We had a call on 06/22/2011 with BO support team on this and they acknowledged the issue as a product bug. Immediately after the call, SAP released the note :).

SAP BI Quality Dashboard architecture

Deploying SAP Dashboard (formerly Xcelsius) - Crossdomain policy file

Cross domain policy file is an important configuration to consider while deploying SAP Dashboard(formerly Xcelsius). The SAP BW Quality dashboard, that I recently worked on, is deployed on the BusinessObjects Infoview and  pulls data from SAP ECC and SAP BW for reconciling Orders and Revenue numbers. The flash object that Xcelsius creates run in the browser on the client machine. It follows the security guidelines set by Adobe while accessing external data.

Adobe has introduced a new security policy for the flash palyer 9 & 10. That prevents the Xcelsius dashboard from accessing data from external sources and throws error #2170. In my case, external sources are ECC and BW. To get around this, the cross domain XML file needs to be updated with the following tag:

<allow-http-request-headers-from domain="*" headers="*" secure="false" />

The crossdomain.xml is located at <BusinessObjects installation directory>\Tomcat55\webapps\ROOT\ and should look like this-

<?xml version="1.0"?>
<!DOCTYPE cross-domain-policy SYSTEM "http://www.macromedia.com/xml/dtds/cross-domain-policy.dtd">
<cross-domain-policy>
   <allow-http-request-headers-from domain="*" headers="*" secure="false" />
   <allow-access-from domain="*" secure="false" />
</cross-domain-policy>

Update the file, restart Tomcat (web server) and you're done!

Deploying SAP Dashboard (formerly Xcelsius) - OpenDocument settings

Recently, I developed Xcelsius based dashboard for SAP BW Quality. Purpose of the dashboard is to provide the users with real time information of BW data loads, display ECC and BW values reconciliation and smart alerts based on business processes. The dashboard is published to BusinessObjects Infoview.

As part of the requirements,  business needed a direct URL to the dashboard such that the users are presented with the dashboard directly upon login. I published an OpenDocument URL for the dashboard. However, there is a setting for authentication type in the web.xml within the path . This setting determines the default authenticate type to be used. Also, the same web.xml has a setting whether to allow users to change the authentication type (for example SAP, Enterprise, etc.) 

<!-- You can specify the default Authentication types here -->
<!-- secEnterprise, secLDAP, secWinAD, secSAPR3 -->
<context-param>
    <param-name>opendoc.authentication.default</param-name>
    <param-value>secSAPR3</param-value>
</context-param>

 <!-- Choose whether to let the user change the authentication type -->
<!-- If it isn't shown the default authentication type from above will be used -->
<context-param>
<param-name>opendoc.authentication.visible</param-name>
<param-value>false</param-value>
</context-param>

We give out Enterprise IDs to end users. On the server side, these IDs are mapped to their SAP BW credentials. Strangely, the default authentication was set to 'SAP' instead of 'Enterprise'. I suspect 'SAP integration kit' as a culprit.

I updated the web.xml as follows:

<!-- You can specify the default Authentication types here -->
<!-- secEnterprise, secLDAP, secWinAD, secSAPR3 -->
<context-param>
<param-name>opendoc.authentication.default</param-name>
<param-value>secEnterprise</param-value>
</context-param>

Restarted the web server (tomcat) and change was in place. I did not change the setting for selecting authentication type as that could have been confusing for the users.

SAP BusinessObjects Explorer on iPhone

Today, I came across an iPhone/iPad app for SAP BusinessObjects Explorer. It's available for free in iTunes. I decided to give it a shot on my iPhone and ended up liking it :).

It's just 1.9 MB in size and fast to launch unlike some of the other iPhone apps. It is preconfigured with three sample data sets being pulled from the SAP's demo server.

Please note that you will need an internet connection as there is no data available off-line on this app.

Now, let me take you through a series of screenshots to demonstrate how this app works.

Selecting one of the sample data sets.

A bar graph showing revenue by year.

In the above screenshot, following 5 options are available.

Option 1 - Tabular view
Option 2 - Top "n" records
Option 3 - Chart type (Vertical & horizontal bar charts, Radar chart, Pie chart, Line chart, Surface chart, Cloud chart and treemap chart.)
Option 4 - Add favorites
Option 5 - Email feature


A pie chart for revenue bye year and sending the same over an e-mail.

E-mail page.

Filtering the data only for years 2004, 2005 and 2006.

Pie chart only for years 2004, 2005 and 2006.

Drill down on year 2006 to get numbers by the quarters.

Revenue by quarter after drill down.

Search feature - Free text search on the data sets.

In addition, it can also fetch data sets/visualization from SAP BI OnDemand. I have my free Personal Edition account on http://bi.ondemand.com as mentioned in my earlier post. I pointed the app to my account and was able to download the data sets and visualization on the iPhone.

My sample data sets from BI OnDemand account.

Bar chart

Cloud chart.

The missing feature - support for portrait mode.  I think it should have been standard for BI apps. 

However, I think it's a great step by SAP towards its journey to On-Device. As iPhone is increasingly adopted in the enterprises and Sybase now in SAP's kitty, we can expect more such apps from SAP.

SAP SDN link - http://www.sdn.sap.com/irj/boc/innovation-center?rid=/webcontent/uuid/706569f0-989c-2c10-5ca4-e945dc3368e3

Hands on with SAP BI OnDemand

SAP BusinessObjects BI OnDemand is a cloud based offering of BI solutions. I have mentioned about this in my earlier post. Today, just to get familiar, I tried few things.  I signed up for the BI OnDemand Personal Edition which is free.

I created data sets by uploading couple of spreadsheets viz. Customer_Data and Customers_Reservations.

Once data sets were available, I could explore the data using SAP BusinessObjects Explorer. See the below screenshot.

Visualizations can be created by a single click from the Explorer window.

Finally, I put my demo visualizations on a single dashboard.

SAP RIG event takeaways - SAP BOE XIR4 (aka Aurora), BI on-demand & SAP On-Device

Today, I attended SAP RIG(Regional Implementation Group) customer appreciation event held here at Mumbai. I would like to share some key takeaways from it.

Aurora is here !!  Aurora is SAP internal project code for SAP BOE(BusinessObjects Enterprise) XIR4 and will be released in q4 FY 2010. It is a next major release for BOE.

Following are some of the interesting additions/changes in BOE XIR4 release -

(1) Central auditing - Yes, it's here. Auditing of individual servers won't be required going forward.

(2) Search 

 - Searches Explorer contents in addition to BOE contents

 - Document and metadata search

 - Cluster aware indexing

 - Near real time & scheduled indexing

 - Public SDK

 - Open Search support

 - Integration with SAP Netweaver search, Google Appliance and Sharepoint

(3) Integration with Solution Manager.

(4) WebI is renamed to Interactive Analysis. Infoview with improved UI is now called BI LaunchPad. Import wizard is replaced with Java based utility called Upgrade Manager.

In addition, they talked about their SaaS offering BI on-demand. SAP has hosted(i.e. in cloud) all BusinessObjects BI solutions on their servers in US. All these solutions are offered on demand and follow SaaS model. They are planning to come up with BI on-demand servers in Japan as well.

BI on-demand can be integrated with other SaaS platforms like Salesforce.com. Data is extracted from Salesforce and stored in BI on-demand for reporting/dashboarding purpose.

I signed up for the Personal Edition which is free. UI looks neat. Refer the screenshot below.

 I plan to try it out soon to see how it works :).


Also, SAP India MD Peter Gartenberg introduced their new focus area On-Device. Like On-Premise and On-Demand, On-Device is SAP's one of the most important focus areas. Idea is to make all SAP solutions compatible with the mobile devices like BlackBerry, iPhone, iPad, Windows Mobile, Android, etc.


Finally, the event was held at Sun-n-Sand hotel.

It is located right next to the Juhu beach :).

Attended BusinessObjects Information Management Services Academy, Oct 5-8 2009

This week, I attended a workshop organized by BusinessObjects Information Management Servicess Academy. It was a four days hands-on workshop with BusinessObjects consultants flying in from Australia and Singapore. There were professionals from other System Integrators as well.

The agenda for the workshop was -

• Connecting to sources
• Data Assessment
• Data Validation
• Implementing Change Data Detection
• Implementing Delta Loading
• Implementing Slowly Changing Dimension
• Working with Global Address Cleanse
• Working with Data Cleanse
• Universal Data Cleanse: Creating a Custom Parser (for custom Data Cleansing)
• Using Match
• Implementing Consolidation
• Working with Candidate Select
• Implementing Real-time (Global Cleanse and Candidate Select)

We copied a 50 GB VMware image of Windows 2003 server on our laptops. It had all the necessary software and data. So setup was not complicated but copying 50 GB image took good amount of time.

I liked the data quality transforms that Data Services offers specially GlobalAddressCleanse transform. It basically cleans the incoming addresses are per the inbuilt address dictionary. Currently, they have address dictionaries for US, EMEA, New Zealand and Japan. Soon they are going to come up with a similar dictionary for Indian addresses.

Overall, I would say it was a good experience :) .

How To Use BusinessObjects Data Services in SAP BI staging process

Some time back I had published a wiki page on SAP SDN on how BusinessObjects Data Services platform can be used with SAP BI. The same page has been published on SAPTechnical.com. The direct links can be found below -

SDN Wiki Page

SAPTechnical.com