SAP BW Interview Questions - Part B

Here are some questions and answers.

1)name the two table that provide detail information about data source
2)how and when can you control whether repeat delta is requested?
3)how can you improve the performance of a query
4)how to prevent duplicate record in at the data target level
5)what is virtual cube? its significance
6)diff methods of generic datasource
7)how to connect anew data target to an existing data flow
8)what is partition
9) SAP batch process
10)how do you improve the info cube design preformance
12)is there any diff between repair run/repaire request.if yes then please tell me in detail
13)difference between process chain and infopackage group
diff between partition/aggregate


Q 3) Query Performance can be improved by making the Aggregates having all the Chars & KF used in Query.

Q 5) Virtual Cube : InfoProvider with transaction data that is not stored in the object itself, but which is read directly for analysis and reporting purposes. The relevant data can be from the BI system or from other SAP or non-SAP systems.
VirtualProviders only allow read access to data.

Q 6) Diff Methods of Generic datasource using Transaction RSO2 :
a) Extraction from DB Table or View
b) Extraction from SAP Query
c) Extraction by Function Module

2) Important BW datasource relevant tables

ROOSOURCE: Table Header for SAP BW OLTP Sources

RODELTAM: BW Delta Process

ROOSFIELD: DataSource Fields

ROOSGEN: Generated Objects for OLTP Source, Last changed date and who etc.

3) For Q 8) i think you mean table partition
You use partition to improve performance. You can only partiton on 0CALMONTH or 0FISCPER
6. Generic Extarction using 1.Views 2. Infoset Queries , 3. Function modules
5) Hi Santosh

Pls note down the Q& ANS
Some of the Real time question.
Q) Under which menu path is the Test Workbench to be found, including in earlier Releases?

The menu path is: Tools - ABAP Workbench - Test - Test Workbench.

Q) I want to delete a BEx query that is in Production system through request. Is anyone aware about it?

A) Have you tried the RSZDELETE transaction?

Q) Errors while monitoring process chains.

A) During data loading. Apart from them, in process chains you add so many process types, for example after loading data into Info Cube, you rollup data into aggregates, now this rolling up of data into aggregates is a process type which you keep after the process type for loading data into Cube. This rolling up into aggregates might fail.

Another one is after you load data into ODS, you activate ODS data (another process type) this might also fail.

Q) In Monitor----- Details (Header/Status/Details) à Under Processing (data packet): Everything OK à Context menu of Data Package 1 (1 Records): Everything OK ---- Simulate update. (Here we can debug update rules or transfer rules.)

SM50 à Program/Mode à Program à Debugging & debug this work process.

Q) PSA Cleansing.

A) You know how to edit PSA. I don't think you can delete single records. You have to delete entire PSA data for a request.

Q) Can we make a datasource to support delta.

A) If this is a custom (user-defined) datasource you can make the datasource delta enabled. While creating datasource from RSO2, after entering datasource name and pressing create, in the next screen there is one button at the top, which says generic delta. If you want more details about this there is a chapter in Extraction book, it's in last pages u find out.

Generic delta services: -

Supports delta extraction for generic extractors according to:

Time stamp

Calendar day

Numeric pointer, such as document number & counter

Only one of these attributes can be set as a delta attribute.

Delta extraction is supported for all generic extractors, such as tables/views, SAP Query and function modules

The delta queue (RSA7) allows you to monitor the current status of the delta attribute

Comments (27)

Said this on 5-20-2007 At 02:02 pm
Very good doc
Said this on 6-1-2007 At 06:23 pm
its very very excellent for every one
Said this on 6-4-2007 At 07:45 pm
Really awe-inspiring...
Said this on 9-14-2007 At 10:39 pm
i was amazed after going thru the faqs.Excellent keep it up !!!
more interview implementation related faqs would help more to try for jobs.
Said this on 9-28-2007 At 04:58 am
Amazing !!! No comments!
Said this on 10-10-2007 At 01:27 am
Really superb
Said this on 10-15-2007 At 07:25 pm
I very very good I never see like the I am very happy Thank you once again
Said this on 11-5-2007 At 08:42 pm
Said this on 11-7-2007 At 09:16 am
good to get a job on sap biw
Said this on 12-14-2007 At 09:05 am
It was nice information for those guys who are preparing for intervies for 1st time.
Said this on 12-18-2007 At 09:06 am is very excllent to way for gaining knowledge
Said this on 12-31-2007 At 12:27 am
Its good for job seeker.
ramu royal
Said this on 1-6-2008 At 08:12 pm
very helpfull to freshers and experienced persons also.thanq toall.
Said this on 1-23-2008 At 08:10 pm
very good
Said this on 2-3-2008 At 06:54 pm
excellent, thank you.
Said this on 2-13-2008 At 12:50 pm
very useful for job seekers, thank you.
Said this on 3-24-2008 At 11:49 am
Excellent Questions with ans, It would be more helpful for some of the ans given with Screens.
Said this on 5-29-2008 At 07:36 am
Its really excellent for those who was preparing interview one suggestion is pls give the realtime scenarios related each topic in bw so that all will be appreciated.
its really highly appreciated the questions and answers good
Said this on 6-1-2008 At 07:01 pm
very useful for interviews........
Said this on 7-14-2008 At 09:23 pm
Nice... helpfull doc to learn..
Said this on 10-28-2008 At 11:22 am
excellent work thanks dude! thanks for u r inspring work
Said this on 11-15-2008 At 12:06 am
I've done multiple interviews of BW candidates and this may get you past the first level but don't bet on it any farther than that. Anyone with more than a few years experince will see right though it. Plus I put you in front of the system and you actually do what you say. I've see more "Experienced" applicants fail this test than you want to believe.
Don't lie on your resume, go learn the product and stop wasting everyones time !!!
Said this on 2-4-2010 At 12:49 pm

i ams shrikant , complete my BW and BI, any fresher level opening in SAP Bw,BI level than reply me.

Said this on 2-8-2011 At 02:06 pm

Why do you want to demonstrate that you can play god with some people's lives. You should remember that you too were in their steps before and could happen again to you.a&& with a hole.

Said this on 5-4-2009 At 02:07 am
Said this on 7-4-2010 At 05:01 pm

good work

Said this on 7-26-2010 At 11:14 pm

Had this questions the other day and tjis method for interviews it's really stupid. I prefer someone smart, instead of a dumb person knowing all by heart.

Post a Comment
* Your Name:
* Your Email:
(not publicly displayed)
Reply Notification:
Approval Notification:
* Security Image:
Security Image Generate new
Copy the numbers and letters from the security image:
* Message:

Email to Friend

Fill in the form below to send this article to a friend:

Email to Friend
* Your Name:
* Your Email:
* Friend's Name:
* Friend's Email:
* Security Image:
Security Image Generate new
Copy the numbers and letters from the security image
* Message: