SAP BI QUESTIONS & ANSWERS-10 :-
1) Transaction Code for the following ?
A) 1) To delete setup tables -> LBWG
2) To fill setup tables -> OLI*BW
3) Currency exchange rates -> OB08
4) BW Delta Queue Monitor -> RSA7
5) DB connect -> RSDBC
2) What is Real Time Data Acquisition ?
A) Real-time data acquisition supports tactical decision-making. It also supports operational reporting by allowing you to send data to the delta queue or PSA table in real-time. You then use a daemon to transfer Data Store objects to the operational Data Store layer at frequent regular intervals. The data is stored persistently in BI.
3) Difference between display attributes and navigational attributes ?
A) Display attribute is one which is used only for display purpose in the report.Where as navigational attribute is used for drilling down in the report.We don't need to maintain Nav attribute in the cube as a characteristic(that is the advantage) to drill down.
4) What are the different variables used in BEX ?
A) Variable with default entry
5) What are Return Tables ?
A) 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
6) What are Start routines, Transfer routines and Update routines ?
A) 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.
7) What is the difference between ODS and InfoCube and MultiProvider ?
A) 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.
8) What are the steps involved in LO Extraction ?
A) The steps are:
• RSA5 Select the DataSources
• LBWE Maintain DataSources and Activate Extract Structures
• LBWG Delete Setup Tables
• 0LI*BW Setup tables
• RSA3 Check extraction and the data in Setup tables
• LBWQ Check the extraction queue
• LBWF Log for LO Extract Structures
• RSA7 BW Delta Queue Monitor.
9) Can an InfoObject be an InfoProvider, how and why ?
A) 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.
10) What are Process Types & Process variant ?
A) Process types are General services, Load Process & subsequent processing, Data Target Administration, Reporting agent & Other BW services.
Process variant (start variant) is the place the process type knows when & where to start.
11) Four types of Sid tables ?
A) X time independent navigational attributes sid tables
Y time dependent navigational attributes sid tables
H hierarchy sid tables
I hierarchy structure sid tables.
X-table = A table to link material SIDs with SIDs for time-independent navigation attributes.
Y-table = A table to link material SIDs with SIDS for time-dependent navigation attributes.
12) How can you improve the performance of a query ?
A) Query Performance can be improved by making the Aggregates having all the Chars & KF used in Query.