Compatible and Incompatible objects in Business Objects

In Web Intelligence or Desktop Reporting client sometimes it is not possible to use certain combinations of objects in data providers. These objects are called incompatible objects.
For example, Let’s say you have two contexts in your universe. Sales and Revenue and if you are trying to pull < Reservation Year > and < Revenue > objects from univese then you should not because they are incompatible as no revenue associated with a reservation. Read more

Reporting on SAP HANA

SAP HANA provides various interface reporting options

ODBO – (OLE DB for OLAP)
Requests are sent to the database via MDX (MultiDimensional eXpression language). Multidimensional reporting is available via Excel Pivot Tables. HANA ODBO drivers is available via the Other/Advanced option of the Data Connection Wizard.

ODBC – (Open DataBase Connectivity)
Requests are sent to the database via SQL (Structured Query Language). In early testing, Excel was *not* a good choice
for ODBC-based reporting since ODBC reporting is based
on MSQuery which has a limitation of 4,000 tables.

JDBC – (Java DataBase Connectivity)
Popular on Unix platforms Read more

SAP HANA Hierarchies

In SAP HANA we have 2 types of Hierarchy

1. Level Hierarchy
It’s rigid in nature, where the root and the child nodes can be accessed only in the defined order (ex: organizational sturctures)
To define a level hierarchy we need one attribute per hierarchy level.

2. Parent/Child Hierarchy
The hierarchy can be explored based on a selected parent, and there are cases where the child can be a parent. Read more

SAP HANA Replication and SLT (SAP Landscape Transformation) Replication

SAP In-Memory database requires the replication of data from a source system. There are three methods of data replication from source system to SAP IMDB.

Trigger-Based Replication
If your source is ERP system then SAP recomments using SAP Landscape Transformation (SLT) Replcator. Source can also be non-SAP system. As name suggests it updates HANA system using database triggers.

While connecting to SAP source system Replication Server uses remote function call (RFC) network communication channels and for non-SAP source system it uses database connection. SAP HANA system and SAP LT Replication Server uses database connection for communication. Read more

How to link two universe in BO

You can use any the following approaches when linking universes:

– Kernel approach
Kernel is a German word. It means nucleus, core component or main component. As name suggests using Kernel approach core universe has all the common components and then derived universe will inherit all the core components and it will also have their own universe specific components.

Core Universe will have common data (ex: employee information) which can be used in all derived universes. Read more

Linked Universes in Business Objects Universe Designer

You can link one or more universes which share common components such as objects, classes, joins and parameters. The univers which you link become core universe and the universe which contains a link to core universe is called derived universe. Any change made in core universe automatically propogated to the derived universe(s).

There are different ways you can link universes.
– Kernel approach
– Master approach
– Component approach Read more