SAP Material PDF Review - BW360

Course Overview ............................................................................. vii

Course Goals.................................................................................vii

Course Objectives ...........................................................................vii

Unit 1: SAP NetWeaver .......................................................................1

SAP NetWeaver: IT Practices, IT Scenarios, and Usage Types .......................2

Unit 2: InfoProviders......................................................................... 13

InfoCube Data Model ...................................................................... 15

Data Store Object Architecture ........................................................... 33

MultiProvider ................................................................................ 36

Virtual Providers ............................................................................ 42

Real-time InfoCubes ....................................................................... 48

Data Store Object for Direct Update ..................................................... 60

Unit 3: Process Chains...................................................................... 65

Process Chains Design .................................................................... 66

Managing Process Chains ................................................................ 76

Unit 4: InfoProvider Administration and Tuning .....................................123

Managing InfoCubes ......................................................................125

Managing Data Store Objects............................................................134

Relational DBMS Indexes in BI ..........................................................145

Indexing for InfoProviders ................................................................161

Table Partitioning in BI ....................................................................178

Unit 5: Reporting Performance...........................................................191

Design Guidelines for Optimal Query Performance...................................192

OLAP Caching ............................................................................199

Unit 6: BI Statistics and Monitoring.....................................................221

BI Statistics .................................................................................223

BI Statistics Technical Content...........................................................230

BI Administrator Cockpit ..................................................................243

BI Trace Tool ...............................................................................252

Unit 7: Aggregates ..........................................................................259

Relational DBMS Aggregate Basics.....................................................261

Missing Aggregates .......................................................................272

Analyzing Aggregate Usage..............................................................282

Aggregate Maintenance ..................................................................290

Unit 8: Data Acquisition Performance ..................................................333

Data Load Cycle ...........................................................................334

Technical Details...........................................................................338

Parallelization ..............................................................................356

Optimizing Data Acquisition Performance..............................................364

Unit 9: Information Life Cycle Management...........................................385

Information Life Cycle Management in BI ..............................................386

Unit 10: Transport Management .........................................................413

System Landscape ........................................................................415

Standard Transport System ..............................................................421

Object Versions and Metadata...........................................................425

Transporting in BI ..........................................................................430

BEx Objects ................................................................................442

Transporting Roles and Workbooks.....................................................446

System Copy ...............................................................................449

Transport Strategies and Troubleshooting .............................................454

Unit 11: BI Accelerator .....................................................................461

BI Accelerator Introduction ...............................................................463

BI Accelerator Architecture...............................................................473

Implementing BI Accelerator Indexes ...................................................484

BI Accelerator Monitoring.................................................................501

Unit 12: Appendix ...........................................................................515

BI and OLTP System Comparison.......................................................516

BI Database Settings......................................................................519

Web Application Server Settings ........................................................523

Reorganizing Tables.......................................................................541

Sizing BI Systems .........................................................................546

Index............................................................................................555