FAQ or Frequently Asked Questions for SAP BI/BW:
1. Where do we used number range buffering? Codes SE27 and SNRO
2. what are the different cases in which update rules can be copied?
3. what are the different types of queries?
4. what is query view and query definition?
5. what is query template?
6. what is the difference between drill down and slice n dice?
7. what is result set query and infoset query?
8. what are jump queries?
9. what is drill up and drill across and how is drill across done?
10. what is an infoset and what the difference to it in BI 7?
11. what are the three scenarios for ods reporting?
12. what is an info catalog?
13. what are free characteristics and filters?
14. what are the difference between restricted key figures and filters?
15. what is the use of formula in BW?
16. what are advance query techniques in BW?
17. what is exception reporting?
18. what is reporting agent?
19. what is a variable and different types of variables and what is the use of variables?
20. at what times will currencies be translated?
21. what is the use of user exists?
22. what is query management?
23. what are the techniques to improve query performance?
24. what is query monitor? Is it useful for aggregates, if so how?
25. what are the query modes available in BW?
26. what is an aggregate and what is the use of it?
27. how are aggregated updated and when is it recommended to use aggregates?
28. what are the conditions and factors to be taken into account while creating aggregates?
29. what are the different strategies for creating an aggregate?
30. how aggregates can be optimized?
31. what is a profile generator and what is the use of it?
32. what is the difference between authorization and authorization objects?
33. what is Bex map?
34. what is web reporting and what are the benefits of using it?
35. what are the differences of bex and web reporting?
36. what is bex web application designer?
37. what type of servers are required to allow web reporting in SAP BW?
38. what is web reporting template?
39. what does data changes aggregates update program do?
40. what is the aim of aggregates and in what case can you not create aggregates?
41. where can data be filtered in SAP BW?
42. What are the variables used in Bex reporting?
43. What are the different Processing Types?
44. What is the replacing path Process Type? What is the input for Replacing path process type?
45. How do you create a Generic data source?
46. What are the function modules?
47. Types of Deltas?
48. what are the Generic delta types?
49. Explain V3 Update?
50. What is Cell definition?
51. How do you Transport objects from Development to Quality? IMP
52. What is Navigation Attribute? What are the tables will create while creating Navigational attribute?
53. What are the tables for Master data in BW?
54. What are the tables will create while creating Info Object?
55. What are the steps involved when tables will create while creating Info Cube?
56. Explain your Landscape? Examples?
57. Explain Implementation Methodologies?
58. ABAP reports?
59. What are the tables for SD in R/3?
60. how many Process Chains you are used?
61. What are the issues Faced while loading data?
62. What are the custom cubes you used?
63. How many users your company have?
64. What are the queries you have created?
65. What are the characteristics, key figures involved in query?
66. On what basis you assign Characteristics to Dimensions?
67. What is Plan data and where it will sit?
68.HOw to creat a report on one column where we stored both sales Report ?
69.How to strat & STOP PROCESS CHAIN
70: LOWER CASE & UPPER CASE ?
71: WHY WE GO FOR GENERIC EXTRACTION ? WHICH CASE ? IF THE DATA WILL BE IN 3 TABLES & WE HAVE TO EXRTACT THE DATA FROM TWO FIELDS THEN WHAT TO DO ?
72: ENHNACEMENT CASE WHICH LOGIC APPLY BY YOU ?
73: HOW MANY REPORTS /INFOCUBE /INFOSOURSE / DSO CREATED BY YOU ?
74: BASED OPEN 2LIS_11_VAHDR WHAT ARE THE REPORT U ARE CREATED ?
75: WHY WE GO FOR CEREATING INDEX ? HOW TO KNOW THAT IT'S THE TIME TO CREAT THE INDEX ? why index not other Compress/ ?
76: HOW TO ROLE AUTHORIZEID SAP BI?
77:WHAT IS EARLY INITIALZE DELTA ?
78: Wht is best for reporting Infocube or Dso ? why ?
79: How many tables are in dso ? standard dso / direct dso / write optimized dso ?
80: Selective Deletion /Repair full request / Repet delta /Reverse Posting /?
81: if the data is loaded in sapbw /sap bi & i want to serach the pericular year data ? where to search ?
82 : Data is loading from sap bi/bw if in extraction stage it fails / How to rectify ? whr to searchh ?
Get Answers with Explanation for the Aforementioned Questions at SAP BW Forum.