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 […]
Category: SAP BW/BIBO
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 […]
How to Transform Data Your Existing BEx Query for Your Complex Reporting
SAP BW Tutorial – BEx Queries in SAP BW have a lot of logic and business rules, some reporting scenarios may require you to leverage your business rule of existing BEx queries and transform your BEx Queries to meet your requirement, for example the BEx queries has restricted and calculated key figures. Normally you must […]
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. […]
How to delete SAP BW Statistic Log to Increase Statistic Query Performance
In SAP BW Statistics allow you to record runtime data in SAP BW process and events in data warehouse functionality, this process will records performance step process, it will calculate differences start time and end times of SAP BW Processing. But query runtime statistic generate large amount of data, so its recommended to delete the […]