Sapiex Fountain Architecture

Architecture Design Objectives

The proper design of an SAP-BW architecture must accomplish several key goals:

  • Reduction in redundancy of data across the system

  • Optimization of data load & activation processes

  • Performance improvements in data load and query

  • Improvement in BW data access security controls & maintenance

  • Increased leveraging of BW data objects for multiple uses by multiple audiences

  • Facilitation of both global and regional reporting at both corporate and business unit/platform levels

Delivering on Design

The Sapiex Fountain Architecture design for BW leverages what is widely considered a data warehousing best practice – the use of a ‘vanilla’ data warehouse layer that receives data with minimal modification from source systems (or from ETL environment).

This data is non-reportable, and intended to stage data for use in various Cubes and ODS Objects, as defined by corporate and business-specific requirements.

Note: the objective is to create leveragability of BW objects, wherever possible, rather than creating multiple business or corporate versions of the same objects.

Critical Planning Elements

Before actually building anything in the BW environment, it is critically important to plan and prepare:

  1. Define an achievable initial scope

  2. Research and integrate master data needs into a plan for the development of a rationalized, leveraged master data architecture

  3. Determine all data relationships within procedural flows, and between different sources of data

  4. Collect, understand and integrate all reporting requirements into base architecture data requirements

Please contact us for more information about the Sapiex Fountain Architecture, the implementation concepts and methodology.


Click on the picture(s) to view it full size and navigate to others.


From a well-planned source springs a fountain of information.