SAP Certified Application Associate: SAP NetWeaver BW 7.0 (H3152)

Description

Learn what it takes to become an SAP Certified Application Associate as you progress, step-by-step, through the key functions and business scenarios.

Practice makes perfect, and this book provides you with a sampling of practice questions, so you'll understand the different types of questions and learn how to answer correctly based on the detailed explanation of why each of the answers is correct or incorrect. Plus, get the inside scoop on special tips and tricks you can use to prepare for and pass the exam. Explore practical, tried-and-true advice about how to use particular functions, explanations based on real-world business scenarios, as well as useful study tips and much more.

Key Objective Coverage

Learn the topics, terminology, and definitions as they'll be presented on the exam.

Practice Questions and Answers

Get familiar with the different types of exam questions and find tips and strategies for answering correctly.

Real-World Scenarios

Further your career by understanding how SAP solutions are used in everyday business scenarios.

Take-Aways and Test Tips

Learn how to improve your odds of doing well in each section of the exam.

CONTENTS:

* ... Acknowledgments ... 17

    * PART I ... General Information ... 19

    * 1 ... SAP BI with SAP NetWeaver (7.0) Certification Track - Overview ... 21

    * ... Certification Objectives and Benefits ... 22

    * ... The New Certification Process ... 23

    * ... SAP Tiered Certification ... 23

    * ... Certification Focus Areas ... 24

    * ... Available NetWeaver BW Certification Exams ... 25

    * ... SAP Certification Exam Structure ... 26

    * ... Competency Level ... 26

    * ... Exam Structure for the SAP Certified Application Associate - Business Intelligence with SAP NetWeaver 7.0 Exam ... 27

    * ... Associate Competency Levels ... 27

    * ... Exam Topics for Application Associate - BI with SAP NetWeaver 7.0 ... 28

    * ... Exam Structure for the SAP Certified Application Professional Exams ... 29

    * ... Professional Competency Levels ... 29

    * ... Exam Topics for the SAP Certified Application Professional - Enterprise Data Warehousing with SAP NetWeaver Business Warehouse (BW 7.0) Exam ... 30

    * ... Exam Topics for SAP Certified Application Professional - Reporting and Analysis with SAP NetWeaver Business Warehouse (BW 7.0) Exam ... 31

    * ... General Information About the Exam ... 32

    * ... Duration of the Exam ... 32

    * ... About the Questions ... 32

    * ... About the Answers ... 33

    * ... Summary ... 34

    * 2 ... SAP NetWeaver Courses and Experience ... 35

    * ... Courses and Experience ... 36

    * ... SAP NetWeaver BW Training Courses ... 36

    * ... Experience Expectation ... 39

    * ... Additional Sources of Information ... 40

    * ... Summary ... 41

    * PART II ... Exam Preparation ... 43

    * 3 ... SAP NetWeaver BW Overview ... 45

    * ... Objectives of this Portion of the Test ... 46

    * ... Key Concepts Review ... 46

    * ... SAP NetWeaver Platform Overview ... 46

    * ... SAP NetWeaver IT Practices and Scenarios ... 47

    * ... SAP NetWeaver BW Architecture ... 48

    * ... Practice Test Questions ... 51

    * ... Practice Test Questions Answers and Explanation ... 51

    * ... Take Away ... 52

    * ... Summary ... 52

    * 4 ... SAP BEx Query Designer ... 53

    * ... Objectives of this Portion of the Test ... 54

    * ... Key Concepts Review ... 55

    * ... Accessing the Query Designer ... 55

    * ... Query Designer Toolbar ... 55

    * ... Query Designer Menu ... 57

    * ... Query Designer Layout ... 57

    * ... InfoProviders in SAP BEx Reporting ... 60

    * ... Key Figures ... 62

    * ... Characteristics ... 67

    * ... Display and Navigation Attributes ... 69

    * ... Variables ... 71

    * ... Exceptions ... 71

    * ... Conditions ... 73

    * ... Practice Test Questions ... 74

    * ... Practice Test Questions Answers and Explanation ... 75

    * ... Take Away ... 76

    * ... Summary ... 77

    * 5 ... SAP BEx Analyzer ... 79

    * ... Objectives of this Portion of the Test ... 80

    * ... Key Concepts Review ... 81

    * ... Accessing the SAP BEx Analyzer ... 81

    * ... SAP BEx Analysis Toolbar ... 81

    * ... Design Mode ... 83

    * ... SAP BEx Workbook ... 85

    * ... Navigation Options ... 86

    * ... Practice Test Questions ... 89

    * ... Practice Questions Answers and Explanations ... 90

    * ... Take Away ... 91

    * ... Summary ... 91

    * 6 ... SAP BEx Web Analyzer ... 93

    * ... Objectives of this Portion of the Test ... 94

    * ... Key Concepts of the Test ... 95

    * ... Accessing the Web Analyzer ... 95

    * ... SAP BEx Web Analyzer Toolbar ... 95

    * ... Navigation Using the Context Menu ... 98

    * ... Drag-and-Drop Navigation and Filtering ... 103

    * ... Setting a Bookmark ... 104

    * ... Practice Test Questions ... 106

    * ... Practice Question Answers and Explanations ... 107

    * ... Take Away ... 107

    * ... Summary ... 108

    * 7 ... Information Broadcasting ... 109

    * ... Objectives of this Portion of the Test ... 110

    * ... Calling the SAP BEx Broadcaster ... 110

    * ... Object Types ... 112

    * ... Distribution Types ... 112

    * ... Output Options ... 114

    * ... Practice Test Questions ... 115

    * ... Practice Question Answers and Explanations ... 116

    * ... Take Away ... 117

    * ... Summary ... 117

    * 8 ... Enterprise Portal Integration ... 119

    * ... Objectives of this Portion of the Test ... 120

    * ... Key Concepts Review ... 121

    * ... Portal Desktop ... 121

    * ... Display Types for Content from SAP NetWeaver BW ... 123

    * ... Tools for Integrating SAP NetWeaver BW Objects into the SAP NetWeaver Portal ... 125

    * ... Practice Test Questions ... 127

    * ... Practice Question Answers and Explanations ... 128

    * ... Take Away ... 128

    * ... Summary ... 129

    * 9 ... Document Integration ... 131

    * ... Objectives of this Portion of the Test ... 132

    * ... Key Concepts Review ... 132

    * ... Document Classes ... 132

    * ... Document Integration ... 133

    * ... Practice Test Question ... 134

    * ... Practice Question Answer and Explanation ... 134

    * ... Take Away ... 135

    * ... Summary ... 135

    * 10 ... SAP BEx Report Designer ... 137

    * ... Objectives of this Portion of the Test ... 138

    * ... Key Concepts Review ... 138

    * ... Accessing the Report Designer ... 138

    * ... Layout of the Report Designer ... 139

    * ... Creating a Report with the Report Designer ... 140

    * ... Practice Test Questions ... 141

    * ... Practice Question Answers and Explanations ... 142

    * ... Take Away ... 142

    * ... Summary ... 142

    * 11 ... SAP BEx Web Application Designer ... 143

    * ... Objectives of this Portion of the Test ... 144

    * ... Key Concepts Review ... 145

    * ... Accessing the SAP BEx Web Application Designer ... 145

    * ... Components of the Web Application Designer ... 145

    * ... Chart Wizard ... 148

    * ... Practice Test Questions ... 150

    * ... Practice Test Questions Answers and Explanations ... 151

    * ... Take Away ... 151

    * ... Summary ... 152

    * 12 ... Data Warehousing Workbench ... 153

    * ... Objectives of this Portion of the Test ... 154

    * ... Key Concepts Review ... 154

    * ... Accessing the Data Warehousing Workbench ... 154

    * ... Practice Test Questions ... 157

    * ... Practice Question Answers and Explanations ... 157

    * ... Take Away ... 158

    * ... Summary ... 158

    * 13 ... Performance Tuning ... 159

    * ... Objectives of this Portion of the Test ... 160

    * ... Key Concept Review ... 160

    * ... Query Performance ... 160

    * ... Aggregates ... 163

    * ... SAP NetWeaver BW Accelerator ... 164

    * ... Practice Test Questions ... 166

    * ... Practice Question Answers and Explanations ... 167

    * ... Take Away ... 167

    * ... Summary ... 168

    * 14 ... InfoObjects ... 169

    * ... Objectives of this Portion of the Test ... 170

    * ... Key Concepts Review ... 170

    * ... Classifying InfoObjects ... 170

    * ... Key Figure Maintenance Screen ... 174

    * ... Characteristic InfoObject Maintenance Screen ... 179

    * ... InfoAreas and InfoCatalogs ... 190

    * ... Creating a Key Figure InfoObject ... 190

    * ... Creating a Characteristic InfoObject ... 191

    * ... Creating Free Characteristics ... 192

    * ... Practice Test Questions ... 192

    * ... Practice Question Answers and Explanations ... 194

    * ... Take Away ... 195

    * ... Summary ... 195

    * 15 ... InfoProviders ... 197

    * ... Objectives of this Portion of the Test ... 198

    * ... Key Concepts Review ... 198

    * ... InfoCube ... 198

    * ... DataStore Object (DSO ... 201

    * ... MultiProvider ... 206

    * ... InfoSet ... 209

    * ... VirtualProvider ... 212

    * ... Practice Test Questions ... 214

    * ... Practice Question Answers and Explanations ... 215

    * ... Take Away ... 215

    * ... Summary ... 215

    * 16 ... Data Modeling ... 217

    * ... Objectives of this Portion of the Test ... 218

    * ... Key Concepts Review ... 218

    * ... Enterprise Data Warehouse Architecture ... 218

    * ... Conceptual Layers of Data Warehousing ... 218

    * ... Multidimensional Modeling in SAP NetWeaver BW ... 220

    * ... Practice Test Questions ... 229

    * ... Practice Test Questions Answers and Explanations ... 230

    * ... Take Away ... 231

    * ... Summary ... 231

    * 17 ... Metadata ... 233

    * ... Objectives of this Portion of the Test ... 234

    * ... Key Concepts Review ... 234

    * ... Metadata Repository ... 234

    * ... Remodeling Toolbox ... 236

    * ... BI Content ... 241

    * ... Practice Test Questions ... 245

    * ... Practice Test Questions Answers and Explanations ... 246

    * ... Take Away ... 246

    * ... Summary ... 246

    * 18 ... Source Systems ... 247

    * ... Objectives of this Portion of the Test ... 248

    * ... Key Concepts Review ... 248

    * ... Source Systems Types ... 248

    * ... Creating a Source System ... 248

    * ... SAP Source ... 250

    * ... File Source ... 251

    * ... Relational Source ... 252

    * ... Multidimensional Source ... 253

    * ... XML Source ... 254

    * ... Practice Test Questions ... 255

    * ... Practice Test Questions Answers and Explanations ... 256

    * ... Take Away ... 256

    * ... Summary ... 257

    * 19 ... Data Flow ... 259

    * ... Objectives of this Portion of the Test ... 260

    * ... Key Concepts Review ... 260

    * ... DataSource ... 260

    * ... Persistent Staging Area (PSA) ... 261

    * ... Transformation ... 261

    * ... InfoSources ... 266

    * ... Practice Test Questions ... 267

    * ... Practice Test Question Answers and Explanations ... 268

    * ... Take Away ... 268

    * ... Summary ... 269

    * 20 ... Scheduling and Monitoring ... 271

    * ... Objectives of this Portion of the Test ... 272

    * ... Key Concepts Review ... 272

    * ... Data Transfer Process ... 272

    * ... Direct Access to Source System Data ... 274

    * ... Process Chains ... 274

    * ... Data Load Monitor ... 278

    * ... Practice Test Questions ... 280

    * ... Practice Test Question Answers and Explanations ... 281

    * ... Take Away ... 281

    * ... Summary ... 282

    * 21 ... Development Interfaces ... 283

    * ... Objectives of this Portion of the Test ... 284

    * ... Key Concepts Review ... 284

    * ... Universal Data Integration ... 284

    * ... Web Services ... 286

    * ... Practice Test Questions ... 288

    * ... Practice Test Questions Answers and Explanations ... 289

    * ... Take Away ... 290

    * ... Summary ... 291

    * 22 ... SAP NetWeaver BW Integrated Planning ... 293

    * ... Objectives of this Portion of the Test ... 294

    * ... Key Concepts Review ... 294

    * ... Planning Functions - Basics ... 294

    * ... Creating Planning Functions ... 295

    * ... Creating an Input-Ready Query ... 297

    * ... Practice Test Questions ... 298

    * ... Practice Test Questions Answers and Explanation ... 298

    * ... Take Away ... 299

    * ... Summary ... 299

    * 23 ... SAP NetWeaver BW Analysis Process Designer and Data Mining ... 301

    * ... Objectives of this Portion of the Test ... 302

    * ... Key Concepts Review ... 302

    * ... Data Mining ... 302

    * ... Data Mining Types ... 303

    * ... Analysis Process Designer ... 304

    * ... Practice Test Questions ... 307

    * ... Practice Test Questions Answers and Explanations ... 308

    * ... Take Away ... 309

    * ... Summary ... 309

    * ... The Author ... 311

    * ... Index ... 313