SAP BW Development

The reporting, analysis, and interpretation of business data is of central importance to a company in guaranteeing its competitive edge, optimizing processes, and enabling it to react quickly and in line with the market.

As a core component of SAP NetWeaver, the SAP Business Information Warehouse (SAP BW) provides data warehousing functionality, a business intelligence platform, and a suite of business intelligence tools that enable businesses to attain these goals.

Relevant business information from productive SAP applications and all external data sources can be integrated, transformed, and consolidated in SAP BW with the toolset provided.

SAP BW provides flexible reporting and analysis tools to support you in evaluating and interpreting data, as well as facilitating its distribution. Businesses are able to make well-founded decisions and determine target-orientated activities on the basis of this analysis.

The following graphic shows how the SAP BW concept is structured. Data Warehousing, BI Platform and BI Suite represent the core areas of SAP BW.



The following graphic shows where SAP BW is positioned within SAP NetWeaver. Furthermore, those subareas that incorporate SAP BW are listed. These are described in detail below.

Data Warehousing with SAP BW forms the basis of an extensive business intelligence solution to convert data into valuable information. 

Integrated and company-specific data warehousing provides decision makers in your company information and knowledge for goal-oriented measures that will lead to the success of the company

For data from any source (SAP or non-SAP sources) and of any age (historic or current), Data Warehousing with SAP BW allows:

  • Integration (data retrieval from source systems) 
  • Transformation
  • Consolidation
  • Cleanup
  • Storage
  • Retrieval for analysis and interpretation


 The central tool for data warehousing tasks in SAP BW is the Administrator Workbench. 


Comments

Post a Comment

Popular posts from this blog

SAP Datasphere Data Integration - Part 1 - Introduction and Integration using Remote Tables

Image
SAP Datasphere provides a large set of default connections to access data from a wide range of sources, source from SAP as well as non-SAP sources or partner tools, residing in an cloud as well as on-premise environment. Connections are defined in a separate view which can be found in the main navigation window of the left. Connections are individual objects in SAP Datasphere. They are created and maintained per SAP Datasphere Space which means only members of a specific Space are able to make use of the related connections. These connections can be then be used within the different tools (like SQL View Builder, Graphical View Builder or Data Flow) for creating your data models. SAP Datasphere can integrate with both SAP or Non-SAP Source systems and it can be either cloud or on-premise. We have multiple connection types in SAP Datasphere. Each connection type supports a defined set of features. Depending on the connection type and the connection configuration, a connection can be used...
Read more

SAP Datasphere - Data Integration - Part 2 - Data Integration based on Data Flows and External Sources

Image
Data Integration based on Data Flows: A Data Flow is used as per SAP Definition “to move and transform data in an intuitive graphical interface”. The Data Flow is created within the part of the Data Builder in SAP Datasphere, and it currently supports the following operators to be used within your transformation process:  Join Operator  Union Operator  Projection Operator  Aggregation Operator  Script Operator  As we are coming from a strong Business Warehouse background, we are always comparing things to the past. Which in our case would be a classical SAP BW on HANA or SAP BW/4HANA. We currently see the Data Flow as a substitute for what used to be in a BW system the transformation.   In the data flows, we will be able to use a series of standard transformations without the need of programming knowledge and in a graphic way, but we also have the possibility of creating transformations based on scripts. In a data flow, we will use views or tables...
Read more

SAP Datasphere - Data Builder types and creation of Tables

Image
 There are different artifacts available in the Data Builder as below. Table Graphical View SQL View Entity-Relationship model Analytic model Data Flow Replication Flow Transformation Flow Intelligent Lookup Task Chain Now lets discuss on them in detail. Tables: Column structure of the tables can be defined either manually or by using the existing data as template. These are going to get the information from different source systems like flat file / sap / non-sap and can be filled with data from a CSV file or via a data flow. While creating a table we can define the following: Technical and Business names Data Type Semantic Usage Label Column Primary Keys Default values  can be/not null Visibility of the columns We can also delete current data and upload new data from files and share the current table with other spaces. Hierarchies could be created and the generated CSN annotations could be edited in order to make it synchronize with the expecting changes. Lets discuss th...
Read more