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