Search the web
Sign In
New User? Sign Up
sapbusinesswarehouse · sap-img.com - SAP BW Forum
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
SAP_BW Interview questions   Message List  
Reply | Forward Message #6820 of 7045 |
Re: [sap bw] SAP_BW Interview questions


1q.How to prevent the duplicate records at the datatarget level in sap
bw?
A.  we have option in DSO settings unique data records only , u jst enable this option .
 if we enable this , no duplicate records can enter into bw. after u load this data to cube.

Q2.Issues regarding doble records?
A. in reporting data mismatching is possible.

Q3.Structure in query reporting?Wat are Structures?how many structures
can u create in ur reporting?
 
A. structures are reusable components , it is a combination of chars & kf's . we can write max of two structures in reporting. if we create structures , we can drill down these structures  across  at infoprovider level. so it is global.
 
 when ever u change the strucures in reports , that will effect in same structure which we used in other reports. so what we have to do is right click on structure select on remove reference. so what i have modified in structure , that wil not effected in other reports.
 
Q4.Process chain steps?Which process type is used to delete the last
request when loading the data?

Q5.Reconstruction tab in infocube?why it is used?


Q6.Suppose ODS contains 5 records and Infocube shows 12 records.How to
solve it?
 
A. i think u scheduled  same info package more than once. or u executed DTP more than once.
once  u checked in IC request tab,  u can see there how many records transfer from PSA, and how many records transfer to cube.
 

Q7.How to maintain masterdata in Client-Server architecture?

Q8.Tell me typical bw team.How u work?

Q9.How do u improve the dimension and fact table performance?

Q10.What is 0Recordmode?
 
A.  it is an info object , 0Record mode is used to identify the delta images in BW which is used in DSO .it is automatically activated  when u activate DSO in BW. like that in R/3 also have field 0cancel . it holds delta images in R/3. when ever u extracting data from R/3 using LO or Generic.. etc. this field 0Cancel  is mapping with 0Record mode in BW. like this BW identify the Delta images.

Q11.Diff between document table and setup tables?and its purpose?
 
A. i dnt know abt document tables. jst i know abt set up tables. in LO ext  , SAP cannot permit to access the data from Application tables directly  by Extraction structure. so SAP provides Setup tables. these setup tables will used for Full update / Init.


--- On Sun, 9/11/08, sap.ram16 <sap.ram16@...> wrote:
From: sap.ram16 <sap.ram16@...>
Subject: [sap bw] SAP_BW Interview questions
To: sapbusinesswarehouse@yahoogroups.com
Date: Sunday, 9 November, 2008, 5:56 PM

Hi,

This is Ram.Can u pls send me the answers to these questions.

SAP-BW INTERVIEW QUESTIONS

Q1.How to prevent the duplicate records at the datatarget level in sap
bw?

Q2.Issues regarding doble records?

Q3.Structure in query reporting?Wat are Structures?how many structures
can u create in ur reporting?

Q4.Process chain steps?Which process type is used to delete the last
request when loading the data?

Q5.Reconstruction tab in infocube?why it is used?

Q6.Suppose ODS contains 5 records and Infocube shows 12 records.How to
solve it?

Q7.How to maintain masterdata in Client-Server architecture?

Q8.Tell me typical bw team.How u work?

Q9.How do u improve the dimension and fact table performance?

Q10.What is 0Recordmode?

Q11.Diff between document table and setup tables?and its purpose?



Add more friends to your messenger and enjoy! Invite them now.

Mon Dec 29, 2008 6:32 am

dasari_venkata_rao@...
Send Email Send Email

Forward
Message #6820 of 7045 |
Expand Messages Author Sort by Date

Hi, This is Ram.Can u pls send me the answers to these questions. SAP-BW INTERVIEW QUESTIONS Q1.How to prevent the duplicate records at the datatarget level in...
sap.ram16
Offline Send Email
Nov 9, 2008
1:15 pm

1q.How to prevent the duplicate records at the datatarget level in sap bw? A.  we have option in DSO settings unique data records only , u jst enable this...
dasari venkata rao
dasari_venkata_rao@...
Send Email
Dec 29, 2008
6:32 am

Thnx Venkatrao. ________________________________ From: dasari venkata rao <dasari_venkata_rao@...> To: sapbusinesswarehouse@yahoogroups.com Sent:...
Ram U
sap.ram16
Offline Send Email
Dec 29, 2008
11:42 am

Hi Venkatrao, Can u send me the Issues whatever u have faced? Once again Thnx for replying of those questions. ________________________________ From: dasari...
Ram U
sap.ram16
Offline Send Email
Dec 30, 2008
5:37 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help