Whats new in BOBJ BI 4.2

As SAP announced 4.2 in late Q1 2016, I would like outline promising/key new features that are part of release (subjected to change) . here are the some of the features which I found interesting

BI Platform

User Notifications – Administrators can now broadcast a notification to the BI users (can be particular group) . This will ease the communication of system maintenance.

Recycle Bin – This is a great idea, administrators no longer need to worry on restoring from backup, a simple restore from recycle bin will do the work.

Administrator cockpit – A visual page with all the key required information ( servers, Jobs, users, applications ) .

Promotion manager – selective retrieval of objects, this is a great feature ( Traditional import/Export wizard had this though J) . This will avoid restoring the entire system , administrators can create a promotion Job with whole content on daily basis and retrieve particular in case of deletion )

Audit – audit reports/universe will be now packaged with installation.

Tomcat 8 and MSQLA– Tomcat 8 will be the default web application server and my SQL anywhere is default CMS/Audit DB

Installation – Install is now in 2 parts Pre-caching and Post- caching. Pre caching can be down background via CLE which doesn’t require any downtime. This will significantly reduce the downtime for upgrades.


Web intelligence

Parallel queries – Queries now run parallel at DB which will effectivelty improve the response time, if the report has more than one query , The number of concurrent job can be configured via XMl file on server. This feature is supported on UNV, UNX, SAP HANA

Commentary – Comments of reports in web I

Shared Elements – Export the report meta data as shared element which can be re-used, this will simplify the web I report creation.

Charts – geo maps, Lumira extensions are part of Web i


Linked Universes – Linked universes will be back in 4.2

Bex Unx – Authored UNX universes on bex ( Just like 3.1 UNV)


Please follow the below link, for complete list of detailed features


-Karthik Addula


Consuming BW function modules in IDT

Starting 4.0 SAP introduced new Jco connecters to connect BW datamodels directly, this is more like connection to RDBMS but the data foundation is pre authored. However, through the standard BW Jco connection, IDT can connect to Cubes, DSo’s , Infoobjects, Multi providers , Infosets and Infoobjects.

In reality, there may be a requirement where we will need to extract data from the tables directly. the bookish way would be create a self system datasource and create a datamodel. This post explains how to access function modules easily by leveraging ERP connectors.

How to Access BW Function Modules in BOBJ

Part 1 – Creating Connection

Create ERP connection to BW box

Step 1- Function module


Give a name to connection

Step 2- Function module


Select SAP ERP drivers from the list ( NOT SAP NETWEAVER BW)

Step 3- Function module


Enter the parameters ( SSO supported) . Click Finish

Step 4- Function module


Creating a Data foundation layer

Create the connection shortcut to local project

Create a Data foundation layer ( Both Multi/single source supported)

P2 Step 2- Function module


Give the name and click Next

Select the Foundation type

P2 Step 4- Function module


Select the connection click finish

P2 Step 5- Function module


Step 6) In the data foundation panel under connection , all the Info sets and function modules are now accessible ( Function Module should be RFC enabled)

P2 Step 6- Function module


Create a Business Layer over the Data foundation and consume it in all supported reporting tools

-Karthik Addula

Converting netweaver Analysis workbook to use BOBJ platform

Requirement – Converting Analysis for office workbook based of netweaver platform to use BOBJ platform.

By default, converting Bex workbook into analysis office uses netweaver connection, which means the workbook needs to be saved to ABAP server, limited broadcasting functionality and also it will be specific to one BW server ( For instance, if you want to have workbook with combined data from BW and hana in multiple tabs it is not possible)

This post explains the step by step procedure on how to change the bex workbook to use BOBJ BICS connection

First, converting the Bex workbook

Launch Analysis office. (TCODE RSAAOE) , Click File>Analysis>Convert Bex workbook


Select the workbook to be converted.

Step 2- AAO conversion


Click Ok, it automatically converts the workbook into AAO workbook

Step 3- AAO conversion


Save the work book ( save to BOBJ platform)

Step 4- AAO conversion


Second,  Accessing the workbook

Open the workbook from BOBJ Platform

try to refresh the work book

The workbook will prompt for BW credentials, even though single sign on is activated in BOBJ.  ( please sign in manually)


Third, Converting the workbook

Open the work book

Refresh by manually entering the BW password

Click on components in design panel and click edit data source name



The olap connection box will pop-up ( as you already authenticated to BOBJ platform in Part 2 , step 1)

Select the Desired OLAP BICS connection

Select the the same bex query the workbook is using.

Now the workbook is successfully changed, you can now refresh the workbook via BOCS connection and also schedule the workbook through BOBJ Scheduler ( 4.1 sp4 and higher, need AAO add-on to be installed on server)

– Karthik Addula