BI/BW interview questions


  1. Difference between the R/3 Security and BW Security?
  2. What are the types of users in BW System?
  3. What is info object?
  4. Define   Info areas, info providers and info objects?
  5. What are the authorization objects used for reporting users in BW?
  6. What is the difference between s_rs_comp and s_rs_comp1?
  7. What are the minimum authorizations to execute a report?
  8. How can we create authorization objects in BW?
  9. How can we trace the users in BW system?
  10. What is Workbook?

  1. Difference between Workbook and Queries?
  2. How we can secure the Workbooks? What are the authorization objects needed to execute a workbook?
  3. What are the authorizations required to save workbook in roles?
  4. How we can maintain Hierarchy authorizations?
  5. What is the difference between BW and BI?
  6. What is Analysis authorization object? How it is useful?
  7. What are the default mandatory info objects in BW/BI?
  8. How we can trace the users in BI system?
  9. What are the different security levels we follow in BW?
  10. How we can restrict the info object using Value authorization and Hierarchy authorizations?
  11. What is the process of assigning Analysis authorization objects to Users and roles?
  12. What are the tables useful while troubleshooting the issues in BW & BI?
  13. What is the importance of attributes tab in RSD1?
  14. What is BEX? Why it is useful?
  15. What is Authorization Relevant? why should we maintain objects as Authorization Relevant?
  16. How will you create analysis authorization?
  17. In Which table we can find  list of reports?
  18. What are 3 mandatory infoobjects in BW/BI?
  19.