Online Tutorials & Training Materials | STechies.com
Register Login

SAP R/3 BW Step-by-Step Guide

|| || 0 Download

SAP R/3 BW Step-by-Step Guide
Stechies

SAP R/3 BW Step-by-Step Guide

Index
Preface........................................................................................................................... 4
   
Chapter 1. Business Scenario and SAP BW ......................................................................... 12
1.1. Sales Analysis - A Business Scenario ...........................................................................
1.2. Basic Concept of Data Warehousing............................................................................
1.3. BW - A SAP Data Warehousing Solution ......................................................................
1.4. Summary ..................................................................................................................
12
16
18
24
   
Chapter 2. Creating an InfoCube................................................................................. 25
2.1. Creating an InfoArea..................................................................................................
2.2. Creating InfoObject Catalogs......................................................................................
2.3. Creating InfoObjects—Characteristics .........................................................................
2.4. Creating InfoObjects—Key Figures..............................................................................
2.5. Creating an InfoCube.................................................................................................
2.6. Summary ..................................................................................................................
25
26
29
37
41
47
   
Chapter 3. Loading Data into the InfoCube................................................................. 50
3.1. Creating a Source System ..........................................................................................
3.2. Creating an Application Component ............................................................................
3.3. Creating an InfoSource for Characteristic Data ............................................................
3.4. Creating InfoPackages to Load Characteristic Data ......................................................
3.5. Checking Loaded Characteristic Data ..........................................................................
3.6. Entering the Master Data, Text, and Hierarchy Manually ..............................................
3.7. Creating an InfoSource for Transaction Data ...............................................................
3.8. Creating Update Rules for the InfoCube ......................................................................
3.9. Create an InfoPackage to Load Transaction Data.........................................................
3.10. Summary ................................................................................................................
50
52
53
58
63
66
79
89
91
96
   
Chapter 4. Checking Data Quality................................................................................ 99
4.1. Checking InfoCube Contents ......................................................................................
4.2. Using BW Monitor .....................................................................................................
4.3. Using the Persistent Staging Area (PSA).....................................................................
4.4. Summary .................................................................................................................
99
103
107
112
   
Chapter 5. Creating Queries and Workbooks ............................................................ 113
5.1. Creating a Query Using BEx Analyzer .........................................................................
5.2. Organizing Workbooks Using BEx Browser .................................................................
5.3. Using a Variable to Access a Hierarchy Node Directly ..................................................
5.4. Summary .................................................................................................................
113
125
127
134
   
Chapter 6. Managing User Authorization ................................................................. 137
6.1. Creating an Authorization Profile Using Profile Generator ............................................
6.2. Creating an Authorization Object to Control User Access to the InfoCube Data .............
6.3. Integrating Profile Generator and BEx Browser ...........................................................
6.4. Summary .................................................................................................................
137
148
162
171
   
Chapter 7. InfoCube Design ...................................................................................... 173
7.1. BW Star Schema.......................................................................................................
7.2. InfoCube Design Alternative I— Time-Dependent Navigational Attributes.....................
7.3. InfoCube Design Alternative II-Dimension Characteristics ...........................................
7.4. InfoCube Design Alternative III— Time-Dependent Entire Hierarchies..........................
7.5. Other InfoCube Design Techniques............................................................................
7.6. Summary .................................................................................................................
173
181
190
199
208
211
   
Chapter 8. Aggregates and Multi-Cubes.................................................................... 212
8.1. Aggregates...............................................................................................................
8.2. Multi-Cubes ..............................................................................................................
8.3. Summary ................................................................................................................
216
234
246
   
Chapter 9. Operational Data Store (ODS).................................................................. 248
9.1. Creating an ODS Object ............................................................................................
9.2. Preparing to Load Data into the ODS Object, Then into an InfoCube............................
9.3. Loading Data into the ODS Object .............................................................................
9.4. Loading Data into the InfoCube.................................................................................
9.5. Using 0RECORDMODE for Delta Load.........................................................................
9.6. Summary .................................................................................................................
249
255
265
280
283
288
   
Chapter 10. Business Content ................................................................................... 290
10.1. Creating an R/3 Source System ...............................................................................
10.2. Transferring R/3 Global Settings ..............................................................................
10.3. Replicating R/3 DataSources....................................................................................
10.4. Installing Business Content Objects and Loading R/3 Data ........................................
10.5. Summary ...............................................................................................................
291
309
312
322
330
   
Chapter 11. Generic R/3 Data Extraction.................................................................. 332
11.1. Creating Views in R/3..............................................................................................
11.2. Creating DataSources in R/3 and Replicating Them to BW.........................................
11.3. Creating a Characteristic in BW................................................................................
11.4. Loading Data from R/3 into BW...............................................................................
11.5. Summary ...............................................................................................................
334
342
346
352
359
   
Chapter 12. Data Maintenance .................................................................................. 360
12.1. Maintaining Characteristic Data................................................................................
12.2. Maintaining InfoCube Data ......................................................................................
12.3. Summary ...............................................................................................................
360
368
390
   
Chapter 13. Performance Tuning............................................................................... 392
13.1. BW Statistics ..........................................................................................................
13.2. System Administration Assistant ..............................................................................
13.3. Tuning Query Performance......................................................................................
13.4. Tuning Load Performance........................................................................................
13.5. Summary ...............................................................................................................
392
412
419
435
448
   
Chapter 14. Object Transport .................................................................................... 450
14.1. System Landscape ..................................................................................................
14.2. Development Class .................................................................................................
14.3. Object Transport.....................................................................................................
14.4. Summary ...............................................................................................................
450
452
455
463
   
Appendix A. BW Implementation Methodology ........................................................ 465
A.1. ASAP for BW............................................................................................................
A.2. A Simplified BW Project Plan .....................................................................................
A.3. For Further Information ............................................................................................
465
468
471
   
Appendix B. SAP Basis Overview............................................................................... 472
B.1. SAP Basis 3-Tier Architecture ....................................................................................
B.2. Dispatcher, Work Processes, and Services..................................................................
B.3. Memory Management ...............................................................................................
472
473
476
   
Appendix C. Glossary .................................................................................................
Appendix D. Bibliography ..........................................................................................
479
487
D1. Books .......................................................................................................................
D2. BW Methodology .......................................................................................................
D3. BW Online Documentation .........................................................................................
D4. Helpful OSS Notes .....................................................................................................
D5. SAP White Papers......................................................................................................
487
487
487
487
488

 


 Download attached file.

You must be Logged in to download this file

Related Articles

0.0124 seconds.