SAP Press - SAP BW4HANA - An Introduction

主页 » SAP电子书

作者 Christensen 2012年出版 分类:SAP 1573

SAP BW4HANA - An Introduction 

英文原版非影印版,可编辑带目录,总计423页。

1 Introduction to SAP BW/4HANA 19

1.1 History of SAP BW ............................................................................................................... 19

1.1.1 SAP BW Release 1.0 .............................................................................................. 20

1.1.2 SAP BW Release 1.2 .............................................................................................. 20

1.1.3 SAP BW Release 2.0 and 2.1 .............................................................................. 21

1.1.4 SAP BW Release 3.x .............................................................................................. 21

1.1.5 SAP BW Release 7.0 to 7.3 .................................................................................. 22

1.1.6 SAP BW 7.4 and 7.5 Powered by SAP HANA ................................................. 23

1.2 SAP BW/4HANA Overview .............................................................................................. 25

1.2.1 SAP BW/4HANA Design Principles .................................................................. 25

1.2.2 Simplified Data Model ........................................................................................ 26

1.2.3 Openness ................................................................................................................. 28

1.2.4 Modern Interfaces ................................................................................................ 30

1.2.5 High Performance ................................................................................................ 31

1.3 Implementing SAP BW/4HANA .................................................................................... 32

1.3.1 New Installation of SAP BW/4HANA ............................................................. 33

1.3.2 System Conversion of Existing SAP BW System ......................................... 33

1.3.3 Landscape Consolidation ................................................................................... 36

1.3.4 Recommendation for Implementing SAP BW/4HANA ............................ 36

1.4 Summary ................................................................................................................................. 37

2 Introduction to SAP HANA 39

2.1 What Is SAP HANA? ............................................................................................................ 39

2.1.1 Traditional Database versus In-Memory Database .................................. 40

2.1.2 SAP HANA ............................................................................................................... 41

2.2 SAP HANA as an Application Platform ...................................................................... 43

2.3 SAP HANA as a Database for SAP Applications ..................................................... 44

2.3.1 SAP Enterprise Resource Planning .................................................................. 44

2.3.2 SAP Business Warehouse ................................................................................. 48

2.4 SAP HANA Deployment .................................................................................................... 49

2.4.1 SAP HANA Hardware Options .......................................................................... 50

2.4.2 Scaled-Up SAP HANA Systems ......................................................................... 51

2.4.3 Scaled-Out SAP HANA Systems ....................................................................... 52

2.5 Virtualization ........................................................................................................................ 55

2.5.1 What Is Virtualization? ...................................................................................... 55

2.5.2 SAP HANA Virtualization ................................................................................... 56

2.6 Summary ................................................................................................................................ 58

3 Installation and Setup 59

3.1 Preparation ............................................................................................................................ 59

3.1.1 Requirements ........................................................................................................ 59

3.1.2 Installation Media ................................................................................................ 61

3.2 Installation ............................................................................................................................. 62

3.3 Postinstallation ................................................................................................................... 70

3.3.1 SAP HANA Database Technical User Setup ................................................. 70

3.3.2 SAP BW/4HANA Setup ....................................................................................... 71

3.3.3 RFC and Parameter Configuration ................................................................. 72

3.3.4 Configuring SAP BW/4HANA Workspaces .................................................. 73

3.3.5 SAP BW/4HANA Table Placement .................................................................. 73

3.3.6 Client Copy ............................................................................................................ 75

3.3.7 Service Pack Upgrade and SAP License Installation .................................. 76

3.4 Summary ................................................................................................................................. 76

4 SAP BW/4HANA in the Cloud 77

4.1 Choosing a Cloud Provider .............................................................................................. 77

4.1.1 Performance .......................................................................................................... 78

4.1.2 Technology and Certification ........................................................................... 79

4.1.3 Service-Level Agreements and Reliability ..................................................... 79

4.1.4 Ecosystem and Community .............................................................................. 79

4.1.5 Security and Compliance ................................................................................... 79

4.1.6 Costs ......................................................................................................................... 80

4.1.7 Preferred Providers ............................................................................................... 80

4.2 Cloud Providers ..................................................................................................................... 81

4.2.1 SAP HANA Enterprise Cloud .............................................................................. 81

4.2.2 Amazon Web Services ......................................................................................... 82

4.2.3 Microsoft Azure ..................................................................................................... 84

4.2.4 Other Providers ..................................................................................................... 86

4.3 SAP BW/4HANA Cloud Deployment Steps .............................................................. 87

4.3.1 Setting Up the Cloud Provider Account ........................................................ 88

4.3.2 Selecting Your Deployment .............................................................................. 92

4.3.3 Logging On to the Instance ............................................................................... 95

4.3.4 Managing Instances ............................................................................................ 96

4.3.5 Renewing Licenses ............................................................................................... 98

4.4 Summary ................................................................................................................................. 99

5 Data Modeling 101

5.1 Modeling Perspectives ...................................................................................................... 101

5.2 Modeling Objects ................................................................................................................. 104

5.3 InfoObjects ............................................................................................................................. 106

5.3.1 Characteristics ....................................................................................................... 107

5.3.2 XXL ............................................................................................................................. 113

5.3.3 Key Figure ................................................................................................................ 114

5.3.4 Unit ............................................................................................................................ 117

5.4 SAP BW/4HANA InfoProviders ...................................................................................... 117

5.4.1 Field-Based Modeling .......................................................................................... 118

5.4.2 Open ODS Views ................................................................................................... 119

5.4.3 Advanced DataStore Objects ............................................................................ 125

5.4.4 CompositeProvider .............................................................................................. 134

5.5 Summary ................................................................................................................................. 139

6 Data Acquisition 141

6.1 SAP BW/4HANA Source Systems ................................................................................. 142

6.1.1 Creating a Source System ................................................................................. 143

6.1.2 Connection Type: SAP HANA Local and Tenant Database Schema .... 145

6.1.3 Connection Type: SAP HANA Smart Data Access and Big Data ........... 146

6.1.4 Connection Type: File ......................................................................................... 149

6.1.5 Connection Type: Operational Data Provisioning .................................... 149

6.2 SAP BW/4HANA DataSources ....................................................................................... 154

6.2.1 Creating a DataSource with the Native Eclipse-Based Wizard ............. 155

6.2.2 Creating a DataSource for File-Type Source Systems .............................. 162

6.2.3 ODP DataSources ................................................................................................. 166

6.3 SAP BW/4HANA Data Flows .......................................................................................... 168

6.3.1 Creating a Data Flow .......................................................................................... 170

6.3.2 Creating Transformations ................................................................................. 172

6.3.3 Currency Conversions and Unit of Measures Validation ........................ 175

6.3.4 Transformation Version Management ......................................................... 176

6.3.5 Transformation Metadata View ..................................................................... 176

6.3.6 Transformation Runtime Status ..................................................................... 177

6.3.7 ABAP Managed Database Procedures ........................................................... 177

6.4 SAP BW/4HANA Data Loading ...................................................................................... 178

6.4.1 Creating DTPs ........................................................................................................ 179

6.4.2 Creating Process Chains .................................................................................... 182

6.5 Manual Data Acquisition ................................................................................................. 185

6.6 Summary ................................................................................................................................. 187

7 Reporting and Analytics 189

7.1 SAP BW/4HANA Queries .................................................................................................. 190

7.1.1 Creating a Query with Eclipse-Based Query Designer ............................. 191

7.1.2 Query Properties ................................................................................................... 195

7.1.3 Filters ........................................................................................................................ 201

7.1.4 Variables ................................................................................................................. 205

7.1.5 Query Sheet Definition ...................................................................................... 212

7.1.6 Query Elements ..................................................................................................... 214

7.1.7 Query Conditions .................................................................................................. 222

7.1.8 Query Exceptions .................................................................................................. 224

7.1.9 Query Transport .................................................................................................... 226

7.2 Interfaces for Analysis ....................................................................................................... 228

7.2.1 Multidimensional Interfaces ............................................................................ 228

7.2.2 Lightweight Consumption Interfaces ............................................................ 229

7.3 SAP BusinessObjects Tools .............................................................................................. 232

7.3.1 Universes ................................................................................................................. 233

7.3.2 SAP HANA ................................................................................................................ 233

7.3.3 SAP HANA: Online ................................................................................................ 236

7.3.4 SAP BEx ..................................................................................................................... 237

7.4 Third-Party Business Intelligence Tools ..................................................................... 239

7.4.1 ODBC Data Source ................................................................................................ 239

7.4.2 OData Data Source .............................................................................................. 244

7.4.3 OLEDB Data Source .............................................................................................. 246

7.5 Summary ................................................................................................................................. 248

8 Integrating External Data 251

8.1 SAP HANA Smart Data Access ........................................................................................ 251

8.1.1 Supported Remote Sources .............................................................................. 252

8.1.2 Configure SAP HANA Smart Data Access ..................................................... 253

8.1.3 Create Remote Source via Smart Data Access Adapter ........................... 255

8.2 SAP HANA Smart Data Integration .............................................................................. 260

8.2.1 Configure SAP HANA Smart Data Integration ........................................... 261

8.2.2 Create Remote Source with Smart Data Integration Adapter .............. 273

8.2.3 Create Remote Source Connection to Oracle .............................................. 275

8.2.4 Create Remote Source Connection to Hadoop ........................................... 277

8.2.5 Create Virtual Tables ........................................................................................... 278

8.3 Integration with SAP BW/4HANA ................................................................................ 279

8.3.1 Combining Data under Schema SAPSR3 ...................................................... 279

8.3.2 Combine Data via Open ODS Views or CompositeProvider ................... 281

8.4 Summary ................................................................................................................................. 287

9 Data Lifecycle Management 289

9.1 Data Retention Strategy ................................................................................................. 290

9.2 Data Temperature .............................................................................................................. 296

9.2.1 Warm Data in Extension Nodes ...................................................................... 298

9.2.2 Cold Data in Near-Line Storage ....................................................................... 303

9.3 Data Archiving ...................................................................................................................... 305

9.3.1 Creating Near-Line Storage Connections .................................................... 306

9.3.2 Creating a Remote Source in SAP HANA Studio ........................................ 309

9.3.3 Using SAP IQ for Near-Line Storage ............................................................... 312

9.3.4 Using Hadoop for Near-Line Storage ............................................................ 315

9.3.5 Creating Data Archiving Processes ................................................................ 321

9.3.6 Administration of Data Archiving Processes .............................................. 324

9.3.7 Reading Near-Line Storage Data in Transformation Rules .................... 327

9.4 Summary ................................................................................................................................. 330

10 Administration 331

10.1 Daily Administration Tasks ............................................................................................. 331

10.1.1 Check Database Storage .................................................................................... 332

10.1.2 Check SAP HANA Workload ............................................................................. 336

10.1.3 Check ABAP Workload ....................................................................................... 340

10.1.4 Perform System Checks ..................................................................................... 347

10.1.5 Automate Daily Tasks ......................................................................................... 355

10.2 Daily Load Monitoring ...................................................................................................... 356

10.2.1 Monitor SAP BW/4HANA Computing Center Management

System Alerts ......................................................................................................... 356

10.2.2 Monitor Process Chains ..................................................................................... 358

10.3 Weekly, Monthly, Quarterly, and Annual Tasks ................................................... 359

10.4 Summary ................................................................................................................................. 361

11 Security 363

11.1 Authentication and Single Sign-On ............................................................................. 363

11.1.1 Application Server for ABAP Authentication ............................................... 364

11.1.2 SAP HANA Authentication ................................................................................. 364

11.2 Authorization in Application Server for ABAP ........................................................ 365

11.2.1 Authorization Fields ............................................................................................ 367

11.2.2 Activity Fields ......................................................................................................... 368

11.3 Standard Authorization Objects ................................................................................... 369

11.3.1 Developer and Administrator Authorizations ............................................ 369

11.3.2 Reporting Authorizations .................................................................................. 372

11.3.3 SAP HANA Authorizations ................................................................................. 373

11.4 Analysis Authorizations .................................................................................................... 376

11.4.1 Creating an InfoObject for Analysis Authorizations ................................. 376

11.4.2 Defining Analysis Authorizations ................................................................... 377

11.4.3 Automatically Generating Analysis Authorizations ................................. 378

11.5 Roles .......................................................................................................................................... 380

11.5.1 Administrator Roles ............................................................................................. 381

11.5.2 End User Roles ....................................................................................................... 381

11.5.3 Role Templates ...................................................................................................... 382

11.6 User Administration ........................................................................................................... 385

11.6.1 Defining Users ....................................................................................................... 385

11.6.2 Assigning Analysis Authorizations to Users ................................................ 387

11.6.3 User Administration Tools ................................................................................. 389

11.7 Troubleshooting Authorization Problems ................................................................ 390

11.7.1 Standard Authorization Errors ......................................................................... 391

11.7.2 Analysis Authorization Errors ........................................................................... 392

11.8 Summary ................................................................................................................................. 396

12 The Future of SAP BW/4HANA 397

12.1 SAP BW to SAP BW/4HANA Roadmap ..................................................................... 397

12.2 Openness ................................................................................................................................ 399

12.2.1 Operational Data Provisioning Source System Type ................................ 400

12.2.2 SAP HANA Source System Type ....................................................................... 400

12.2.3 Big Data Source System Type ........................................................................... 401

12.2.4 File Source System Type ..................................................................................... 401

12.3 Simplicity ................................................................................................................................ 402

12.3.1 Simplicity in Data Integration ......................................................................... 402

12.3.2 Simplicity in Modeling Activities .................................................................... 403

12.3.3 Simplicity in Data Flow Maintenance ........................................................... 403

12.3.4 Simplicity in Data Lifecycle Management ................................................... 404

12.3.5 Simplicity in Business Content ........................................................................ 406

12.4 User Interfaces ..................................................................................................................... 407

12.4.1 Data Flow Modeler .............................................................................................. 408

12.4.2 Process Chain Monitor ....................................................................................... 411

12.4.3 Business User Interface ...................................................................................... 411

12.5 High Performance ............................................................................................................... 411

12.6 Future Innovations ............................................................................................................. 412

12.7 Future Migration Options ............................................................................................... 413

12.8 Summary ................................................................................................................................. 414


BW/4HANA SAP Press
此处应有打赏,28块就够了亲!

如遇任何问题请联系客服微信ficodk!

下载链接:

上一本

《Kill SAP FICO》from SAP刀客

下一本

SAP Press - SAP SuccessFactors Employee Central - The Comprehensive Guide