User:Sinha.indranil/sandbox
.png)
The enterprise resource planning (ERP) and data warehousing industries have evolved in parallel over the past decade. Now these two trends are finally converging. More and more corporations have successfully implemented SAP® or another ERP package as a transaction-processing solution. At this time SAP has brought to market software that has created a tremendous opportunity for organizations called The SAP Business Intelligence Solution. The SAP Business Intelligence Solution, which includes an Enterprise Portal with Knowledge Management and SAP Business Information Warehouse (SAP BW).
The SAP Business Intelligence Solution
[edit]SAP has bundled and rebundled its software several times during the past 2 years to maximize revenue and market share. SAP’s solution approach to selling simply means that when a solution is purchased, the necessary software components to realize the solution are delivered by SAP. For example, SAP now sells the mySAP.com® Financials Solutions. In this solution customers would receive several software components—in this case the SAP BW, the financial applications found in SAP R/3, SAP SEM, and so forth. The SAP BW software component is delivered with nearly every solution sold by SAP. In fact, at this writing, the SAP BW software component is no longer sold independent from a solution. The SAP BI solution contains the Enterprise Portal and the SAP BW components. The architecture of the Enterprise Portal and its Knowledge Management capabilities, along with the SAP BW is illustrated in Figure 1.2. Together these components create a broad foundation for organizations on which to build collaborative analytic applications.
SAP BW
[edit]Business Information Warehouse (sometimes shortened to "Business Warehouse" or BW) is a packaged, comprehensive business intelligence product centered around a data warehouse that is optimized for (but not limited to) the R/3 environment from SAP. 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 figure 1.3 shows how the SAP BW concept is structured. Data Warehousing, BI Platform and BI Suite represent the core areas of SAP BW.
Integration
[edit]The figure 1.4 shows where SAP BW is positioned within SAP NetWeaver. Furthermore, those subareas that incorporate SAP BW are listed. These are described in detail below.
Integration with Other SAP NetWeaver Components
[edit]BEx Information Broadcasting allows you to publish precalculated documents or Online links containing Business Intelligence content to SAP Enterprise Portal (SAP EP). The portal role Business Explorer illustrates the various options that are available to you when working with content from SAP BW in the Enterprise Portal. You are able to integrate content from SAP BW in SAP EP using the BEx Broadcaster, the BEx Web Application Designer, the BEx Query Designer, KM Content, the SAP Role Upload or the Portal Content Studio.The documents and metadata created in SAP BW (metadata documentation in particular) can be integrated using the repository manager in Knowledge Management in SAP Enterprise Portal. The BW Metadata Repository Manager is used within BEx Information Broadcasting. You can send data from SAP and non-SAP sources to SAP BW using SAP Exchange Infrastructure (SAP XI). In SAP BW the data is placed in the delta queue where it is available for further integration and consolidation. Data transfer using SAP XI is SOAP-based.
Integration with SAP BI Content Add-On
[edit]With SAP BI Content, SAP delivers pre-configured role and task-based information models and reporting scenarios for SAP BW that are based on consistent metadata. SAP BI Business Content offers selected roles in a company the information they need to carry out their tasks. The information models delivered cover all business areas and integrate content from almost all SAP and selected external applications.
SAP BW Subareas
[edit]| SL. No. | Area | Description |
|---|---|---|
| 1 | Data Warehousing | Data warehousing in SAP BW represents the integration, transformation, consolidation, cleanup, and storage of data. It also incorporates the extraction of data for analysis and interpretation. The data warehousing process includes data modeling, data extraction, and administration of the data warehouse management processes.
The central tool for data warehousing tasks in SAP BW is the Administrator Workbench. |
| 2 | BI Platform | The Business Intelligence platform serves as the technological infrastructure and offers various analytical technologies and functions. These include the OLAP processor, the Metadata Repository, Business Planning and Simulation, special analysis processes such as Data Mining, and the Reporting Agent. |
| 3 | BI Suite: Business Explorer | The SAP BW Business Intelligence Suite, the Business Explorer (BEx), provides flexible reporting and analysis tools for strategic analyses, operational reporting, and decision-making support within a business. These tools include query, reporting, and analysis functions. As an employee with access authorization you can evaluate past or current data on various levels of detail, and from different perspectives, not only on the Web but also in MS Excel.
You can use BEx Information Broadcasting to distribute Business Intelligence content from SAP BW by e-mail either as precalculated documents with past data, or as links with live data. You can also publish it to the Enterprise Portal. The Business Explorer allows a broad spectrum of users access to information in the SAP BW using the Enterprise Portal, the Intranet (Web application design) or mobile technologies. |
| 4 | Development technologies | · BI Java SDK
With the BI Java SDK you can create analytical applications with which you access both multidimensional (Online Analytical Processing or OLAP) and tabular (relational) data. You can also edit and display this data. BI Java Connectors, a group of four JCA-enabled (J2EE Connector Architecture) resource adapters, implement the BI Java SDK APIs and allow you to connect applications that you have created with the SDK to various data sources. · Open Analysis Interfaces The Open Analysis Interfaces make various interfaces available for connecting front-end tools from third-party providers. · Web Design API The Web design API and table interface allows you to realize highly individual scenarios and demanding applications with customer-defined interface elements. |
The enterprise resource planning (ERP) and data warehousing industries have evolved in parallel over the past decade. Now these two trends are finally converging. More and more corporations have successfully implemented SAP® or another ERP package as a transaction-processing solution. At this time SAP has brought to market software that has created a tremendous opportunity for organizations called The SAP Business Intelligence Solution. The SAP Business Intelligence Solution, which includes an Enterprise Portal with Knowledge Management and SAP Business Information Warehouse (SAP BW).
The SAP Business Intelligence Solution
[edit]SAP has bundled and rebundled its software several times during the past 2 years to maximize revenue and market share. SAP’s solution approach to selling simply means that when a solution is purchased, the necessary software components to realize the solution are delivered by SAP. For example, SAP now sells the mySAP.com® Financials Solutions. In this solution customers would receive several software components—in this case the SAP BW, the financial applications found in SAP R/3, SAP SEM, and so forth. The SAP BW software component is delivered with nearly every solution sold by SAP. In fact, at this writing, the SAP BW software component is no longer sold independent from a solution. The SAP BI solution contains the Enterprise Portal and the SAP BW components. The architecture of the Enterprise Portal and its Knowledge Management capabilities, along with the SAP BW is illustrated in Figure 1.2. Together these components create a broad foundation for organizations on which to build collaborative analytic applications.
SAP BW
[edit]Business Information Warehouse (sometimes shortened to "Business Warehouse" or BW) is a packaged, comprehensive business intelligence product centered around a data warehouse that is optimized for (but not limited to) the R/3 environment from SAP. 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 figure 1.3 shows how the SAP BW concept is structured. Data Warehousing, BI Platform and BI Suite represent the core areas of SAP BW.
Integration
[edit]The figure 1.4 shows where SAP BW is positioned within SAP NetWeaver. Furthermore, those subareas that incorporate SAP BW are listed. These are described in detail below.
Integration with Other SAP NetWeaver Components
[edit]BEx Information Broadcasting allows you to publish precalculated documents or Online links containing Business Intelligence content to SAP Enterprise Portal (SAP EP). The portal role Business Explorer illustrates the various options that are available to you when working with content from SAP BW in the Enterprise Portal. You are able to integrate content from SAP BW in SAP EP using the BEx Broadcaster, the BEx Web Application Designer, the BEx Query Designer, KM Content, the SAP Role Upload or the Portal Content Studio.The documents and metadata created in SAP BW (metadata documentation in particular) can be integrated using the repository manager in Knowledge Management in SAP Enterprise Portal. The BW Metadata Repository Manager is used within BEx Information Broadcasting. You can send data from SAP and non-SAP sources to SAP BW using SAP Exchange Infrastructure (SAP XI). In SAP BW the data is placed in the delta queue where it is available for further integration and consolidation. Data transfer using SAP XI is SOAP-based.
Integration with SAP BI Content Add-On
[edit]With SAP BI Content, SAP delivers pre-configured role and task-based information models and reporting scenarios for SAP BW that are based on consistent metadata. SAP BI Business Content offers selected roles in a company the information they need to carry out their tasks. The information models delivered cover all business areas and integrate content from almost all SAP and selected external applications.
SAP BW Subareas
[edit]| SL. No. | Area | Description |
|---|---|---|
| 1 | Data Warehousing | Data warehousing in SAP BW represents the integration, transformation, consolidation, cleanup, and storage of data. It also incorporates the extraction of data for analysis and interpretation. The data warehousing process includes data modeling, data extraction, and administration of the data warehouse management processes.
The central tool for data warehousing tasks in SAP BW is the Administrator Workbench. |
| 2 | BI Platform | The Business Intelligence platform serves as the technological infrastructure and offers various analytical technologies and functions. These include the OLAP processor, the Metadata Repository, Business Planning and Simulation, special analysis processes such as Data Mining, and the Reporting Agent. |
| 3 | BI Suite: Business Explorer | The SAP BW Business Intelligence Suite, the Business Explorer (BEx), provides flexible reporting and analysis tools for strategic analyses, operational reporting, and decision-making support within a business. These tools include query, reporting, and analysis functions. As an employee with access authorization you can evaluate past or current data on various levels of detail, and from different perspectives, not only on the Web but also in MS Excel.
You can use BEx Information Broadcasting to distribute Business Intelligence content from SAP BW by e-mail either as precalculated documents with past data, or as links with live data. You can also publish it to the Enterprise Portal. The Business Explorer allows a broad spectrum of users access to information in the SAP BW using the Enterprise Portal, the Intranet (Web application design) or mobile technologies. |
| 4 | Development technologies | · BI Java SDK
With the BI Java SDK you can create analytical applications with which you access both multidimensional (Online Analytical Processing or OLAP) and tabular (relational) data. You can also edit and display this data. BI Java Connectors, a group of four JCA-enabled (J2EE Connector Architecture) resource adapters, implement the BI Java SDK APIs and allow you to connect applications that you have created with the SDK to various data sources. · Open Analysis Interfaces The Open Analysis Interfaces make various interfaces available for connecting front-end tools from third-party providers. · Web Design API The Web design API and table interface allows you to realize highly individual scenarios and demanding applications with customer-defined interface elements. |