SAP BW Interview Questions and Answers for Freshers
Question.1 What is proposed from statistics for aggregates?
Answer: You can ask the system to get the optimal characteristics for aggregation by using the BW statistics data (like query run time, etc).
Question.2 Can you define aggregates on time dependent navigational attributes?
Answer: Yes, as of version 3.x
Question.3 What are the proposal options available?
- Proposal from BW statistics cube – history of BW statistics.
- Propose from BW statistics (tables) – based on database tables RSDDSTAT and RSDDSTATAGGRDEF.
- Propose from last navigation – suggestion based on the last entry of the above mentioned tables for the current user.
- Propose from query.
Question.4 What is aggregate hierarchy?
Answer: Aggregates that are built on other aggregates; the hierarchy is done automatically; it is recommended that you create a few base large hierarchies and small aggregates can be built from hierarchy.
Question.5 How does change run affect aggregate?
Answer: Newly loaded master data is not active until the change run has been applied to hierarchy.
Question.6 In real world when do you recommend aggregate?
Answer: Look at the BW statistics’ if a query spends more than 50% of the time in Database access and the ratio of records read from database to records processed is more than you create aggregates.
Question.7 What is are characteristic?
Answer: The characteristics In this area are not displayed in the initial view of the query but you can drill down and filter once you execute the query.
Question.8 What is filter area?
Answer: The characteristics in this area are restricted and cannot be filtered or drilled down further.
Question.9 What is IROWCOUNT key figure?
Answer: For-ODS and infosets, the query designer automatically adds this key figure “number of records” to count the records.
Question.10 What is a calculated key figure?
Answer: To do complicated calculations on key figures such as mathematics functions, percentage functions etc. For example you can have a calculated key figure to find out sales tax from sale price.
Question.11 What is the percentage variance?
Answer: This is defined as parameter1 % parameter2; example actual expenses exceeds the % budgeted expenses.
Question.12 What is percentage share?
Answer: It is defined as parameter1 %A parameter?; gives the percentage share of parameter1 of parameter?.
Question.13 What is percentage share of result (%CT)?
Answer: Defined as %CT parameter1; gives the result in percentage with respect to result.
Question.14 Percentage result of overall result (%GT)?
Answer: Defined as %GT parameter1; similar to previous but the percentage is share of overall results.
Question.15 What is COUNT function?
Answer: Count (parameter) returns value 1 if parameter is not zero else zero.
Question.16 What is NDIVO?
Answer: NDIVO(parameter) returns 0 if the parameter returns division by 0.
Question.17 What is a structure?
Answer: Combination of characteristics and key figures; for example you can create a structure containing sales for products A, B and C as three different restricted key figure contained in a structure; if this is global you can reuse it in other queries.
Question.18 What is a reusable structure?
Answer: These are query level structures which can be used in any queries.
Question.19 How do you create a reusable structure from a local structure?
Answer: Right click on the local structure, select save as, enter technical name and description.