Solved: SAP BW Certification

SAP Managed Tags
Certification

Hello,

I am preparing for my coming up BW certification exam and I am looking for useful informtaion on what to prepare for the exam.

What are the courses that I need to cover for this? And I am also looking for some sample questions and sample exam format.

Could you please share any info you have and also your experience at the exam as what types of questions are expected and how was the difficulty level. I know the spread of the questions (datamodeling +++, Reporting +++ etc)

Thanks

John

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Dear All,

I am preparing for SAP BW Certification.

I am studying the book:

SAP BW Certification by Catherine M. Roze

ISBN # 0471236349

Is this book enough / perfect for exam ??

How do i prepare for exam ? Pl. guide me.

Thank you in advance.

Krutika

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Patel,

That book is outdated and would be of no help .. but one thing is for sure, it would surely give u the feel of the questions. Try to get the material from SAP LABS, that would be really helpful.

Cheers,

Mav.

Hello all,

I recently finished my 3.0B certification and here is my take on it.

I started my preparation 4 weeks before the exam and read SAP courses 305, 310, 315, 330, 340, 350 and 365 and nothing else. I strongly suggest not to read Catherine Rose book and read only SAP material. These courses are sufficient to clear the exam. The only other stuff that you need to read other than this is on ASAP methodology. Again, you only get 4 questions on this, out of these you can answer 2 without reading this material. So, if you don't have time, you can skip this completly. Follow this link for a neat presentation on ASAP. http://www.soi.city.ac.uk/~pauline/?cont=4

You can expect a question from any corner of this material. For example, I got 3 easy questions on what is contained in "Metadata repository". "Data modeling" and "Reporting" carry maximum share of the marks. In reporting, concentrate on the types of variables, calculated keyfigures, restricted key figures, restriction options you have in creating conditions and exceptions. Here is some of the Info that I remembered from the exam

1. What are the contents of Metadata repository?

2. What objects you see in Metadata repository? Only

business content or all active objects?

3. 4 questions on Authorizations. Read the specified

topics in 365.

4. 4 questions on ASAP methodology. read the above

specified material and you should be good.

5. 24 questions in BEx. Cell Editor, AdHoc query

designer, currency conversion, structures etc. Some of

them are very straight forward....some might be

tricky. Read 305 and you should be good there. I guess

this is the easiest part.

6. Around 20 questions in Extractions. delta queues,

initialization, testing in RSA3, activities that you

can do from LBWE etc....They did not ask anything in

LIS extraction although it is included in the

syllabus. There were a few questions in CO-PA, like

what is safety delta etc...

7. A Few questions in data modeling, and about 15-20

questions in InfoObjects-InfoCubes.

8. Can you build a multiProvider on an ODS and

infoObject? Or, should there be atleast one InfoCube?

9. Can you build InfoSet on one or more Infosets? things

like that...

You will have 3 hours to finish the exam, which I think is much more than enough. I finished mine in 1:30 minutes. This is a real easy exam once you read all the courses specified above.

Good luck

John

PS:For practice, you might just want to refer to the questions from Catherine Rose book. but, don't remember answers from it or don't read the material. some of the answers were wrong.

Message was edited by: Gova Mabbu

Thanx Maverick...

How can I get material from SAP LABS ?? I heard that after certification only person can be member of SAP LAB !!!!

can help me to get material ?

I appreciate your guidance.

Message was edited by: Krutika Patel

Hi John,

Thanx for your advise. U listed number of courses for exam. where did u get material for these courses ???

OR another words where can i get all the course material u listed ???

hi john ,,

this is arindam from india ,, i am going to take up the BW Certification Exam,, shortly ,,

request you ,, if you can pls share with me the soft copy of the soft copy of the SAP Training materials ,,

pls do mail me at my email id [email protected]

hope you will do the needfull,,

thanks and regards

arindam

hello all,

The info given here is what i was looking for before taking a test.These things encourage the exam takers definetly.

but the link http://www.soi.city.ac.uk/~pauline/?cont=4

given by Gova Mabbu doesnt seem to open up any documents related to ASAP. Can you please resend the link.

thanks

sujan

My friend followed John/Gova's instructions exactly as mentioned and cleared the exam with 83%. Just go through all mentioned course materials and you should do good. In fact my friend does not have any other book/material other than the course material. For ASAP, use below content. My friend said that 75% (3 out of 4) of ASAP questions were based on this.

The BW Project guidelines can be as follows ,

Stages in BW project

1 Project Preparation / Requirement Gathering

2 Business Blueprint

3 Realization

4 Final Preparation

5 GO Live & Support

1 Project Preparation / Requirement Gathering

Collect requirement thru interviews with Business teams /Core users / Information Leaders .

Study & analyze KPI 's (key figures) of Business process .

Identify the measurement criteria's (Characteristics).

Understand the Drill down requirements if any.

Understand the Business process data flow if any .

Identify the needs for data staging layers in BW – (i.e need for ODS if any)

Understand the system landscape .

Prepare Final Requirements Documents in the form of Functional Specifications containing :

Report Owners,

Data flow ,

KPI’s ,

measurement criteria’s,

Report format along with drilldown requirements .

2 Business Blueprint

Check Business content against the requirements

Check for appropriate

Info Objects - Key figures & Characters

Check for Info cubes / ODS

Check for data sources & identify fields in source system

Identify Master data

document all the information in a file – follow standard templates

Prepare final solution

Identify differences (Gaps) between Business Content & Functional

specification. propose new solutions/Developments & changes if required at different levels such as Info Objects ,Info cube , Data source etc . Document the gaps & respective solutions proposed– follow standard templates

Design & Documentation

Design the ERD & MDM diagrams for each cube & related objects

Design the primary keys/data fields for intermediate Storage in ODS

Design the Data flow charts right from data source up to Cube .

Consider the performance parameters while designing data models

Prepare High level / Low level design documents for each data model.--- follow standard templates

Identify the Roles & Authorizations required and Document it – follow standard templates

final review of design with core BW users .

Sign off the BBP documents

3 Realization

Check & Apply Latest Patches/Packages ...in BW & R/3 systems.

Activate/Build & enhance the cubes/ODS as per data model designs...maintain the version documents .

Identify & activate Info objects / Master data info sources / attributes ,prepare update rules

Assign data sources .prepare transfer rules , prepare multi providers . prepare Info packages .

perform the unit testing for data loads….both for master data & transaction data .

develop & test the end user queries .

Design the process chains ,schedule & test

create authorizations / Roles …assign to users ..and test

Apply necessary patches & Notes if any .

freeze & release the final objects to quality systems

perform quality tests .

Re design if required . (document changes, maintain versions)

4 Final Preparation

Prepare the final check list of objects to be released .identify the dependencies & sequence of release

perform Go Live checks as recommended by SAP in production system

keep up to date Patch Levels in Production system

Test for production scenarios in a pre-production system which is a replica of production system .

Do not Encourage the changes at this stage .

freeze the objects .

5 GO Live & Support

keep up to date Patch Levels

Release the objects to production system

Run the set ups in R/3 source system & Initialize Loads in BW

Schedule Batch jobs in R/3 system (Delta loads)

schedule the process chains in BW .

Performance tuning – on going activity

Enhancements - if any

Hi,

I'm actually going for my BW3.5 certification exam without attending TBW45 BPS course. I do have the notes from my friend, but the material is a alot to read.

My questions are:

1. How many BPS questions are there?

2. What kind of questions are asked for the BPS section? Concepts? Technical? Anyone can give me some sample questions?

Thanks,

Hi CK,

When I sat the BW3.5 exam, there was 8 questions on BPS (10% of the exam).

You can find the weighting assigned to each subject for the certification exam at <a href="https://websmp203.sap-ag.de/certification">https://websmp203.sap-ag.de/certification</a>

The weighting for BPS is ++ (10-19%) so in theory, you could get max of 15 questions.

Hope this helps. Good luck.

Cheers,

Rog

hi arindam,

i am preparing to learn BW can you please send to me a soft copy of SAP Training Material

My mail id [email protected]

Thanks for your reply

Regards

Waleed

Hey walled,

i am core basis guy implementing BW. please if u got the PDF files do send to me at [email protected].

It would be grate help boss.i am in need.

Best Regards,

Ajit

Hi,

Thanks for sharing the information....The link U sent for ASAP is not working.....Search doesnt work too...

Hi John,

The link for ASAP Methodology is not working...Can U help

Thanks

can you send me the blue print doc. as well? my email id is [email protected]

How can I get material from SAP LABS ?? I heard that after certification only person can be member of SAP LAB !!!!

can help me to get material ?

I appreciate your guidance.

Hi Gova,

I'm giving the exam this month, can you please send the 340 material, as I couldn't get any where else.

My id [email protected]

Highly appreciate your help.

Thanks, Panci

Where do I find these SAP courses 305, 310, 315, 330, 340, 350 and 365? I am currently reading 310 pdf and step-by-step by fu&fu. Please email me at <email taken out> regarding the courses mentioned above. thanks

Message was edited by: Mark Finnern

Email address taken out.

He SDNers,

Again, these course materials are copyrighted and on SDN we don't tolerate the exchange of these.

I have taken your email address out of your post.

Just don't do it, Mark.

Hello Everone, Here are some general questions that I have gathered. These are NOT Copyrighted Material. If there is a problem with these please let me know, and also note that these have been compiled from various sources so the grammer is not all that great. IF YOU FIND any of the answers to be wrong please do let me know. I have many more if needed.

1. What are the extractor types?

• Application Specific

o BW Content FI, HR, CO, SAP CRM, LO Cockpit

o Customer-Generated Extractors

LIS, FI-SL, CO-PA

• Cross Application (Generic Extractors)

o DB View, InfoSet, Function Module

2. What are the steps involved in LO Extraction?

• The steps are:

o RSA5 Select the DataSources

o LBWE Maintain DataSources and Activate Extract Structures

o LBWG Delete Setup Tables

o 0LI*BW Setup tables

o RSA3 Check extraction and the data in Setup tables

o LBWQ Check the extraction queue

o LBWF Log for LO Extract Structures

o RSA7 BW Delta Queue Monitor

3. How to create a connection with LIS InfoStructures?

• LBW0 Connecting LIS InfoStructures to BW

4. What is the difference between ODS and InfoCube and MultiProvider?

• ODS: Provides granular data, allows overwrite and data is in transparent tables, ideal for drilldown and RRI.

• CUBE: Follows the star schema, we can only append data, ideal for primary reporting.

• MultiProvider: Does not have physical data. It allows to access data from different InfoProviders (Cube, ODS, InfoObject). It is also preferred for reporting.

5. What are Start routines, Transfer routines and Update routines?

• Start Routines: The start routine is run for each DataPackage after the data has been written to the PSA and before the transfer rules have been executed. It allows complex computations for a key figure or a characteristic. It has no return value. Its purpose is to execute preliminary calculations and to store them in global DataStructures. This structure or table can be accessed in the other routines. The entire DataPackage in the transfer structure format is used as a parameter for the routine.

• Transfer / Update Routines: They are defined at the InfoObject level. It is like the Start Routine. It is independent of the DataSource. We can use this to define Global Data and Global Checks.

6. What is the difference between start routine and update routine, when, how and why are they called?

• Start routine can be used to access InfoPackage while update routines are used while updating the Data Targets.

7. What is the table that is used in start routines?

• Always the table structure will be the structure of an ODS or InfoCube. For example if it is an ODS then active table structure will be the table.

8. Explain how you used Start routines in your project?

• Start routines are used for mass processing of records. In start routine all the records of DataPackage is available for processing. So we can process all these records together in start routine. In one of scenario, we wanted to apply size % to the forecast data. For example if material M1 is forecasted to say 100 in May. Then after applying size %(Small 20%, Medium 40%, Large 20%, Extra Large 20%), we wanted to have 4 records against one single record that is coming in the info package. This is achieved in start routine.

9. What are Return Tables?

• When we want to return multiple records, instead of single value, we use the return table in the Update Routine. Example: If we have total telephone expense for a Cost Center, using a return table we can get expense per employee.

10. How do start routine and return table synchronize with each other?

• Return table is used to return the Value following the execution of start routine

11. What is the difference between V1, V2 and V3 updates?

• V1 Update: It is a Synchronous update. Here the Statistics update is carried out at the same time as the document update (in the application tables).

• V2 Update: It is an Asynchronous update. Statistics update and the Document update take place as different tasks.

o V1 & V2 don’t need scheduling.

• Serialized V3 Update: The V3 collective update must be scheduled as a job (via LBWE). Here, document data is collected in the order it was created and transferred into the BW as a batch job. The transfer sequence may not be the same as the order in which the data was created in all scenarios. V3 update only processes the update data that is successfully processed with the V2 update.

12. What is compression?

• It is a process used to delete the Request IDs and this saves space.

13. What is Rollup?

• This is used to load new DataPackages (requests) into the InfoCube aggregates. If we have not performed a rollup then the new InfoCube data will not be available while reporting on the aggregate.

14. What is table partitioning and what are the benefits of partitioning in an InfoCube?

• It is the method of dividing a table which would enable a quick reference. SAP uses fact file partitioning to improve performance. We can partition only at 0CALMONTH or 0FISCPER. Table partitioning helps to run the report faster as data is stored in the relevant partitions. Also table maintenance becomes easier. Oracle, Informix, IBM DB2/390 supports table partitioning while SAP DB, Microsoft SQL Server, IBM DB2/400 do not support table portioning.

15. How many extra partitions are created and why?

• Two partitions are created for date before the begin date and after the end date.

16. What are the options available in transfer rule?

• InfoObject

• Constant

• Routine

• Formula

17. How would you optimize the dimensions?

• We should define as many dimensions as possible and we have to take care that no single dimension crosses more than 20% of the fact table size.

18. What are Conversion Routines for units and currencies in the update rule?

• Using this option we can write ABAP code for Units / Currencies conversion. If we enable this flag then unit of Key Figure appears in the ABAP code as an additional parameter. For example, we can convert units in Pounds to Kilos.

19. Can an InfoObject be an InfoProvider, how and why?

• Yes, when we want to report on Characteristics or Master Data. We have to right click on the InfoArea and select “Insert characteristic as data target”. For example, we can make 0CUSTOMER as an InfoProvider and report on it.

20. What is Open Hub Service?

• The Open Hub Service enables us to distribute data from an SAP BW system into external Data Marts, analytical applications, and other applications. We can ensure controlled distribution using several systems. The central object for exporting data is the InfoSpoke. We can define the source and the target object for the data. BW becomes a hub of an enterprise data warehouse. The distribution of data becomes clear through central monitoring from the distribution status in the BW system.

21. How do you transform Open Hub Data?

• Using BADI we can transform Open Hub Data according to the destination requirement.

22. What is ODS?

• Operational DataSource is used for detailed storage of data. We can overwrite data in the ODS. The data is stored in transparent tables.

23. What are BW Statistics and what is its use?

• They are group of Business Content InfoCubes which are used to measure performance for Query and Load Monitoring. It also shows the usage of aggregates, OLAP and Warehouse management.

24. What are the steps to extract data from R/3?

• Replicate DataSources

• Assign InfoSources

• Maintain Communication Structure and Transfer rules

• Create and InfoPackage

• Load Data

25. What are the delta options available when you load from flat file?

• The 3 options for Delta Management with Flat Files:

o Full Upload

o New Status for Changed records (ODS Object only)

o Additive Delta (ODS Object & InfoCube)

Hi Sun Dav,

The questions and answers are very useful. Request you to please sned me some more sample questions, I'm planning to give 3.5 certification in this tech ed.

Your faster response will be appreciated. Thanks in advance.

my mail-id is [email protected]

Regards,

Minal

Hi Sun Dav,

The information is very helpful. Can you please email more to my email - [email protected].

Thanks,

Liu Jia

Thanks!

null

Hi Sun Dav,

Would you please send these BW certification materials to me soon? I would appreciate it very much as I would be taking the BW certification in 2 weeks time... My email add: [email protected].

Thanks and Best Regards,

Lee

Hi Dav,

Can you send me more questions ... I'm planning to appear for the certification exam next week. These questions are really good.

Thanks & Regards,

Abir

[email protected]

Dear Sun Dav,

Thanks a lot for posting those questions, do mail me more if you have, on my mail id [email protected].

One more thing I would like to inquire about certification that how they calculate final score of exam, as there is no negative marking and all correct answers are awarded with points.

And what should be the straetgy for taking BW 3.5 certification?

Hi Sun Dav,

I just saw the sample questions u posted on here,can you kindly send more of this questions with answers to my email address [email protected].

I will be taking the BW3.5 in a couple of days.

Thank you

Hi, sun dav,

Your info is really useful for me. I am taking the BW exam in this week. Can you please send me more questions to [email protected] before this Friday?

Thanks a lot,

Helen

Hi Sun Dav,

I would appreciate it if you can send me more sample questions/materials, as I am taking the BW certification exam soon. My email: [email protected].

Thanks,

Roger

hi gova

can you tell me about Data ware housing BW310 and Modelling BW330?

My instructor gave me only BW310.

is it enough to cover modelling

i have BW350(extraction) and BW305(reporting)

do i have to read BW330?

its covers same content or different?

if you have BW330 or BW365 can you send to me on [email protected]?

thnx in advance.

Hi ,

These Questions are very useful . Thanks for posting these questions . Please sene me if you any such kind of stuff .

Please send me to the following mail ID

[email protected]

Thanks in advance once again ,

RaviChandra.G.

Hi Sun Dav,

I would appreciate it if you can also send me more sample questions/anwers, as I am taking the BW certification exam soon. My email: [email protected].

I have also alot of material that may interest you....

Thanks,

Ralph

Hi,

I would really appreciate if someone can send me some material/sample questions as I am taking the SAP NW 2004s - BI Certification soon. My email: [email protected]

Thanks,

Folks, I am brand new to this & it is my 1st message. I still haven't figured out how to post a new message. Can someone help me in this as I have questions to ask? Also I am preparing for BW certification but don't know which one to give ie 3.0B or 3.5 or NW BI 2004s and also how long it typically takes. Can some one please provide details where I can get material for this. Thanks a lot in advance.

Thx

Hi Sun Dav,

The questions and answers are very useful. Request you to please send me more questions.

My Email id is [email protected]

Thanks in advance.

Regards,

Poonam

Hi Everyone,

As Sun Dav pointed out there is a page with available certification examen:

http://www50.sap.com/useducation/certification/examcontent.asp

Everything else is copyright violation and a disgrace to the community here and this is why this thread will be locked.

Best, Mark.

Ask a Question

Top Q&A Solution Authors

User

Count

By Category

Related Content

Activity Groups

Industry Groups

Influence and Feedback Groups

Interest Groups

Location Groups

Customer Only Groups

Forums

Related Resources

Products

Learning and Support

About

My SAP Profile

My SAP Profile

Know the answer?

Need more details?