دانلود کتاب SAP(R) Bw: A Step-By-Step Guide [With CDROM]

فهرست مطالب :

Cover......Page 1
Contents......Page 6
Preface......Page 12
Acknowledgments......Page 20
Part I: Guided Tours......Page 22
Chapter 1 Business Scenario and SAP BW......Page 24
1.1 Sales Analysis—A Business Scenario......Page 25
1.2 Basic Concept of Data Warehousing......Page 28
1.3 BW—An SAP Data Warehousing Solution......Page 30
1.4 Summary......Page 37
Chapter 2 Creating an InfoCube......Page 38
2.1 Creating an InfoArea......Page 39
2.2 Creating InfoObject Catalogs......Page 41
2.3 Creating InfoObjects—Characteristics......Page 44
2.4 Creating InfoObjects—Key Figures......Page 51
2.5 Creating an InfoCube......Page 55
2.6 Summary......Page 60
Chapter 3 Loading Data into the InfoCube......Page 64
3.1 Creating a Source System......Page 65
3.2 Creating an Application Component......Page 67
3.3 Creating an InfoSource for Characteristic Data......Page 68
3.4 Creating InfoPackages to Load Characteristic Data......Page 73
3.5 Checking Loaded Characteristic Data......Page 78
3.6 Entering the Master Data, Text, and Hierarchy Manually......Page 82
3.7 Creating an InfoSource for Transaction Data......Page 94
3.8 Creating Update Rules for the InfoCube......Page 103
3.9 Creating an InfoPackage to Load Transaction Data......Page 105
3.10 Summary......Page 110
Chapter 4 Checking Data Quality......Page 114
4.1 Checking InfoCube Contents......Page 115
4.2 Using BW Monitor......Page 117
4.3 Using the Persistent Staging Area (PSA)......Page 121
4.4 Summary......Page 126
5.1 Creating a Query Using BEx Analyzer......Page 128
5.2 Organizing Workbooks Using BEx Browser......Page 140
5.3 Using a Variable to Access a Hierarchy Node Directly......Page 141
5.4 Summary......Page 149
Chapter 6 Managing User Authorization......Page 152
6.1 Creating an Authorization Profile Using Profile Generator......Page 153
6.2 Creating an Authorization Object to Control User Access to the InfoCube Data......Page 163
6.3 Integrating Profile Generator and BEx Browser......Page 175
6.4 Summary......Page 181
Part II: Advanced Topics......Page 184
Chapter 7 InfoCube Design......Page 186
7.1 BW Star Schema......Page 187
7.2 InfoCube Design Alternative I—Time-Dependent Navigational Attributes......Page 194
7.3 InfoCube Design Alternative II—Dimension Characteristics......Page 201
7.4 InfoCube Design Alternative III—Time-Dependent Entire Hierarchies......Page 208
7.5 Other InfoCube Design Techniques......Page 215
7.6 Summary......Page 218
Chapter 8 Aggregates and Multi-Cubes......Page 220
8.1 Aggregates......Page 223
8.2 Multi-Cubes......Page 236
8.3 Summary......Page 245
Chapter 9 Operational Data Store (ODS)......Page 248
9.1 Creating an ODS Object......Page 250
9.2 Preparing to Load Data into the ODS Object, Then into an InfoCube......Page 255
9.3 Loading Data into the ODS Object......Page 263
9.4 Loading Data into the InfoCube......Page 276
9.5 Using 0RECORDMODE for Delta Load......Page 279
9.6 Summary......Page 285
Chapter 10 Business Content......Page 288
10.1 Creating an R/3 Source System......Page 289
10.2 Transferring R/3 Global Settings......Page 301
10.3 Replicating R/3 DataSources......Page 304
10.4 Installing Business Content Objects and Loading R/3 Data......Page 310
10.5 Summary......Page 316
Chapter 11 Generic R/3 Data Extraction......Page 318
11.1 Creating Views in R/3......Page 321
11.2 Creating DataSources in R/3 and Replicating Them to BW......Page 326
11.3 Creating a Characteristic in BW......Page 329
11.4 Loading Data from R/3 into BW......Page 334
11.5 Summary......Page 340
Chapter 12 Data Maintenance......Page 342
12.1 Maintaining Characteristic Data......Page 343
12.2 Maintaining InfoCube Data......Page 350
12.3 Summary......Page 371
Chapter 13 Performance Tuning......Page 374
13.1 BW Statistics......Page 375
13.2 System Administration Assistant......Page 391
13.3 Tuning Query Performance......Page 395
13.4 Tuning Load Performance......Page 412
13.5 Summary......Page 422
Chapter 14 Object Transport......Page 424
14.1 System Landscape......Page 425
14.2 Development Class......Page 427
14.3 Object Transport......Page 429
14.4 Summary......Page 437
A.1 ASAP for BW......Page 438
A.2 A Simplified BW Project Plan......Page 441
A.3 For Further Information......Page 444
B.1 SAP Basis 3-Tier Architecture......Page 446
B.2 Dispatcher, Work Processes, and Services......Page 448
B.3 Memory Management......Page 450
A......Page 454
C......Page 455
D......Page 456
I......Page 457
K......Page 458
P......Page 459
S......Page 460
U......Page 461
W......Page 462
Appendix D: Bibliography......Page 464
A......Page 468
B......Page 469
C......Page 470
D......Page 471
E......Page 472
I......Page 473
M......Page 475
P......Page 476
R......Page 477
S......Page 478
T......Page 479
U......Page 480
Z......Page 481