SAP BO
SAP BO is a reporting tool product from leading Enterprise software company SAP which is mostly used to focus on Business Intelligence and reporting.SAP BusinessObjects BI (also known as BO or BOBJ) is a suite of front-end applications that allow business users to view, sort and analyze business intelligence data.
SAP Business Objects also known as BO and BOBI is the most innovative Business Intelligence suite of applications that allows business users to Sort, View and Analyze the BI data. SAP BO offers complete and most advanced solutions for Reporting, Business Planning, Performance Management, Business Consolidation, Data Visualization, Query and Analysis and Enterprise Information Management.
SAP Business Objects also known as BO and BOBI is the most innovative Business Intelligence suite of applications that allows business users to Sort, View and Analyze the BI data. SAP BO offers complete and most advanced solutions for Reporting, Business Planning, Performance Management, Business Consolidation, Data Visualization, Query and Analysis and Enterprise Information Management.
- Crystal Reports
- Xcelsius or Dashboards
- Web Intelligence
- Explorer
SAP BO
SAP BO – COURSE CONTENT
SAP BO – COURSE CONTENT
- Understanding Business Objects Universes
- Lesson introduction
- Defining BusinessObjects universe concepts
- The semantic Layer
- What is a Universe
- What type of database schema is used
- Classes and objects
- Advantages of a universe
- BusinessObjects Universe Designer components
- Starting Universe Designer
- Using the Quick Design Wizard
- Importing a universe
- Using Universe Designer module commands
- Saving and exporting a universe
- Universe file names as identifiers
- Saving a universe definition as PDF
- Giving all users access to a universe
- Activity: Viewing a universe in Universe Designer
- Using the universe development cycle
- The universe development cycle process
- Preparation phase
- Analysis phase
- Planning phase
- Implementation phase
- Table of Contents—Learner’s Guide iii
- Implementation phase 1: schema design
- Implementation phase 2: building the universe
- Testing phase
- Deployment Phase
- Updating/maintenance
- Updating/maintenance
- Activity: Planning a universe
- Creating the Course Universe
- Lesson introduction
- Describing the course database and universe
- The course database
- Creating the universe
- Setting the database connection
- Data access drivers
- ODBC connection drivers
- OLE DB connectivity
- Viewing, modifying, and deleting available connections
- Creating a new universe
- Defining universe parameters
- Identifying the universe
- Universe parameters
- Definition tab
- Summary tab
- Strategies tab
- Controls tab
- SQL tab
- Links tab
- Parameters tab
- Activity: Creating a new universe and defining its connection
- Building the Universe Structure
- Lesson introduction
- Populating the universe structure
- Designing a schema
- Schema design and the universe creation process
- Adding tables
- Manipulating tables in the universe structure
- iv Universe Design—Learner’s Guide
- Activity: Populating the universe structure
- Defining joins in a universe
- About joins and SQL WHERE clauses
- Creating joins
- About join properties
- Editing the join expression
- Using the Join SQL editor
- Detecting joins
- Setting join cardinalities
- About cardinality
- Setting cardinality manually or with the automatic detection tool
- Displaying cardinalities
- Detecting cardinality automatically
- How is cardinality detected
- Detect cardinality for all joins
- Best practices for setting join cardinality
- Join types
- Equi-joins
- Outer joins
- Theta joins
- Shortcut joins
- Self-restricting joins List Mode
- Checking integrity
- Activity: Defining joins in a universe
- Creating Dimension Objects
- Lesson introduction
- Describing classes and objects
- Classes Objects
- Creating classes and objects
- Creating classes
- Automatically creating classes and objects from a table
- Defining a new object as a detail object
- Working with classes and subclasses
- Editing the object properties
- Edit Properties: Properties
- Edit Properties: Advanced
- Edit Properties: Keys
- Edit Properties: Source Information
- Copying and pasting objects
- Table of Contents—Learner’s Guide v
- Find and replace
- Checking object integrity
- Viewing parent tables
- Testing objects
- Activity: Creating and testing classes and objects
- Quiz: Creating dimension Objects
- Creating Measure Objects
- Lesson introduction
- Defining measure object concepts
- Measure objects concepts.
- How a measure object infers SQL
- The query process Aggregation at SELECT level
- Aggregation at projection level
- Setting selection and projection aggregates
- Creating measure objects
- Measure objects
- Testing measure objects
- Activity: Creating and testing measure objects
- Creating delegated measure objects
- What is a delegated measure
- How does the delegated measure work?.
- Using a delegated measure as a weighted average
- Best practices for using delegated measures
- When are delegated measures inappropriate
- Activity: Creating and using a delegated measure
- Quiz: Creating measure Object
- Resolving Loops in a Universe
- Lesson introduction
- Understanding loops
- Recognizing loops
- Problems caused by loops Loops in a universe schema and not in the database
- What is the loop doing
- Resolving loops
- Resolving loops using aliases
- About aliases Detecting loops and inserting aliases
- vi Universe Design—Learner’s Guide
- Redefining objects
- Listing and renaming aliases
- Choosing which alias method to use
- Resolving self-referencing join loops using aliases
- Activity: Using aliases to resolve loops
- Resolving loops using contexts
- About contexts
- Detecting and creating contexts
- Creating objects for each context
- Editing a context
- Testing contexts
- Updating contexts
- Loops and shortcut joins
- Activity: Using contexts to resolve loops
- Quiz: Resolving loops in a universe
- Resolving SQL Traps
- Lesson introduction
- Understanding SQL traps and universes
- About SQL traps
- Detecting and resolving chasm traps
- Chasm traps
- Detecting chasm traps
- The chasm trap scenario
- Resolving chasm traps
- Using multiple SQL statements for each measure to resolve chasmtraps
- Drawbacks to the multiple SQL statements for each measure Method
- Using contexts to resolve chasm traps
- Activity: Resolving chasm traps
- Detecting and resolving fan traps
- Fan traps
- The fan trap scenario
- Resolving fan traps
- Using aliases and contexts to resolve fan traps
- Scenario of a fan trap with two tables in a one-to-many relationship
- Avoiding fan traps altogether
- Activity: Resolving fan traps
- Quiz: Resolving SQL traps
- Applying Restrictions on Objects
- Lesson introduction
- Restricting the data returned by objects
- Defining data restrictions
- Methods of restricting data in end-user modules
- Drawbacks to applying restrictions to objects
- An alternative to applying restrictions to objects
- Restrictions using condition objects
- Applying restrictions using the tables button
- Applying each type of restriction
- Activity: Applying restrictions
- Quiz: Applying restrictions on objects
- Using @functions with Objects
- Lesson introduction
- Using @functions
- Defining @functions
- @prompt
- @prompt syntax
- @select
- @where
- @aggregate_aware
- Activity: Using @functions
- Quiz: Using @functions with objects
- Using Hierarchies
- Lesson introduction
- Understanding hierarchies and universes Hierarchies
- Working with hierarchies
- Default hierarchies
- Custom hierarchies
- The effect of custom hierarchies on default hierarchies
- Time hierarchies
- Testing automatic time hierarchies
- Advantages and disadvantages of automatic time hierarchies viii Universe Design—Learner’s Guide
- Time hierarchies based on database functions
- Advantages and disadvantages of database function time
- Hierarchies
- Table-based time hierarchies
- Advantages and disadvantages of table-based time hierarchies
- Activity: Using hierarchies
- Using Lists of Values
- Lesson introduction
- Creating a list of values
- What is a list of values?
- Using a list of values (LOV)
- Working with LOVs in Universe Designer
- Associating an LOV with an object
- Setting options for generating LOVs
- Editing the LOVs for the entire universe
- Adding data to the list by adding columns
- Creating a cascading LOV
- Setting up a cascading LOV
- Activity: Using a cascading LOV in Web Intelligence Rich Client
- Creating Derived Tables and Indexes
- Lesson introduction
- Using derived tables
- What is a derived table?
- Adding derived tables
- Derived tables as lookup for multiple contexts
- Nested derived tables
- Creating nested derived tables
- Activity: Adding derived tables
- Applying index awareness
- What is index awareness
- Setting up index awareness
- Using an index awareness WHERE clause.
- Activity: Setting up index awareness
- WEB_INTELLIGENCE
- Using standard and custom calculations
- Using standard and custom calculations in your reports
- Standard calculations
- Using formulas to build custom calculations
- Working with functions
- Understanding calculation contexts
- What are calculation contexts
- The input context
- The output context
- Default calculation contexts
- Default contexts in a vertical table
- Default contexts in a horizontal table
- Default contexts in a crosstab
- Default contexts in a section
- Default contexts in a break
- Modifying the default calculation context with extended syntax
- Specifying input and output contexts in the same formula
- Extended syntax context operators
- Web Intelligence extended syntax keywords
- Web Intelligence functions, operators and keywords
- Web Intelligence functions
- Using Functions, Formulas and Calculations in Web Intelligence
- Aggregate functions
- Character functions
- Date and Time functions
- Data Provider functions
- Document functions
- Logical functions
- Numeric functions
- Misc functions
- Web Intelligence function and formula operators
- Mathematical operators
- Conditional operators
- Logical operators
- Function-specific operators
- Extended syntax context operators
- Web Intelligence extended syntax keywords
- The Block keyword
- The Body keyword
- The Break keyword
- The Report keyword
- The Section keyword
- Troubleshooting Web Intelligence formulas
- Formula error and information messages
- #CONTEXT
- #DATASYNC
- #DIV/0
- #INCOMPATIBLE
- #MULTIVALUE
- #OVERFLOW
- #PARTIALRESULT
- #RANK
- #RECURSIVE
- #SECURITY
- #SYNTAX
- #TOREFRESH
- #UNAVAILABLE
- #ERROR
- Calculating values with smart measures
- Smart measures defined
- Grouping sets and smart measures
- How Web Intelligence manages grouping sets
- Smart measures and the scope of analysis
- Smart measures and SQL
- Grouping sets and the UNION operator
- Smart measures and formulas
- Smart measures in formulas
- Smart measures and filters
- Smart measures and filters on dimension smart measures and drill filters
Our distinct services include :
- Material and Documents: We provide real time working documents and materials to our students.
- Free System Access : We have the latest and most up to date platforms deployed on high-end servers that are available remotely and in-class on a 24/7 basis.
- Interview Preparation: We will prepare you for interviews in your specialized area by providing some real time interview questions. We also conduct mock interviews and assist you in preparing a professional resume.
- Placement Assistance: Our placement service division provides job placement support by submitting your resumes to prospective clients and emails you any new job opportunities in the market. However, we do not provide false guarantees on securing any jobs for you. We have a history of several ex-students who have secured excellent jobs based on our WORLD class training approach, implementation of case study projects and post training support.
- Initial Job Stabilization Support: We support our students to get stabilized in their job in the first TWO months. If our students come across any issues, we are there to help them. Students can send an email to us with their issues, our experts will reply back with possible solutions within 24 hours.
- Free Class Room sessions recording: In addition to the e-class training, we will give you authorization to record all of your e-class room training sessions, so that you can go back and review.
Other Courses related
Course registration
Instructor Led Hands-on eClassroom Training.
Key Points of Training Program :
SAP BO Courses, Learn with Online Practice, in-class Seminars, Training and Certification from the list of world-class education trainers. Macropus provides Class Material, Tutorial Curriculum, Demo Videos, Sample Questions, Recommended Books, Tips and Tricks. Get lectures and practical lessons on development and programming to improve technical skills and Students will benefit with Job Placements, Visa.
-
1. What are the main features of SAP BusinessObjects?
• Information design
• Information access
• Publishing
• Lifecycle management
• Platform administration
• Portal integration
• Integration with applications -
What is the structure of SAP BusinessObjects?
Kernel is the innermost layer which represents the object’s inherent data.
Integrity layer is the second layer which represents the business logic of the object.
Interface layer is the third layer which describes the implementation and structure of the SAP Business Object, and defines the object’s interface to the outside world.
Access layer is the fourth and outermost layer which defines the technologies that can be used to obtain external access to the object’s data.
-
Are there any prerequisites?
• Understanding of SQL Basics and relational database management systems concepts & structures
• Working knowledge of Microsoft Windows applications
• Basic familiarity with Oracle E-Business Suite or the data stored therein