SAP Certified Application Associate — Business Intelligence with SAP NetWeaver 7.0

Click to enlarge

Regular Price:

~~$69.95~~

Your Price:

$54.95 You save $15.00 (21.44%)

Product Code:

H3152

Average Rating:

( 4 product reviews )

Availability:

In stock!

Product Details

ISBN:

978-1-59229-353-7

Author(s):

Lisette Bellissimo

Type:

Hardcover, 318 pages

Product Description and Table of Contents

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.

Exam Topics for C_TBW45_70

· SAP BI with SAP NetWeaver (7.0)
· Certification Track Overview
· Data Flow
· InfoObjects and InfoProviders
· BEx Analyzer and BEx Query Designer
· Source Systems
· Integrated Planning
· Analysis Process Designer
· Metadata
· Development Interfaces
· Data Modeling
· Exam
· C TBW45 70
· SAP ® Certification
· Success Guide

The Author

Lisette Bellissimo has worked with SAP for over 11 years and 9 of those have been spent designing and implementing BW solutions for SAP clients. When SAP announced the certification initiative and the new exam, she became part of the leadership team that put together a virtual study group for SAP consultants studying for the exam. She has taken and passed the exam.

... 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

Additional Resource(s)

Download:

Free Sample Chapter PDF

Product Reviews

Best book out in the Market

Posted by Rajesh on Jun 23rd, 2011

This is the best book available in market.Practise questions might be simple to answer, but the topics covered in this book are exactly based on exam topics.May not be the best for a beginner, but for someone who has worked in BW, this should do the needful.A Practical Guide to Netweaver BW 7.0 and this book should be the best combo for certification. Do not expect the exam questions to be similar to the ones in the book. The books covers the topics and give us a overview. Kudos to Lisette.It would be great if a book is released from her for Professional level too.
Not adequate for exam preparation

Posted by Disgruntled on Mar 1st, 2011

I found this book inadequate for exam preparation and not adequate for revision. I found the questions to be extremely basic and nowhere near the exam standard. This book is too too basic. Maybe as an introduction to BI 7.0 but never for preparation for the C_TBW45_70 exam preparation.

EDITOR’S NOTE: We’re very sorry to hear that you were disappointed in the content of the book. The questions in this guide were all closely based on material in the actual test, and should successfully prepare readers to take it. Please note that the book is for the Associate-level exam, not the Professional, so the questions are inherently more basic in nature.
Easy and very helpful!

Posted by bilash on Oct 25th, 2010

A really good book with a precise insight into the real exam scenario. Really hope to ace my exam coming up in a few days time!
Great one!

Posted by Kamrul on Sep 8th, 2010

I was searching for this for long time. It's really helpful for new designed certification. Thanks SAP Press for publishing this valuable book.