How to know the Query Usage Statistics in BW

The number of times users have seen the BI reports can be analyzed in BW. All of this information is recorded as BW statistics automatically by the system provided the setting is activated for the targets.

The data where the information is stored is the cube 0TCT_C01 [Front-End and OLAP Statistics (Aggregated)].

This cube is SAP standard cube and holds the usage statistics data. This comes under Technical Content info area in BW.

The main info objects in the cube and their functions / meanings are summarized below- Continue reading →

Sales Order Status not updating in BW system with BWA

The sales order status should appear correctly in the BI reports after the daily refresh.

Otherwise the order qty will appear for example under both open and billed and the total order qty will hence show doubled in the sales report.Or, it may happen that the processed orders are not shown in the report.

You will encounter many tickets in SAP BW relating to order status issues. Mostly the tickets will be high priority (either P1 or P2)

In my experience, I have encountered a scenario where order status is a time independent navigational attribute of sales document.

Thus order status was a part of sales order master data.

Technically, status was residing in ‘X’ table of the info object sales order in the back-end BW database.

The business scenario was like below-

  • There was a process chain updating the master data of the sales order and rolling these values to BW accelerator.
  • Then, the delivery and billing transaction process chains were running. This transaction data was also loaded to BW accelerator.
  • When the BI reports were run, the order status shown was not correct or the processed orders were not shown at all in the report.

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 →

When to use Navigational Attribute in SAP BW

Navigational attributes are discussed a lot of times in BW. They have an advantage as these attributes can be used for navigation in a query. However there are lot many more advantages of navigational attributes. I will discuss today one such scenario where navigational attributes has saved a week’s time. Continue reading →