Sunday, 28 December 2014

Database Overview .

Before Learning SAP BO , You Have To Understand Few Common Concept Of Database That Will Help Full For Your Understanding while You Are Creating Any Analysis Report For Top Level Management.



List of Question 

  1. What is Data warehouse?
  2. What is Data mart?
  3. What is Rapid Mart?
  4. What is the difference between OLTP and OLAP?
  5. What are the types of Dimensions?
  6. What is Confirmed Dimension?
  7. What is Junk Dimension?
  8. What is Degenerate Dimension?
  9. What are Degenerated Objects?
  10. What is Role playing Dimension?
  11. What is Casual Dimension?
  12. What are slowly changing dimensions?
  13. What are the types of slowly changing dimension (SCD)?
  14. What is MOLAP? (Multidimensional)
  15. What is ROLAP? (Relational)
  16. What is HOLAP?
  17. What is Dimension Modeling?
  18. What is Fact table?
  19. What is Dimension table?
  20. What are the different measure (fact) types?
  21. What is ODS (Operational Data Store)?
  22. What is a Star schema?
  23. What is a Snowflake schema?
  24. What is the difference between Star and Snow flake schema?
  25. What is the use of AFD? Where it can be stored?
  26. What is Data Integrator (BODI)?
  27. What is Data Federator?
  28. Are data mart and data warehouse normalized or de-normalized? Can both exist in same tier?
  29. Explain BO architecture?
  30. What are the different authentication modes you know?
  31. What is Semantic layer?
  32. What is meant by ZABO?

Overview of SAP BO Tools & Version :

Overview of SAP BO Tools and Version

  1. Business Object 6.5
  2. Business Object XiR1
  3. Business Object XiR2
  4. Business Object XiR3
  5. Business Object 3.1
  6. Business Object 4.0
  7. Business Object 4.1


Business Object Suits 3.1

  1. Admin
  2. Xcelsius Report Tool
  3. Crsytal Report Tool
  4. Deski Report Tool
  5. Universe Design Tool

Business Object Suits 4.0

  1. Admin
  2. Dashboard Report Tool ( Converted from Xcelsius )
  3. Crsytal Report Tool
  4. Webi Report Tool
  5. Information Design Tool
  6. Lumira
  7. Explorer

Business Object Suits 4.1 ( Till Dec 2014 )

  1. Admin
  2. Dashboard Report Tool ( Converted from Xcelsius )
  3. Crsytal Report Tool
  4. Webi Report Tool
  5. Universe Design Tool / Information Design Tool
  6. Lumira
  7. Explorer
  8. Mobile BI

History...


  • SAP  Business Object is one of the Module for Analysis Report.

  • SAP Business Object Acquire on 07th- October - 2007 with Amount $6.8 B, and as on Date 22nd - January - 2008 The Comparison is fully Operated by SAP.

  • As Comparison of SAP Product - Oracle is also acquiring HYPERION in 2007.

  • IBM also acquiring COGNOS in 2008.

  • By 2001 SAP Signs OEM and Re seller Agreement to budle Crystal Report.