cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BW Certification

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi John !

take a look in the SAP Service Marketplace to check which courses are a prerequisite and the current list of topics that are covered.

http://service.sap.com/certification

...here you can find also a nice test simulator in order to train your-self.

The questions are confidential and can not be shared (SAP says), but a few time ago I posted some sample questions that you can find in this forum if yo search with the key word 'certification' (in Aug 31)...these questions are a little outdated, but you can consider them a good starting point.

Good luck for your next exam (and don't forget to le tet me know if you'll officially become a 'BW Guru' !!!

Bye,

Roberto

Former Member
0 Kudos

Dear Roberto,

I am also preparing for the exams. Pls could u provide the answers to the your posted samples? Some are tricky questions. Its really great that helpful people like you exist.

I am also seeking your advise based on your experience.

Should I stick to the cirriculum to safe time? Is the curriculum meant as a guide to the study for the exams?

Would topics not found in it pop up, eg. CRM extraction, Archiving, FI-SL, DataStage?

I realise that 100% preparation (remembering facts) is not possible after so many months of study & may not be sufficient to tackle all the questions. So, some guidance would be great.

Appreciate if u could share some of your experience.

Regards,

George

gmaracas@yahoo.com

Former Member
0 Kudos

Hi Roberto,

I am planning to attend for BW 3.5 Certification,

and i had seen in ur message that u gave some details about exam in some message in AUG 31 but i could not find any such messages with search word Certification..Could u please give that exact link ...

Thanks & Regards,

BRB

Answers (34)

Answers (34)

Former Member
0 Kudos
Former Member
0 Kudos

Hi

I am new to this forum but from what i can see members from this forum group are very helpful. I am preparing for SAP BW3.0B certification exam next month and i will appreciate it if you can help with more questions and answers to prepare for this exam. If you have anything at all that will help, please can you mail it to me at julius-dairo@hotmail.com

Thanx

Juls D

Former Member
0 Kudos

Hi

If you are planning to appear for BW certification do take a note on the topic distribution in BW and their weightage it'll help you in your preparation.

The link for that is

https://websmp108.sap-ag.de/~sapidp/011000358700003595342004E

Regards

Yogender

Former Member
0 Kudos

I recently appeared for the BW Certification exam.

I like to share my experience with you'll guys ....

I've some questions ..... do mail me at

<u>abir.biswas@rediffmail.com</u>

Regards,

Abir

moha_nan
Participant
0 Kudos

Hi,

I would really appreciate if someone can send me sample questions/materials, as I am taking the C_TBW45_045: SAP NetWeaver 2004s - Business Intelligence Certification soon. My email: kukku@gmx.de

Thanks,

Former Member
0 Kudos

Hi Gova/Roberto/Dav

Greetings...

I am planning for BW certification through TechEd, your suggestions are really helpful, Thank you, Thanks a lot.

Regards

Lasya

Former Member
0 Kudos

Hi Peter -

Can you please send me the material - I am interested. Let me know how much is it. My email is narmeen.ali@gmail.com

Thanks!

Former Member
0 Kudos

Hi Sun Dav,

The information is very helpful. Can you please email more to my email - gofordhaval@yahoo.com.

Thanks,

Dhaval

Former Member
0 Kudos

Hi Peter

I am interested in buying the BW 3.5 certification material. Could you please mail me the expected price on gofordhaval@yahoo.com.

Thanks

Dhaval

Former Member
0 Kudos

hi all gurus,

anyone who took the certification recently, guide me to prepare for certifictaion for BW3.0 i shall be taking shortly.i would really appreciate the help.i need good guidence

thank u in advance

Former Member
0 Kudos

Hi,

Can I have some material for BW certification?

AV

Former Member
0 Kudos

I am planning to do SAP BW Certification. But I don’t know which one of the following I have to do.

1) SAP NetWeaver´04 - Business Intelligence (

C_TBW45_04

)(Certification - Solution Consultant)
2) SAP NetWeaver´04 - Business Intelligence Technology(

C_TADMBO_04

) (Certification - Technology Consultant)

Or I have to wait for SAP BI</b> Certification, that I heard, would come after November 06, which is for <b>version 7</b>.

Please clear my doubts

Former Member
0 Kudos

Check this one out for BW 3.0 it's C_TBW50, and for BW 3.5 it's C_TBW45_04 (Follow this link)

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

Former Member
0 Kudos

HI Sun Day : These questions are very helpful. Can I have more? I am thinking of taking BI7 certification exam. That would of help. Thanks. dalilkhan@yahoo.com.au

Former Member
0 Kudos

Is there no material at all regarding BW certification 3.5? ( including BPS) And I mean example of questions, not the training material.

Former Member
0 Kudos

Hello Oka/ Ravi,

Could you guys please help me out by sending those relevant docs and mock tests(for certification) to veeall@gmail.com

thanks in advance,

partha

Former Member
0 Kudos

Hi there,

I am new to forum. I have SAP 310 and 305 but i do not have files or examples they have used to create all Demo Objects (Flat files). Does somebody have it? Pl. email at vjoshi@cinci.rr.com

Former Member
0 Kudos

Can you pass me on the BW certification material you have please? I am very new to SAP as well as this forum.

Thx

Former Member
0 Kudos

Hi Gova,

I just finished my training in SAP BW.I am thinking to give certification soon.Is it necessary to take certification to get job?Apart from that it would be great if u can tell me more about the certification .I went thru the posts and thought would write a mail and ask u some questions.Please guide me.

Thanks a lot.

My emailid is gotginshock@yahoo.com

Former Member
0 Kudos

At considerable cost to myself, I just recently went and attended the SAP BW 3.5 Training Academy (5 weeks of intensive training) and will hopefully be sitting the BW Cert exam in the next few weeks.

I have all the training material you need to get certified in BW, along with the SAP software so that you can setup a full training system and Study for the exam in your own time at your own pace at home!

I'd be willing to sell all my training materials to help offset the cost of paying for the course, if anyones interested please feel free to contact me for more information.

Former Member
0 Kudos

Hi Peter,

I need the material how much you would expect for? please reply to kala_maani@yahoo.com

Former Member
0 Kudos

Hi Peter Rai

Can you tell me how much you require for the BW certfication material email at byaso@yahoo.com

Message was edited by: Brian Yaso

Former Member
0 Kudos

z

z

Former Member
0 Kudos

Hi,

I am interested with SAP/BW materials...let me know the price?

Thanks

Former Member
0 Kudos

Hi all

i Rajendraprasad new user for this group iwant to know details againest SAP BW can u please help me on the same

pls mail me to : narrarajendraprasad@gmail.com

Former Member
0 Kudos

Can U help me regarding material, How much you charge? Is it soft copy? What type of payment mode you prefer? Looking for your reply

Former Member
0 Kudos

Hi Peter,

I need the material how much you would expect for? please reply to renzhiqian@yahoo.com

Former Member
0 Kudos

hi peter, m interested in getting SAP material. Pls mail me at erp.genie[at] gmail.com. thnx

Former Member
0 Kudos

Hi Peter,

Could you please email me at sapbiconsultant@hotmail.com? I am interested in purchasing the BW material.

Thanks

Pete

Former Member
0 Kudos

Hi Sunsea,

I am interested in this as well. Can you please email the materials to me kitty.qiu@gmail.com?

Thanks for your help.

Regards,

Yaoyao

Former Member
0 Kudos

Hi Peter,

I'm interested in buying all your materials.

If you still have or want to sell them, please email me at seong17@hotmail.com

Thanks,

Former Member
0 Kudos

Any exam help is appreciated. I am taking the exam soon.

My email is randall@randallthorne.com

Former Member
0 Kudos

Could anyone please provide me link and documents related to SAP BW certification (3.5) . I am planning to give exam in Jan 2006 . Please guide me accordingly.

Former Member
0 Kudos

Dear BW consultants,

Could anyone send me SAP BIW [3.5]certifcation exam related documents. Very soon I am going to take exam.

and assist me the procedures to be follow.

Please send documents to my ID :kvetrilatha@gmail.com

thanks in advance

hema

RogerTaylor
Explorer
0 Kudos

link no longer active

Former Member
0 Kudos

Hi Mova,

Iam unable to open the presentation link which you sent. Iam going to take the exam shortly. So Mova, if you have time can you please send the docs. to this ID: polineni_26@yahoo.com

Thanks in Advance,

Xys Redd.

Former Member
0 Kudos

Can you please send it me at learnsapbw@gmail.com please

Former Member
0 Kudos

Hi ,

I am preparing the certification in BW and would like to know if there is a test simulator in the sap online help (or anywhere) and how can I get there.

Thanks in advance

Federico

Former Member
0 Kudos

Hello All,

Can someone guide me that, the material BW360 - Performance - is it important for exam?

I remember one of the member suggested that the Authorization is not that important....What about the Performance ???

Thank You

Ashwin
Active Contributor
0 Kudos

Hi macho!

there were not many questions from performance when i attended this exam. And performance is not listed in examination topics for solution consultant. It is better to have some basic knowledge of performance but not soo important.

form authorizations you can expect at least 2 to 3 questions.

with regards

ashwin

claudio_ciardelli2
Participant
0 Kudos

You can change all your answers as long as you do not exit the exam.

My technique is to quickly go through all questions so that i answer the ones that I am sure. This takes about 1 hour. After that, start over from the beginnning and complete the questions that take more time. Leave unsure answers for the end.

Once that is done review every questions, for the ones you have no clue, try guessing or fill them all (as there are no negative points). WHen I go through this 3d time, I count on a paper the number of questions I am sure of or not. If you have more than 50% sure answers things should be going well.

Former Member
0 Kudos

Hi All,

I have one question reg. grade sys for BW Certification.I know it's multiple choice and some one mentioned in one of the forum that they do let us know if the question has multiple answers or single answer. If the question has multiple answer and by mistake if I mark just 3 of them while in real question has 5 answers then how they grade ?? will my answer be wrong ? Or I get credit for those 3 correct answers I marked..??

Or in another situation if from 5 correct answers if I makred 2 wrong then how they grade it ?? will it be completely wrong or I get credit for rest 3....

Some one pl. guide me.... thank you...

claudio_ciardelli2
Participant
0 Kudos

With multiple choice questions, each individual answer gives you points. The wrong answers do not remove points. Thus, with a 5 answers multiple question with more than one answer

where you would have answered 3 of them correctly, you would get the points for those 3 and lose nothing for the 2 wrong answers.

This means that in a question where you are told that 2 or more answers are correct you should always check between 2 and all answers.

This is the experience I have of MM and FI/CO certifications, but I assume all tests are made up similarly.

What is not clear however is the point value of the individual answers in a multiple choice compared to that single answer in a "Only one answer is correct" questions.

I suspect that the latter are given a greater weight in the final calculation ?

Former Member
0 Kudos

Thanx Claudio,

That means when u see that it is mention that question has multiple answers and if u r not sure about answers then just check all the options ...for the safe side as there is no negative grading.... right ???

Also, I m not familiar with the exam environment...i know it is computer based. but after finshing all 80 questions can i go beck and check all the answers...?? or once i makred the answer that means i can not edit my answer later???

Thank you for your answer..

Former Member
0 Kudos

Can somebody explain me difference between Delta Upload, Full upload and init upload ???

Awaiting for reply.....

Thank You

Former Member
0 Kudos

A full upload is what is says. All data (within given selection) is loaded.

An init upload will trigger a delta. When you want to load with delta's (given the datasource/infosource used is supporting it) you first have to do an init load.

First after the init load you can load with delta's. (only "changed" or new data).

It's possible to do an init load without data transfer. E.g. only data from a certain point in time is necessary.

It's also possible to switch from full upload scenario's to delta upload (some notes exist, you'll find them in OSS)

Best Regards,

René

Former Member
0 Kudos

BW 3.5 Certified Gurus,

1)could you share your views, and suggest the SAP materials to study for 3.5 in addition to 3.0B materials.

2)Kindly mention any specific course material offered by SAP for 3.5 version.

3)Is it possible to take BW 3.5 exam directly without taking the SAP Course?

Thank you.

Former Member
0 Kudos

Hi René,

I don't have access to OSS notes. I would appreciate if you can mail me.

My mail id is sudheerch@intelligroup.com

Regards,

Sudheer

Former Member
0 Kudos

Hi Gova Mabbu (John),

could you please get in touch with me at chirunavvutho at gmail dot com. I just have a few questions on the exam.

I really appreciate your effort of posting your experience.

-

TS

Former Member
0 Kudos

Hi Gova Mabbu,

could you please send an email to travelling_soldier@hotmail.com

Former Member
0 Kudos

I have a query regarding certification.Do we have to go thru BW-360(performance) from the bw certification.

Former Member
0 Kudos

Denzil,

No. You don't need BW-360 for your certification. I am certain on that.

Thanks

Gova

Former Member
0 Kudos

Hi Gova,

a small query on certification.in one of ur posts u have mentioned about the topics.I am going thru BW-365(Authorization).U have mentioned that just go thru the relavent topics.Can u tell me which all topics shld i go thru in BW-365.

regards

Denzil

Former Member
0 Kudos

Denzil,

I am sorry but I don't remember the topics. All i can remember is that, I read the whole material once, but concentrated on only 3 or 4 chapters in that. I can answer if I see the material, which I dont have with me as of now...Will look into it and let you know.

Gova

Former Member
0 Kudos

Hi

i am planning to do sap bw certification . can any one suggest me

1)which material to follow and where i can get them.

2)online tutorials

Regards

srinu

Former Member
0 Kudos

I have few questions regarding Certification from the topic Data Modelling. Can anyone answer please ??? I am confuse in the answers.

1) Which of the following is an example of a slowly

changing dimension ?

a. Customer on a Sales Order

b. Date

c. Person responsible for a cost center

d. Value of a purchase order

e. None of the above

2) If you worked for a retail company that changed prices

on a very frequent basis how would you model the price

?

[can somebody explain me the ansers also ?]</b>

a. In the master data table as an attribut

b. In the transaction table as a new characteristic

c. In the ODS to enhance performance

d. In the fact table

e. None of the above

3) Which of the following occurs as a result of

degenerating dimensions ?

a. The grain of the fact table represents actual working

documents like order number or invoice number

b. All descriptive attributes of the grain are located in

other dimensions

c. the infocube becomes very weak and performs poorly when

it is run

d. The degenerating dimensions cannot be modeled using

normal star schema

e. None of the above

4) Which of the following describes an unbalanced

hierarchy ?

a. A hierarchy with too many leaves within one branch

b. A hierarchy with fewer nodes within one or more

branches

c. Hierarchy without leaves

d. The term used for data that are delivered from two or

more sources on different aggregation levels

e. None of the above

5) Hierarchy Can be which of the following ?

a. Time - dependent name

b. Version dependent

c. With intervals

d. Time- dependent structure

e. Used by multiple infocube

f. None of the above.

-


> Answers in book are b,c,d (can someone explain what is with

-


> interval hierarchy ?)

6) Name the three differences between OLAP and OLTP

systems?

a. Software used

b. Current data versus history required

c. One to two months of data versus two to seven years of

data

d. Detailed transaction data versus summarized data

e. None of the above

7) Sometimes we have to combine unrelated characteristics

into one dimension, due to which of the following facts

?

a. We runout of dimensions and we have to include the data

in the same infocube

b. We are running out of space on the database

c. We are looking for higher performance

d. Lower number of dimensions is a way to optimize data

staging

e. To reduce the number of joins

f. All of the above

😎 What are the limitations of Remote Cube?

a. Additional requirements for extractions

b. Slow

c. System dependent

d. Only for transaction data

e. Small volume

Thank You in advance.....

Former Member
0 Kudos

1) c.

2)b. (to calculate the total amount..as well to compare the prices..)

3) a, b (not sure exactly)

4) refer to help..you can get the definition..

5) b,c,d

6)e

7) f

😎 a ,b,c,d,e

Regards,

Manga

Former Member
0 Kudos

who r u to delete my post ???????????/

Dhhhhh.... i haven't give the exam yet those questions were from one of the practice book and i was confuse about the answers so I had asked. i m preparing for exam.

if u didn't want to answer then don't ...u don't have to but have no right to delete anybodys post ...

pl. put back all my questions... i spent long time to wrote those questions.

Former Member
0 Kudos

Ok guys,

SAP Training material is copyrighted, so anyone please avoid to share it.

Mark Finnern says "actually to share the certification questions that are asked is also not really allowed, but I leave it out there for the SDN Members to learn from".

Then Marc Bernard arrives and says "you must not share or discuss certification items. They are confidential and anyone, who has taken the exam has signed a statement that they would not do so".

I don't know if you have ever seen a movie entitled "The Good, the Bad and the Ugly" (Il Buono, il Brutto e il Cattivo in Italian, the original language) by Sergio Leone (1966)...(if not, watch it !) and I don't want to proceed to the identification of the 'suspects' with a who-is-who game (let me know what's your opinion!), but if we can post some sample question, let us post with no censure (that, even if legitimate and in accordance to rights granted by law, is not so pleasant..)

otherwise, please DELETE ALSO MY POST and any previous one so we can settle things once and for all !

Bye,

Roberto

Former Member
0 Kudos

Hi Macho,

As the questions you asked were on similar lines to those asked in certifcate exam so moderator deleted the answers which I gave for it as well as your questions..

If you are not clear with the concepts request you go through the training material..each of the questions has got answers with in the material itself.

ALL THE BEST.

Regards,

Manga

former_member93896
Active Contributor
0 Kudos

Dear All,

let me quickly introduce myself. I work for the SAP NetWeaver Regional Implementation Group and I am one of the moderators of the BI forums.

I apologize for deleting the questions. After further review of the issue I have posted the Q&A back into the forum.

Although this is an open and free forum, the site is hosted by SAP and some rules apply. It should be clear to everyone that SAP can not tolerate any illegal activities here. So please refrain from doing so.

Some final words about the Q&A that I had deleted (and reposted by now): The posting does not indicate in any way that those are sample questions and not specific certification items (including the multiple choice format). When studying for the exam, Q&A like this might be helpful. However, the only reliable sources are SAP training material and documentation since the certification items are fully based on them.

Regards,

Marc Bernard

SAP NetWeaver RIG, US BI

Former Member
0 Kudos

You mean hard copy (paper copy)?

Former Member
0 Kudos

You need to attend the the classes (BW310, BW365 etc.)for the material. The training material in a soft copy form is not avaialable in the public domain for purchase or otherwise. Stuff like Reporting Made Easy Guide is available for purchase.

Former Member
0 Kudos

Material in soft copy may also be obtained from persons who attended training from SAP.

former_member374
Active Contributor
0 Kudos

Hi Ravi,

The SAP Training material is copyrighted. You are not allowed to copy and share it.

If you want that material attend the class.

I haven't done this in a while and don't like it, but I deleted a couple of posts in that regards here.

Actually to share the certification questions that are asked is also not really allowed, but I leave it out there for the SDN Members to learn from.

Hope you understand, Mark.

Former Member
0 Kudos

At this point people may want to consider taking only the BW 3.5 certification. There is also a BW 3.5 delta for people who are BW 3.0 certified.

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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 mailarindammukherjee@gmail.com

hope you will do the needfull,,

thanks and regards

arindam

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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,

CK

RogerTaylor
Explorer
0 Kudos

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

0 Kudos

hi arindam,

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

My mail id waly256@yahoo.com

Thanks for your reply

Regards

Waleed

Former Member
0 Kudos

Hey walled,

i am core basis guy implementing BW. please if u got the PDF files do send to me at ajit_rane007@yahoo.com.

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

Best Regards,

Ajit

Former Member
0 Kudos

Hi,

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

Former Member
0 Kudos

Hi John,

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

Thanks

Former Member
0 Kudos

can you send me the blue print doc. as well? my email id is bwhelp@gmail.com

Former Member
0 Kudos

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.

Former Member
0 Kudos

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 pancik@gmail.com

Highly appreciate your help.

Thanks, Panci

Former Member
0 Kudos

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.

former_member374
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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)

Former Member
0 Kudos

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 mrinal_09@yahoo.co.in

Regards,

Minal

Former Member
0 Kudos

Hi Sun Dav,

The information is very helpful. Can you please email more to my email - jia_liumsg@hotmail.com.

Thanks,

Liu Jia

Former Member
0 Kudos

Thanks!

null

Former Member
0 Kudos

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: maverick91108@mailcity.com.

Thanks and Best Regards,

Lee

Former Member
0 Kudos

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

abir.biswas@rediffmail.com

Former Member
0 Kudos

Dear Sun Dav,

Thanks a lot for posting those questions, do mail me more if you have, on my mail id ashu_tewari@rediffmail.com.

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?

Former Member
0 Kudos

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 adaltons@gmail.com.

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

Thank you

Former Member
0 Kudos

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 hwang@thestar.ca before this Friday?

Thanks a lot,

Helen

Former Member
0 Kudos

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: roger.gu@hotmail.com.

Thanks,

Roger

Former Member
0 Kudos

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 gmpatel001@yahoo.com?

thnx in advance.

Former Member
0 Kudos

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

gunukula_ravichandra@yahoo.com

Thanks in advance once again ,

RaviChandra.G.

Former Member
0 Kudos

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: ralph.bonink@gmail.com.

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

Thanks,

Ralph

moha_nan
Participant
0 Kudos

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: kukku@gmx.de

Thanks,

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Sun Dav,

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

My Email id is poonamsardana@gmail.com

Thanks in advance.

Regards,

Poonam

former_member374
Active Contributor
0 Kudos

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.