DW - Data Warehousing & Modeling

Debugging ABAP routine Performance in SAP Business Warehouse

afbeelding van Dirk Francis

Introduction

When building a data warehouse with SAP Business Warehouse (SAP BW), data often needs to be manipulated, transformed or enriched. Sometimes this can be implemented using standard master data lookups or formulas (although this is often suboptimal from a performance point to view), but when the logic of business rules become complex and standard out-of-the-box or drag and drop BW functionalities cannot meet the requirements, ABAP routines are usually the solution.

14 Nov 2011 Monday
SQL Server Day has become a household name as the "place to be" for all Belgian SQL Server Specialists over the last few years. The SQL User Group-team decided to switch to a 2-day event for the 2011 edition. element61 -once more- is a proud sponsor...
23 Jun 2011 Thursday
On Thursday 23rd June 2011 the Community Day will celebrate its first jubilee : this 5th edition will take place in the beautifully renovated venue of Utopolis, Mechelen.
26 Apr 2011 Tuesday
On 26, 27 & 28 April 2011, Microsoft TechDays 2011 are taking place at Metropolis Antwerp - the biggest technical event in Belgium & Luxembourg exclusively dedicated to Microsoft IT professionals, developers and architects. This will be the...

How to load and generate a custom hierarchy in SAP Business Warehouse (SAP BW)

afbeelding van Dirk Francis

Introduction

Often reports need to show data in a tree-like structure. This is enabled via characteristic hierarchies in SAP BW. High level data is displayed using the top nodes of the hierarchy. More detailed data can be visualized by drilling down to the lower nodes of the hierarchy.

Consider an example hierarchy Customer Contacts Hierarchy' that is used to qualify the telephone calls a telecommunications call center receives.
 

Pagina's

Abonneren op RSS - DW - Data Warehousing & Modeling