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

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

SAP BW Data Sources User Exit RSAP0001

Generic extractors or data sources enable you to extract data from the source system that isn’t provided via standard extractor . To create a generic extractor you can use transaction RSO2 which allows for the creation, modification and display generc datasources. In this article we try to explain What, How to use User Exit RSAP0001 […]




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