Product Description

The Ultimate Learning Guide for SAP BW Consultants With Certification Review Questions, Answers, and Explanations! It's clear that SAP BW is one of the most challenging areas in SAP. And learning can be difficult. SAP BW Ultimate Interview Questions, Answers, and Explanations guides you through your learning process. From helping you to assess your BW skills to evaluating candidates for a job, SAP BW Interview Questions will put you on the path to understanding what you really need to know. The book is organized around five areas of SAP BW: Extraction, Modeling and Configuration, Transformation and Administration, Presentation and Analysis, and finally, Performance Tuning. More than just a rehash of SAP documentation and sales presentations, each question is based on project knowledge and experience gained on successful high-profile SAP implementations. Key interview topics include: - The most important BW settings to know - BW tables and transaction code quick references - Certification Examination Questions - Extraction, Modeling and Configuration - Transformations and Administration - Performance Tuning, Tips & Tricks, and FAQ - Everything a BW resource needs to know before an interview

Product Details

• Amazon Sales Rank: #2451555 in Books
• Published on: 2005-12-27
• Original language: English
• Number of items: 1
• Dimensions: .42 pounds
• Binding: Paperback
• 144 pages

About the Author
Anurag Barua has over 13 years of experience in conceiving, designing, managing and implementing complex software solutions including 8 years of SAP experience. He has been associated with several SAP implementations in various capacities. He worked at SAP Labs for 5 years. Anurag¡¦s core SAP competencies extend beyond BW/BI and include FI/CO, Logistics, Netweaver, ABAP, SOX compliance, reporting, and project management. He has a B.S. in Computer Science from India and an MBA in Finance from the University of Maryland at College Park. Anurag lives in Germantown, Maryland with his wife and two children.

Excerpt. © Reprinted by permission. All rights reserved.
Question 1: Enhance Datasource
How do you enhance a Datasource?

A: Firstly, you need to create an append structure to the extract structure of a DataSource. You can do this by running transaction RSA6 or by running transaction SBIW and then executing the following configuration steps: 1. Postprocessing of DataSources 2. Edit DataSources and Application Component Hierarchy. This will take you to the screen with all the application nodes. You will have to expand each node until you get to the DataSource that needs to be enhanced. Place your cursor on this DataSource and click on the -Enhance Extraction Structure- button and create the append structure. Add the desired fields, save and activate the append structure. In order to populate the new fields, you need to add logic to SAP enhancement/customer exit RSAP0001 (in transaction SMOD). This exit/enhancement has 4 (function module) components: 1) EXIT_SAPLRSAP_001 for transaction DataSources, 2) EXIT_SAPLRSAP_002 for (master data) attribute DataSources, 3) EXIT_SAPLRSAP_003 for (master data) text DataSources and 4) EXIT_SAPLRSAP_004 for hierarchy DataSources. You will put your logic/code into an include. Since this single enhancement/exit is used for all DataSources, you will first need to check for the DataSource in your code (by using a CASE, WHEN, or IF conditionality).

For any source system running Web AS 6.20 or higher, you can enhance Business Add-In (BadI) RSU5_SAPI_BADI (in transaction SE19). You will have to create your own implementation and enhance method DATA_TRANSFORM (for all non-hierarchy DataSources) and HIER_TRANSFORM (for all hierarchy DataSources).