SAP BW Functions details PDF material download

Reporting, analysis and interpretation of business data is a central focus for companies that wish to guarantee competitiveness, optimize processes and be able to react quickly and in line with the market. As the following graphic illustrates, SAP Business Information Warehouse (SAP BW), as a core component of SAP NetWeaver data warehousing functionality, provides both a business intelligence platform and a suite of business intelligence tools.
The functions in detail BW document is aimed at people who have little experience with SAP BW and are looking for an overview of the features SAP BW provides. Knowledge of data warehouse and business intelligence solutions, as well as an awareness of Internet standards and standardized communication technologies is assumed. The functions in detail document summarizes the most important functions and tools provided by SAP BW as of release 3.5 and offers an overview of the ways in which these functions and tools can be used. BI Content, delivered for SAP BW, is not discussed in this document.You can find additional information about SAP BW functions in the SAP BW documentation in the SAP Help Portal, at http:\\help.sap.com under SAP NetWeaver → SAP NetWeaver →Information Integration → SAP Business Information Warehouse.
The contents of the SAP BW study material and tutorial download link is as follows.
This SAP BW functions guide includes
INTRODUCTION……………………………………. 7
1 DATA WAREHOUSING…………………….. 9
1.1 ADMINISTRATOR WORKBENCH ………… 9
1.2 DATA MODELING ………………………….. 9
1.2.1 DataSource………………………. 10
1.2.2 Persistent Staging Area Table 10
1.2.3 InfoSource………………………… 10
1.2.4 Update Rules …………………….. 11
1.2.5 InfoObjects……………………….. 11
1.2.6 Data Targets ……………………… 12
1.2.6.1 InfoCube …………………………………… 13
1.2.6.2 ODS Object……………………………….. 14
1.2.6.3 Performance-Optimized Data Target Modeling……………………………………………………………….. 15
1.2.7 InfoProvider………………………. 17
1.2.7.1 InfoSet ……………………………………… 18
1.2.7.2 SAP RemoteCube ………………………. 18
1.2.7.3 RemoteCube……………………………… 18
1.2.7.4 Virtual InfoCubes with Services …….. 19
1.2.7.5 MultiProviders …………………………….. 19
1.3 DATA RETRIEVAL……………………….. 19
1.3.1 SAP BW Source Systems……. 20
1.3.1.1 Transferring Data from SAP Source Systems…………………………………………………………………. 20
1.3.1.2 Transferring Data Between Data Targets Within a SAP BW or into Additional SAP Systems –
Data Mart Interface…………………………………… 22
1.3.1.3 Transferring Data from Flat Files …… 23
1.3.1.4 Transferring Data Based on the Simple Object Access Protocol (SOAP)……………………………. 23
1.3.1.5 Transferring Data from a System Using Third-Party ETL Tools – Staging BAPIs…………………. 25
1.3.1.6 Transferring Data from Database Management System Tables / Views - DB Connect …………. 25
1.3.1.7 Transferring Data with UD Connect .. 25
1.3.2 SAP BW as Source System…. 26
1.3.2.1 SAP BW as Source System for Additional SAP BW Systems – Data Mart Interface…………….. 26
1.3.2.2 Open Hub Service ………………………. 26
1.4 DATA WAREHOUSE MANAGEMENT …. 27
1.4.1 Authorizations ……………………. 27
1.4.2 Metadata Repository…………… 28
1.4.3 Document Management ……… 29
1.4.4 Transporting……………………… 30
1.4.5 Installing Business Content …. 31
1.4.6 Technical Content………………. 32
1.4.7 Analysis and Repair Environment………………………………………………………………………… 33
1.4.8 Process Management…………. 34
1.4.8.1 Scheduler………………………………….. 34
1.4.8.2 Monitor……………………………………… 35
1.4.8.3 Process Chains………………………….. 36
1.4.8.4 Data Archiving ……………………………. 37
2 BUSINESS INTELLIGENCE PLATFORM ………………………………………………………………………… 39
2.1 OLAP……………………………………… 39
2.1.1 The OLAP Processor………….. 39
2.1.2 Special OLAP Functions and Services…………………………………………………………………. 40
2.1.2.1 Aggregation ……………………………….. 41
2.1.2.2 Local Calculations………………………. 41
2.1.2.3 Hierarchies………………………………… 42
2.1.2.4 Currency Translation …………………… 45
2.1.2.5 Elimination of Internal Business Volume………………………………………………………………………… 45
2.1.2.6 Selecting Constants…………………….. 45
2.1.2.7 Reporting Authorizations ……………… 46
2.1.3 Report-Report Interface ………. 46
2.1.4 Performance Optimization …… 47
2.1.4.1…………………………………………………….. 47
2.1.4.2 Non-Cumulatives ………………………… 47
2.1.4.3 Aggregates ……………………………….. 48
2.1.4.4 OLAP Cache……………………………… 49
2.1.5 Open Analysis Interfaces…….. 50
2.1.5.1 XML for Analysis………………………… 50
2.1.5.2 Web Service for Access to Query Data …………………………………………………………………………. 51
2.1.5.3 OLAP BAPIs ………………………………. 51
2.1.5.4 OLE DB for OLAP and ADO MD……. 51
2.2 BUSINESS PLANNING AND SIMULATION (BW-BPS)……………………………………………………………. 51
2.2.1 Data Basis…………………………. 52
2.2.2 Modeling …………………………… 53
2.2.3 Data Selection……………………. 53
2.2.4 Manual Planning ………………… 53
2.2.5 Planning Functions …………….. 54
2.2.6 Variables …………………………… 54
2.2.7 Hierarchies and Attributes …… 54
2.2.8 Characteristic Relationships … 55
2.2.9 Front Ends ………………………… 55
2.2.10 Status and Tracking System… 55
2.3 ANALYSIS PROCESS DESIGNER……… 56
2.4 DATA MINING …………………………….. 57
2.5 ALERT MANAGEMENT AND BACKGROUND SERVICES FOR REPORTING…………………………………… 57
2.5.1 Evaluating Exceptions ………… 58
2.5.2 Printing Queries …………………. 58
2.5.3 Pre-calculating Web templates ……………………………………………………………………………. 58
2.5.4 Precalculating characteristic variables of type precalculated value sets……………………. 58
2.5.5 Managing bookmarks …………. 58
2.5.6 Crystal Reports Queries ……… 58
2.6 ICF SERVICES IN SAP BW…………… 58
3 BUSINESS INTELLIGENCE SUITE: REPORTING AND ANALYSIS…………………………………… 59
3.1 QUERY DESIGN ………………………….. 60
3.1.1.1 Tabular and Multi-dimensional Query Display ………………………………………………………………… 60
3.1.1.2 Variables…………………………………… 61
3.1.1.3 Structures …………………………………. 62
3.1.1.4 Restricted Key Figures ………………… 63
3.1.1.5 Calculated Key Figures………………… 64
3.1.1.6 Exception Cells …………………………… 64
3.1.1.7 Restricting Characteristics ……………. 65
3.1.1.8 Exceptions ………………………………… 65
3.1.1.9 Conditions…………………………………. 66
3.1.2 The BEx Query Designer…….. 67
3.1.3 Ad-hoc Query Designer ………. 69
3.2 BEX WEB ………………………………… 70
3.2.1 Web Application Design………. 70
3.2.1.1 BEx Web Application Designer ……… 71
3.2.1.2 Web Design API …………………………. 76
3.2.2 Analysis & Reporting: BEx Web Applications………………………………………………………… 78
3.2.2.1 Context Menu …………………………….. 78
3.2.2.2 Using Documents in Web Applications ………………………………………………………………………….. 81
3.2.2.3 Analyzing Business Data Using Map and Chart Web Items ……………………………………………… 81
3.2.2.4 Ad-hoc Query Designer ……………….. 82
3.2.2.5 Alert Monitor ………………………………. 83
3.2.2.6 Data Mining……………………………….. 83
3.2.2.7 Variables in Web Applications ………. 83
3.2.2.8 Standard Web Template for Ad-hoc Analysis …………………………………………………………………. 83
3.2.2.9 Accessibility ……………………………….. 84
3.2.2.10 Web Browser Dependencies …….. 84
3.2.3 BEx Web Analyzer……………… 84
3.2.4 BEx Mobile Intelligence ………. 85
3.2.4.1 Automatic Device Recognition ………. 87
3.2.4.2 Alert Scenario …………………………….. 87
3.2.4.3 Online Scenario ………………………….. 88
3.2.4.4 Offline Scenario ………………………….. 89
3.3 ANALYSIS & REPORTING: BEX ANALYZER……………………………………………………………………….. 90
3.3.1 BEx Toolbar ………………………. 91
3.3.1.1 OLAP Functions for Active Cells……. 92
3.3.2 Evaluating Query Data………… 93
3.3.3 Queries in Workbooks ………… 94
3.3.4 Precalculating Workbooks …… 94
3.4 FORMATTED REPORTING: CRYSTAL ENTERPRISE INTEGRATION …………………………………………… 94
3.5 BEX BROWSER ………………………….. 95
3.6 BEX INFORMATION BROADCASTING… 96
3.6.1 BEx Broadcaster………………… 97
3.6.1.1 Output Formats………………………….. 98
3.6.1.2 Filter Settings…………………………….. 99
3.6.1.3 Sending by E-mail……………………….. 99
3.6.1.4 Exporting to the Enterprise Portal ….. 99
3.6.1.5 Scheduling Broadcast Settings ……..100
3.6.2 Publishing Queries and Web Applications…………………………………………………………… 100
4 INTEGRATION INTO THE ENTERPRISE PORTAL…………………………………………………………. 102
4.1 INTEGRATION OPTIONS………………. 102
4.1.1 Displaying Content from SAP BW in the Enterprise Portal ……………………………………. 103
4.1.2 Calling Content from SAP BW in the Enterprise Portal …………………………………………. 104
4.1.3 Content from SAP BW in the Navigation Panel……………………………………………………. 104
4.1.4 Generating Content from SAP BW for the Enterprise Portal………………………………….. 104
4.1.5 Working with Content from SAP BW in the Enterprise Portal ………………………………… 105
4.2 UNIFICATION IN THE PORTAL: DRAG&RELATE WITH BW CONTENT IN THE ENTERPRISE PORTAL .. 106
5 DEVELOPMENT TECHNOLOGIES… 108
5.1 BI JAVA SDK …………………………… 108
5.1.1 Components of the SDK……. 109
5.1.1.1 Application Programming Interfaces 109
5.1.1.2 Documentation…………………………..109
5.1.1.3 Examples………………………………….109
5.1.2 Overview of the SDK Architecture ……………………………………………………………………… 109
5.2 BI JAVA CONNECTORS……………….. 110
6 GLOSSARY ………………………………… 112

DOWNLOAD THIS TUTORIAL