Direct Data Access DTP – SAP Remote Cube or Virtual InfoCube

This post is just for demonstrating the use of virtual infocubes and direct access DTPs as these are not used so frequently while modeling.

There is no data acquisition and the BI system connects remotely to the source when the query is called by the user. This is particularly useful where very less data need to be retrieved and it changes frequently.

There is also a concept of using Open ODS views if your BW system is based in HANA, where there is a similar access to source tables directly and queries are based on the source fields. Continue reading →

SAP Netweaver BI Accelerator



BI Accelerator is a separate server which runs on TREX (Text Retrieval Extraction). The BI-Accelerator is a an addition to SAP BW 7 version and is now becoming obsolete with the advent of HANA.

BIA serves the purpose of putting some of the data in the memory whereas HANA puts all the data in memory.

Many companies have opted for BIA when it was launched and it has given impressive performance with typical improvement factors between 10 and 100.

Long running Sales/AR/Finance queries have improved drastically when the cubes on which they are based are indexed on BIA. Continue reading →

How to create tables in SAP System-I

There are three ways to create a table in SAP-

  1. Using Built in type or pre-defined type
  2. Using top-down approach (Table, Table properties, fields, data elements, domains, check fields, currency fields, technical settings,…)
  3. Using bottom-up approach (data, domains, data elements, table, table properties, fields with data element assignments, technical settings)

Creation of table:

Master data table creation using built-in type/pre-defined type-

Structure of the table

Continue reading →

How to write ABAP routine to look up a DSO Active table

Looking up a table while doing data load is a common scenario in SAP BW.

Here the look up table can be active table of some other DSO.

You can note a point here that cube cannot be used for look up. This is because, a cube has a fact table which is based on star schema. Hence the primary keys in a fact table will be dimension ids instead of the primary key values.

Now coming to our scenario, suppose data is loaded from DSO1 to CUBE1. Continue reading →

What are OEE reports in BW/BI?

OEE stands for ‘Overall Equipment Efficiency‘. These reports are required in manufacturing companies to track the machine efficiency and performance in terms of quality and availability.

The efficiency is measured per line (machine) or per material.

OEE calculation has three different metrics: availability, performance and quality.

Generally, OEE is reviewed on a weekly basis as KPI.

Most important, OEE is used to analyze the reason of Continue reading →

HR reports in BW/BI

Below are some of the HR reports used in BW/BI. These will help you to understand what kind of reports companies want out of their HR data-

Report Name – 

Headcount / FTE Report

Report Description-

This report is used to count Continue reading →

What is Material Master Data report in BW/BI?

The companies mainly in the manufacturing business require to see the material master data of their inventory stock after the sales and delivery is done for a period.

These reports mainly show the details of a material produced by the company like Continue reading →

What is Planning efficiency report in BW/BI?

The plan efficiency reports are needed plant wise, material wise to measure the efficiency of the planning. These are global reports whilst the information need to be collected at factory level. These reports will help a company to Continue reading →

How to give conditions in a BEx query designer

The query designer formulas sometimes involve if then else kind of conditions or case statement type of logic. These type of logic can be easily given in the query designer, however the procedure is little tricky as you cannot Continue reading →

Process chain error due to # character in the file

While loading flat files on application server to BW targets via a process chain, the load to PSA may fail due to special characters in the file.

Thus the info package step itself will fail with Continue reading →