SAP BI interview questions

Read these faq's.more than enough i thnk...ravikiran.(collectd frm my frnds who attended for those interviews)

Accenture:

• What are step in transporting the object? Accenture
• Where you have to done cube testing? Accenture
• WHAT IS OBJECT DOCUMENTATION? WHERE YOU CAN DO IT? WHAT IS THE USE OF THAT? Accenture
• How can partition a cube- Accenture
• What is type of transfer in transfer rules? Accenture
• What is data transformation in BW? Accenture
• Why u go for aggregate? Tell me one example? Accenture
• Usually we mention T or O in CONFIRMATION TYPE. What are T and O stand for? Accenture
• Suppose, you are working on a report, how do you know from which INFOCUBE, report should be generated? Accenture
• what are the extractions made in a sap BW project using lo cockpit- Accenture
• Extraction in mm and SD and FI? What is the requirement and name them? Accenture
• What are the InfoCubes developed in a sap project? Name them and what is the requirement? Accenture
• What are the reports generated in a sap BW project? Name them and what is the requirement? Accenture
• What is the transaction to check delta? Accenture



Bristle-Cone
• Which data you load first (MASTER or TRANSACTIOANAL)? Why?


CS
• Tell me info object errors?

Citigroup

• How do you generate Summary Report? How can i get the Drill down Options in That report? Citigroup
• How is SAP BW different from SAS (Statistical Analytical Software)? Citigroup
• What is the difference between Business warehouse and Data Warehouse? Citigroup


Cap-Gemini
• Where do you find the option "REPAIR REQUEST"? WHAT IS THE USE OF THAT? Cap-Gemini
• How can u correct the error in loading for Delta failure.
• How do u decided to go create Aggregates for cube. What purpose you want to create aggregates?

Curosys
• WHAT IS THE DIFFERENCE BETWEEN WORKBENCH REQUEST AND CUSTOMERIZIED REQUEST-



HCL
• What type of tables join in generic view? HCL
A)TRANSPERENT TABLES.
• What is attribute change run?
A.)MASTER DATA CHANGES THEN WE HAVE TO RUN THIS.
• What is reconciliation? Where can u find the option. cube( f/ e table or ODS or aggregates)?
A.)CUBE.
• What is SID for to transport the object along the land scape.

• What are the parameters? Can u say what type of parameters regularly used?
• What is the difference between formula and calculated key figure? HCL
• What is the safety delta for CO-PA?



IBM
• What Cell formatting? And Advantages? IBM
• What is the ticketing tool for Wipro and ticketing tool depends on company or client? IBM
• What is the main difference between view and the function module? IBM
• If we want to design an info cube, what are the pre-requisites u have to take in real time? IBM
• What is the differences between standard DSO and write optimized DSO and Direct update DSO. IBM
• How can we stop the Collapse process in process chain? IBM
• What is the use of filters in BEx – IBM
• How do you analyse the data loading time ...today the loading time is 15 min. but tomorrow the same type of loading takes 3 hours..How do you analyse? IBM
• Account modeling and key figure modeling IBM
• What is exception aggregation IBM
• How is multi provider different from info set? Typically when do you use it? IBM
• Which R/3 version supports LO extraction? IBM
• How does it do delta? IBM
• What is the difference between Data Target and Info Provider IBM
• What is the RRI? What is the structure of RRI? Any conditions for RRI.



HP
• What is 0unit of measure? HP
• What is alpha conversion? U faced any errors in alpha conversion? HP
• What is variable? Give me one example? I want to display 12 months in a report..? How many variables are used? HP
• How will the setup be in BW in real time scenario how will the setup between r/3 and BW in real time scenario HP
• Can Tell Me difference b/w SAP BW 3.5 & BW 7.0 version in Detail.- HP
• What are the uses of routines, like transfer routine, update routine, start routine. What are the differences? Where we will actually define them?

Infosys
• What is the difference between Z and 0 Tables in SAP BW3.5? Infosys
• How to get the recordmode D or A in changelog table when we delete or add records in DSO? Infosys
• When do we go for generic extraction and why we use time stamp? How long it will run? Explain? Infosys
• What do you understand by Datawarehouse? How is it being used by different organisations?


Igate
• What is LIS, LO and difference between them?

Magnus-Infotech
• Can we make a info object as info provider other than master data.


Infotech
• How do you extract data from R3 to BW for a specific date.? How to filter the data for the period? ITC-Infotech
• How will you schedule the job in background



Wipro

• What is I_step1,I_step2,I_step3 in customer exit –Wipro
• What is occurrence- Wipro
• What is step by step procedure? At what scenario you retrieve the data from sap system to Informatica or say DWH system?


TCS
• How to fetch the data from sap-r/3, sap-BW/BI to Informatica system?
• What is the t-code to create INDEX in SAP BI (7.0)? TCS
• How can we create the index in SAP BW/BI? TCS
• What are variables? TCS
• What is change run? TCS
• What do you do, when you get a GAP? What is FIT-GAP analysis?


Satyam
• What is Cell Definition? Satyam
• What are the reports used from business content in sap BW project? Name
them and what was the requirement? Satyam
• How can we enhance the dataSources, explain me with example? Satyam
• What are the errors in process chain, how can we solve them?