Saturday, September 11, 2010

SAP BI Interview questions



how to migrate the cube data from bw to bi? explain and give
me the steps
can we load delta load directly without full load ? how ? what are the steps
what is the techincal name for dimensions in a cube?
What is reconcile Adjustment Account in SAP Business One
why u r creating custom cube. wht is scenario to creating the custom cube.
Can anybody explain the what is "OLTP"(Online Transaction Processing) and "OLAP"(Online Abaytical Processing) in SAP BW/BI? and also plz explain What is the differences between those two? 
AFTER A PURCHASE ORDER HAS BEEN APPROVED, AND PRINTED, AND THERE IS NEED TO MAKE CHANGES ON THE P O, DO I CANCEL THE OLD P O OR DO I JUST EDIT AND SEND FOR APPROVAL?
What is the difference between canceling the sales order and closing the sales order?
How many types of Routines in SAP BI(7.0)?
what is UI and DI objects
what is concept behind incoming payment and outgoing payment?
what is the diffrence between Psa And IDoc
What is exception Aggregation? give Example? 2.what Cell formating? and Advantages?
What is occurence
what are the common errors occur during data loading and perfornance level?
what are types of update rules and transfer rules? and what are the routines to be used in bw 3.5?


What is I_step1,I_step2,I_step3 in customer exit     
What is occurence 
what are the common errors occur during data loading and perfornance level    
what are types of update rules and transfer rules? and what are the routines to be used in bw 3.5  
what is a dimension table and types? explain about line item dimension and high cardinality and uses, in which case suppose to be use?  
what is an index and types? what is use and where to be used?     
What is Authorization and types? what are uses and explain me in detailed?    
what is a process chain and types? use of process chain and differences between bi7.0/bw3.5 about process chains and where to be use?   
what is performance tuning and the tools supposed to be used? and explain in detailed about aggregates, bw statistics and bi accelerator? uses of those tools?      
what is a multiprovider? what are the uses and in which case supposed to be use? difference between bi7.0/bw3.5?   
what is virtual kef figures? what are the uses and in which case supposed to be use? 
what is re-partioning and re-modeling in bi 7.0 and what are the uses and in which case supposed to be use?  
what are types of kef Figures, characteristics, attributes? explain me in detailed
How to check for standard info Objects, InfoCubes, Ods/DSo,transformations, reports, queries..etc in bi7.0/bw3.5? (Is there any T-Codes to find out)      
what is InfoCube?what are the types and uses and in which Case it suppose to be use?   
what is DSO? what are the types and uses and in which case it suppose to be use?    
what is DTP? what are the types and uses and in which case it suppose to be use?    
what is transformation? what are the types and uses and in which case it suppose to be use?      
what are advantages of using bi 7.0 instead of bw 3.5?    
\
 Can any one explain me....Before coming luw's into Extractor queue(Lbwq),What Update mode(v1 or v2) will execute?    
can any one explain me...... what are the difference between Extractor queue and delta queue?    
wt is the use of summarization level and filed name for partitioning in co-pa? 
an anyone tell me abt WAD navigation
How the query from BW is used?
 Describe transfer rules? 
 Where do you store your custom images (like logos)?
 If I have 3 different process chains then how can I create a Metachain including all these 3 local chains ? 
 Give some examples of usage of BW statistics reports?
 If you are asked to change the way tables are displayed in web reporting how would you do this?
 How is an Extended star schema of BW more advantageous than the star schema? 
 Can you make multi providers and master data as data marts? 
 What is the source for FIAR extractor from R/3? 
 What is the number of decimal places in scaling factor? 
 when you write user exit for variables what does I_STEP do?
 Which report can you use to monitor change run? 
 WHAT IS THE DIFFERENCE BETWEEN WORKBENCH REQUEST AND CUSTOMERIZIED REQUEST 
 How do you upload currency exchange from a flat file? 
 What is the Bex options for characteristics like F4 help for query definition and execution?     
Describe a opening balance? 
 What are the general tuning guidelines? 
 When you fill in the values for selection, what are the options available in general?
What is the difference between Z and 0 Tables in SAP BW3.5? 
 How to get the recordmode D or A in changelog table when we delete or add records in DSO   
when do we go for generic extraction and why we use time stamp ?
how long it will run?explain? 
 what are the reports used from business content in sap bw project?name them and what was the requirement? 
 what are the extractions made in a sap bw project using lo cockpit extraction in mm and sd and fi?what is the requirement and name them?
 what are the info cube developed in a sap project?name them and what is the requirement? 
 what are the reports generated in a sap bw project?name them and what is the requirement?  
Why dont I see my DataSource when I choose BAPI option in Virtual Provider? How can I fix this any steps!!! 
 what is writeoptimized data store in dso? 
 What is constant selection    
can we define a multiprovider in multiprovider \ 
 Which data you load first ( MASTER or TRANSACTIOANAL ) ? And why ?
Give some examples of old LIS and new equivalent LO? 
 what is the data model and how it is use ? 
 What are the steps to configure third party (BAPI)    
What are the types of reports you can use in reporting agent? 
 What is a profitability segment?
 HOW CAN I APPLY PATCHES FOR BI 7.0 WITHOUT USER ID AND PASSWORD OF SAP? 
 Can you restart the conversion? 
 how bw was found    
How would you change the default template? 
 What is the procedure to create a data mart? 
 What is persistence mode in cache? 
 What is the advantage of CO-PA? 
 What is business content? 
 How do you activate personalization for bex? 
 when do we go for generic extraction and why we use time stamp ?how long it will run?explain? 
 What is extraction setup? 
 What are the objects that support variables?
 Is the user exit common for all data sources? 
 What is ?filling? of aggregate?

No comments:

Post a Comment