Sunday 5 January 2014

SAP BI INTERVIEW QUESTIONS

Interview Questions:


1. We have standard info objects given in sap why you created zinfo objects can u tell me the business scenario .


2. We have standard info cubes given in sap why you created zinfo cubes can u tell me the business scenario 


3. In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow.


4. when u creating infoobject it shows reference and template what is it


5. what is meant by compounding attribute tell me the scenario? 


6. I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen? 


7. I have 10 cubes I created multiprovider I want only 1 cube data what u do? 


8. what is meant by safety upper limit and safety lower limit in all the deltas tell me one by one for time stamp, calender day and numberic pointer? 


9. I have 80 queries which query is taking so much time how can you solve it 


10. In compression level all requests are becoming zero which data is compressing tell me detail 


11. what is meant by flat aggregate?explain in detail 


12. I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next 

time it taking 1 day with a same loads what happen how can u reduce the time of loading 

13. how can u know the cube size? in detail show me u have screen shots 


14. where can we find transport return codes 


15. I have a report it taking so much time how can I rectify 


16. what is offset? Without offset we create queries? 


17. I told my process chains nearly 600 are there he asked me how can u monitor I told him I will see in rspcm and bwccms he asked is there any third party tools is there to see? Any tools are there to see tell me what it is


18. how client access the reports 


19. I don’t have master data it will possible to load transaction data? it is possible is there any other steps to do that one 


20. what is structure in reporting? 


21. which object based you created extended star schema? 


22. what is line item dimension tell me brief 


23. what is high cardinality tell me brief 


24. process chain is running I have to stop the process for 1 hour after that re runn the process where it is stopped? in multiprovider can I use aggregations 


25. what is direct schedule and what is meta chain 


26. which patch u used presently? How can I know which patch that one?


27. how can we increase data packet size

 
28. hierarchies are not there in bi?why 


29. remodeling is applied only on info cube? why not dso/ods?


30. In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not?

 
31. why ODS activation fail? What types of fails are there? What are the steps to handle


32. I have a process chain is running the info package get error don’t process the error of that info package and then you can run the dependent variants is it possible? Give me any performance and loading issues or support issues Reporting errors, Loading errors, process chain errors? Please explain in detail or create a screenshots for all the questions and explain in detail If u have any screen shots or text data can u give me the link.
is their any difference between bex 3.5 and bex 7.0?
R/3 extraction failed - recovery procedure?
R/3 extraction is running from past 2 years. Suddenly it failed since 5 days and again today it is running fine. But how i do get data loaded to cube for failed loads? What are the procedures that can be followed?

what are the pre requisites for BI content installation?R/3 extraction failed - recovery procedure?
what r the diff types of conditions in reporting??when do we use infocube and ODS??? (scenario).how many types of infocubes are there?

32.What is exception Aggregation? give Example? 2.what Cell formating? and Advantages?
33.What is I_step1,I_step2,I_step3 in customer exit What is occurrence.what are the common errors occur during data loading and perfornance level?
34.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?


35.We have standard info objects given in sap why you created zinfo objects can u tell me the business scenario 
36. We have standard info cubes given in sap why you created zinfo cubes can u tell me the business scenario 
37. In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow.
38. when u creating infoobject it shows reference and template what is it
39. what is meant by compounding attribute tell me the scenario?
40. I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen?
41. I have 10 cubes I created multiprovider I want only 1 cube data what u do?
42. what is meant by safety upper limit and safety lower limit in all the deltas tell me one by one for time stamp, calender day and numberic pointer?
43. I have 80 queries which query is taking so much time how can you solve it 
44. In compression level all requests are becoming zero which data is compressing tell me detail
45. what is meant by flat aggregate?explain in detail
46. I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading 
46. how can u know the cube size? in detail show me u have screen shots
47. where can we find transport return codes
48. I have a report it taking so much time how can I rectify
49. what is offset? Without offset we create queries?
50. I told my process chains nearly 600 are there he asked me how can u monitor I told him I will see in rspcm and bwccms he asked is there any third party tools is there to see? Any tools are there to see tell me what it is
51. how client access the reports
52. I don’t have master data it will possible to load transaction data? it is possible is there any other steps to do that one
53. what is structure in reporting?
54. which object based you created extended star schema?
55. what is line item dimension tell me brief
56. what is high cardinality tell me brief
57. process chain is running I have to stop the process for 1 hour after that re runn the process where it is stopped? In multiprovider can I use aggregations
58. what is direct schedule and what is meta chain
59. which patch u used presently? How can I know which patch that one?
60. how can we increase data packet size
61. hierarchies are not there in bi?why
62. remodeling is applied only on info cube? why not dso/ods?
64. In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not?
64. why ods activation fail? What types of fails are there? What are the steps to handle
65. I have a process chain is running the infopackage get error don’t process the error of that info package and then you can run the dependent variants is it possible? 

66.Give me any performance and loading issues or support issues,Reporting errors, Loading errors, process chain errors?

3 comments:

  1. Hey Buddy,can you provide the answers to these questions ?

    ReplyDelete
  2. hai can you provide the answers please...

    ReplyDelete
  3. I need answers to these questions ..

    ReplyDelete