Skip to main content

SAP BW Certification Exam

The exam contains 80 questions and the time allotted for this 3 hours.

Time duration is more than enough for 80 questions. The only thing you should have is Patience because you really get tired after reading all this questions and the respective 5 options for each question and that too confusing ones.
The exam is divided in to 6 sections. The first section is Extraction and in this section you have 16 questions.

The Second section is based on Reporting and this section contains the maximum number of question compared to other sections. The total numbers of questions in this section are 26. It test your knowledge completely on BEx tool. The note in BW CLASS INPUT FOR REORTING is really excellent. Make sure that you also go through REPORTING MADE EASY GUIDE. You don't have to go through all 500 pages. Just read chapters 3,4,6,7 and 8. It just takes 2 days to read these chapters in detail. When you read these guide try to work on the system as much as possible and build as many queries as possible. This will help you in remembering the concepts. Working on the system is really necessary because there are so many things which you can realize only when you build query. This will help you a lot when answering the question on reporting.

REPORTING MADE EASY GUIDE is based on BW 2.0B. But chapters 3, 4, 6, and 7 does not have as many changes compare to BW 3.0B. You will have to read some extra documents for chapter 8 (Reporting Agent) because it only covers Exceptions and Printing. You have to read some papers on CRYSTAL REPORTING, WEB TEMPLATE AND BOOKMARKS. Also, I followed all the point in BW CLASS INPUT for WAD and started working on the system.

The 3rd section is WARE HOUSE MANAGEMENT. This section contains 20 question.

The 4th section is Project. There are only 4 questions in this section and I think that u should not miss a single scoring
opportunity this section. The questions in these sections were like what steps are taken after a Blueprint? What all you do in analysis? How important the end users are while defining a data model.

The 5th section is Authorization. There are only 4 questions in this section and even in this section you should not miss a single scoring opportunity this section.

The last section is SAP BW Data Modeling. It contains 10 questions. Make sure that your concepts are clear for attributes, hierarchy and aggregates.
Labels:

Comments

Anonymous said…
how much mark did u score?i m taking the test in 2 weeks time.
May 27, 2011 at 9:04 AM
Anonymous said…
Nice description.but where i can get REPORTING MADE EASY GUIDE BW 2.0B book or notes.is it available online or is that any book.Could you please advice.i have to sit for exam in couple of months time.
Actually please tell me where to start reading for certification.I can see a ocean of things to read in front of me.please advice and how much is the pass mark----.kate
May 28, 2011 at 1:21 PM
Post a Comment

Popular posts from this blog

Step by Step guide on BADI with Filter implementation

Step 1 à Before implementing filter objects to a BADI. We need to deactivate all the implementation for that BADI. Go to SE18 (BADI definition) and from there navigate to all BADI implementation to view all the active implementations for that BADI Select the BADI implementations listed on the screen and deactivate the implementation. Once done, return back to the initial screen of SE18 and proceed with next step. Step 2 à go to SE18 – BADI Definition screen and change the existing BADI definition that we created in the earlier tutorial.   Select the FILTER –DEPENDENT check box under the TYPE section. This will open up the FILTER TYPE field for inputs. And do an F1 on the FILTER TYPE field. Click on the F4 on the FILTER TYPE field name and enter some search criteria to find a relevant data element. And click on the continue button   Select the data element from the list to set up your filter and hit enter. Click on the save butto...
1 comment
Read more

Create Data Source in SAP

Data Sources are extraction structure. Data Sources are used to extract data from various source system. In the below steps, we will see how to create a data source using a SAP table VBAK. 1) Execute transaction RSO2 2) Enter data source name to be created 3) Press Create 4) Enter description of the data source 5) Enter the name of table or view on which data source has to be created. Data Source can also be created using a View, Info set or a Function Module. 6) Save the data source 7) Execute RSO2 again and click Change 8) Select VBELN field as selection 9) Save the Data Source 11) To check whether data is getting extracted, execute transaction RSA3 12) Enter the name of data source as shown below and press 'Extraction' 13) An information message will appear stating no. of records fetched 14) Additional button 'Display list' will appear, press button 15) Select one of the data packet and double click to get records fetched 16) Data Source is ready to be used!
4 comments
Read more

Responsibilities of BW Data Architect

Responsibilities of an implementation project... For ex, Lets say If its a fresh implementation of BI or for that matter you are implementing SAP... First and foremost will be your requirements gathering from the client. Depending upon the requirements you will creat a business blueprint of the project which is the entire process from the start to the end of an implementation... After the blue print phase sign off we start off with the realization phase where the actual development happens... In our example after installing the necessary softwares, patches for BI we need to discuss with the end users who are going to use the system for inputs like how they want a report to look like and what are the Key Performance Indicators(KPI) for the reports etc., basically its a question and answer session with the business users... After collecting those informations the development happens in the development servers... After the development comes to an end the same objects are tested in quality...
1 comment
Read more