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

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