Implementing Date and Time as Key Figures in SAP BW

SAP BW Tutorial – 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 […]

Read More

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 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

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 use Analysis Process Designer ( APD ) as Data Modelling Object

You may meet complex business reporting requirement and it is also required complex modelling scenarios in SAP Netweaver BW. Typically modelling some of these complex scenarios would require creating multiple layers of DSO, Writing code in the transformation to manage complex relationship within the data. These old approaches could ver difficult to implement and support. […]

Read More

How to use Analytic Index as Data Provider

You can use the analytic index as a data provider with data saved in SAP HANA database for quick and flexible reporting and prototyping on which you can also build queries. One requirement SAP Netweaver BW users is to create quick prototypes of data and develop ad hoc reporting purposes, BW Modelling requires a lot […]

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