How to restore BEx Query from version 7.x to 3.x

In SAP Netweaver BW environment where 7.x and 3.x queries exist. a common issue is the conversion of 3.x queries to the 7.x version. For example if you’re changing a 3.x query, and one of the 7.x queries features that is not available the query will be saved as 7.x version. This tip will show […]




Read More

How to convert Standard Infocubes to SAP HANA Optimized Infocubes

When you migrated SAP Netweaver BW System to SAP HANA database, All infocubes are not automatically converted to SAP HANA optimized infocubes. The conversion of standard infocubes to SAP HANA optmized infocubes ensures that the cubes are set up most efficiently for SAP HANA in memory optimizer. If you are using SAP HANA database it’s […]




Read More

How to use remodeling rules to change structure of an Infocube

This is common requirement to change structure of infocube with data content, but SAP Netweaver BW 7.0 have new feature called remodeling. it’s efficient and solves the issue of changing the structure of the infocube even in production environment without any data loss. This example you want to delete a key figure from an infocube […]




Read More

How to modelling planning scenario on direct update datastore objects ( DSO ) in SAP BW

Integrated planning is used for modelling planning scenario in SAP Netweaver BW. Currently Integrated Planning Data comes from InfoProviders that contain real-time Infocubes. However there are some system and performance drawback using real-time infoproviders, such as reduced read-only performance. and implementing real-time Infocubes with complex dimension, fact and attributes could occurred performance impact. With SAP […]




Read More

Implementing Date and Time as Key Figures in SAP BW

Typically, SAP Netweaver BW Systems, the date and time fields are modeled using standard Info Objects 0DATE and 0TIME, those infoObjects are treated as characteristics, but some reporting scenarios require calculations based on date and time fields, but the problem is 0DATE and 0TIME characteristics do not provide that kind of functionality. You can implement […]




Read More

How to Create Sample Data for Infocube Testing

Lack of quality test data in development environment of the source systems is a persisten problem in the most SAP Netweaver Business Warehouse ( SAP BW ). Even if some data is available in the source system, but this limitation testing data could produce the limited testing and its problem could increase the recycling of […]




Read More

How to know which queries are used in a Workbook SAP BW Reporting

In SAP BW you able to create a workbook with one or more queries, After you’ve created or sometime during maintenance your workbook, you might need to get a list of queries that were used to build that workbook. You can use transaction RRMX_WORKBOOK_QUERIES_GET to find out which queries are used in workbook. How to […]




Read More