• phone icon +44 7459 302492 email message icon info@uplatz.com
  • Register
Job Meter = High

SAP BO (BusinessObjects BI)

30 Hours
Self-paced Training (pre-recorded videos)
USD 17 (USD 140)
Save 88% Offer ends on 31-Jul-2024
SAP BO (BusinessObjects BI) course and certification
777 Learners

About this Course

SAP BO is referred to the business objects with the support of business intelligence tools. The SAP Business object course covers hands-on experience od Sap’s flagship reporting, analysis and prediction tools. The SAP BO course covers an overview of each tool focusing on its features, use-case modelling and target audience.

SAP BusinessObjects (BO) Business Intelligence is a reporting tool offered by SAP. SAP BO offers Intelligent solutions that can be made use of by people ranging from analysts and other people who work with information to CEO’s.

By the end of SAP Business Objects Training you will:

·       Acquire the relevant knowledge required to clear the SAP BO certification exam.

·       Understand the core concepts of SAP’s BO module.

·       Be able to apply the knowledge learned to progress in your career as an associate level SAP BO consultant.

SAP Business Objects Training & Course will equip you with necessary skills to grab a highly-paid job in the fiercely competitive job market.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Course Objective

SAP Business objects with business intelligence Online Certification Course explains the SAP business objects through business intelligence tools. The candidate will get to know about the data modelling, use cases and also be aware about the overview and basic functionalities available in the business objects reporting tool.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


Course Description

SAP Business Objects online certification course is an enterprise based software used for data visualization, specifically in Business Intelligence (BI). It provides a toolset for mapping between the physically saved data and report creation. Data is presented through the dashboard that provides deep insight into each data and simplifies information to every user within the organization.

SAP BO online training course includes data warehouse concepts , overview of ETL and reporting tools, fundamentals of Business Objects (BO), use-case diagrams and various forms of report generation. Within SAP BusinessObjects classes, the trainer will demonstrate how to manage user profile, their permissions and generate reports from the fetched data, and learn tools including Business Object tool, Designer tool, and Supervision tool.

The Business Intelligence courses enable, the aspirants to learn and practice other data warehousing skills and accomplish their goals.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Target Audience

  • Application Consultant

  • Business Analyst

  • Business Process Owner 

  • Solution Architect

  • System Architect

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------



SAP BO (BusinessObjects BI)

Course Details & Curriculum
SAP Business Objects Training will broadly cover these topics (please download detailed curriculum for elaborate details):

1. Introduction:

  • Understanding BusinessObjects Enterprise
  • What is BusinessObjects Enterprise?
  • Working with SAP BO Launchpad ( Infoview)

2. SAP Business Objects Web Intelligence and BI Launch Pad 4.1 

  • SAP Business Objects Dashboards 4.1
  • BI launch pad: What’s new in 4.1
  • Restricting data returned by a query
  • Enhancing the presentation of data in reports
  • Formatting reports
  • Calculating data with formulas and variables
  • Using multiple data sources
  • Analyzing data
  • Managing and sharing Interactive Analysis documents
  • Reporting from Other Data Sources
  • Introducing Web Intelligence
  • Accessing corporate information with Web Intelligence
  • Understanding how universes allow you to query databases using everyday business terms.
  • Managing documents in InfoView
  • Viewing a Web Intelligence document in InfoView
  • Setting Info View Preferences
  • Creating Web Intelligence Documents with Queries
  • Getting new data with Web Intelligence
  • Creating a new Web Intelligence document
  • Modifying a document’s query
  • Working with query properties
  • Restricting Data Returned by a Query
  • Modifying a query with a predefined query filter
  • Applying a single-value query filter
  • Using prompts to restrict data
  • Using complex filters
  • Displaying data in tables and charts
  • Presenting data in free-standing cells
  • Enhancing the Presentation of Reports
  • Using breaks, calculations, sorts and report filters
  • Ranking data to see top or bottom values
  • Using alerters to highlight information
  • Organizing a report into sections
  • Copying data to other applications
  • Alternative Query Techniques Using Combined Queries Using Sub-Queries
  • Creating a Query based on another Query
  • Character and Date String Functions Using the character string functions Concatenating different data types Using date functions
  • Using If Logic
  • Grouping data using If() logic
  • Using If() to modify calculation behavior
  • Advanced Reporting Features Formatting breaks
  • Creating custom sorts
  • Displaying document data in free-standing cells
  • Alternative Query Techniques Defining Combined Query Types Using Combined Queries
  • Using Sub-Queries
  • Creating a Query on a Query
  • Character and Date String Functions Understanding Character Strings
  • Using Date Functions User-Defined Objects Creating User Objects
  • Using a User Object in a Query
  • Editing a User Object Deleting a User Object Storing a User Object Grouping Data

 3. Information Design Tool 4.0 

  • What is the Information Design Tool (IDT)
  • Create a project
  • Create a connection to a relational database (Single and Multiple databases)
  • Create the data foundation with Single & Multiple databases
  • Define the different types joins in a data foundation
  • Create a business layer
  • Create folders and objects
  • Resolve Loops and Use alias
  • Resolve Loops Use contexts
  • Resolving the fan traps and Chasm traps problem
  • Define data restrictions
  • Work with LOVs
  • Use Parameters restrict data
  • Use @functions also Aggregate Awareness
  • Create Derived Tables and Index Awareness
  • Maintain universes
  • Deploy and manage and maintain universes

4. Universe Designer Tool 4.0 

  • Understanding Business-Objects Universes.
  • Understanding how universes allow users to query databases using their everyday business terms.
  • Creating Universe Connections.
  • The course database and universe.
  • Creating the universe.
  • Building and populating the Universe Structure.
  • Defining joins in a universe.
  • Creating Dimension Objects.
  • Understanding classes and objects.
  • Creating Measure Objects.
  • Understanding measure objects.
  • Using List of Values.
  • Resolving Loops.
  • Resolving loops using aliases.
  • Resolving loops using contexts.
  • Chasm traps and Fan traps.
  • Restricting the data returned by objects.
  • Using Functions with Objects.
  • Using @ Functions.
  • Using Hierarchies.
  • Working with hierarchies.
  • Aggregate Awareness.
  • Derived Tables
  • Securing Universes.
  • Managing Universes

5. SAP Business Objects Dashboards 4.0 (Crystal Xcelsius 2011)

  • Crystal Xcelsius Overview
  • Creating Dashboards using Query As A Web Service (QAAWS) and Live Office
  • Create Drill Down dashboard reports
  • What’s new in SAP Business Objects Dashboards 4.0
  • Creating a Visualization
  • Producing interactive visualizations
  • Getting around in Xcelsius
  • Working with your Excel workbook
  • Visualizing data with charts
  • Using Xcelsius Components
  • Formatting a Visualization
  • Applying formatting options
  • Using themes and templates to apply formatting
  • Adding Interactivity to a Visualization
  • Using selectors
  • Adding dynamic visibility
  • Using live data sources
  • Connecting to BO Universes using Query as a Web Service
  • Using Live Office data
  • Creating Complex dashboards

6. SAP Crystal Reports 2011 

  • Creating reports
  • Selecting records
  • Organizing data on reports
  • Formatting & section formatting
  • Creating basic and complex formulas
  • Using variables
  • Using report templates
  • Applying conditional reporting
  • Building parameterized and specialized reports
  • Summarizing data with cross tabs
  • Using report sections
  • Representing data visually
Career Path

The SAP BO online certification course provides wide range of job opportunities owing its rapidly growing technology. The leading IT companies hire SAP BO consultants because of the end to end automated solution. 

The following are the job titles:

  • SAP BO Developer

  • Database developer

  • Analyst

  • HCM BO Reporting

  • DBA Consultant

  • Sr Business Objects and Report Developer

  • Business Object Developer

  • Basics of SQL, Database & Data Warehouse
  • Understanding of Business processes related to Manufacturing, Production Planning, Sales and Shipping industry would be an advantage
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------



Job Prospects

 

The SAP BO consultant draws an average salary of 76,434 dollar per year based on seniority level.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Interview Questions

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 

 

1. What is SAP Business Objects?

Business object can be considered as integrated analysis, reporting and query for the purpose of finding a solution to some business professionals that can be helpful for them to retrieve data from the corporate databases in a direct manner from the desktop. This retrieved information can be presented and analyzed within a document that of business objects. Business objects can be helpful as an OLAP tool to high-level management as a significant part of Decision Support Systems.

 

2. Explain the pros of using business objects.

There are many advantages in making use of business objects, and they are

• User friendliness

• Familiar business terms

• Graphical interface

• Deployment of documents on an enterprise basis by making use of WebI

• Dragging and dropping

• Powerful reports for a lesser amount of time.

 

3. List out the different products related to Business Objects.

There are various kinds of products related to business objects, and they are

• User module

• Designer

• Supervisor

• Auditor

• Set Analyzer

• Info View

• Business Objects – Software Development – Kit

• Broadcast Agent

 

4. Define  Designer.

The designer is a module related to Business Objects IS used by the designers for creating and maintaining universes. Universes can be considered as a semantic layer that can isolate the end users from the various issues that are technical and related to the structure of the database. Universe designers have the possibility for distributing the universes to the end users after moving these as a file through the system of files or can be done by exporting the files to the repository.

 

5. What are the kinds of modes associated with designer and business objects?

There are especially two different kinds of modes associated with these platforms, they are

• Enterprise mode

• Workgroup mode

 

6. List out the various kinds of methods related to multidimensional analysis that is inside business objects.

There are two different methods related to multidimensional analysis available inside BO and these methods are

• Slice & Dice

• Drill down

 

7. List out the kinds of users associated with business objects.

Different kinds of users associated with the business object are

• General supervisor

• Supervisor

• Graphical Interface

• Designer

• Supervisor Designer

• End User

• Versatile User

 

8. What are the various data sources available?

Business objects help you in accessing the data from a variety of sources. You have the possibility of obtaining data from RDBMS like Oracle, MS SQL server and IBM DB2.

 

9. Define the kinds of data providers?

There are various kinds of data providers available for the business objects, and they are

• Stored procedures

• Queries over universe

• Freehand – SQL

• VBA procedures

• SAP

• OLAP servers

• Personal data files

 

10. Define the drill mode.

Drill is a kind of analysis mode associated with business objects and helps in breaking down data as well as in viewing data from all the possible angles and the levels of detail for discovering the factor that has caused a good or a bad result.

 

11. What is a personal connection?

A personal connection can be created only by a single user, and it can’t be made used by others. The details regarding such a connection can be usually stored inside PDAC.LSI file.

 

12. What is Shared connection?

This is a kind of connection that is usually used by another user via a server which is a shared one. The details regarding the connection can be stored within the SDAC>LSI file which can be found within the installation folder of the business objects.

 

13. What is a secured connection?

Secured connection is a kind of connection that can be helpful in overcoming the various limitations associated with the former connections. The rights related to this kind of connection can be set over documents as well as objects. Universes can be brought inside the central repository only by making use of the secured connection. The parameters regarding these connection care usually saved inside CMS.

 

14. Define custom hierarchies?

The custom hierarchies can be used for defining the universe for facilitating drill down that is customized and can happen between objects from different or same classes considering the user requirements.

 

15. How can custom Hierarchies be created?

The custom hierarchies can be created by following the path tools ->hierarchies in BO designer.

 

16. Define a context in the universe.

Context can be defined as the particular path of the join between a specific group of joins or the tables for the purpose of a particular query. A particular object that can be found inside the column of a table, belonging to particular context is supposed to be compatible with all the various kinds of objects belonging to the same context. In the case of objects that are from the various kinds of context, different kinds of SQL can be generated, and the results can be merged inside the micro cube. This is for making sure that there is no incorrect result associated with a loop or any other kind of issue related with join path.

 

17. How can Contexts be created?

Context can be created by making use of feature associated with context or by manual procedures. The context is usually created by making use of logical calculation or based on the business requirements. The detect context may not be much useful in this case and so it should be done by making use of the manual procedure.

 

18. Define a Chasm Trap.

Chasm trap is a condition that arises when the values inside the fact table get inflated at the time of measuring the values from two different fact tables by considering the dimensions inside the dimension table.

 

19. How can Chasm Trap be solved?

Chasm trap should be solved by making use of two different methods.

• In the case of SQL parameters in the universe, the option generates numerous queries for each and every measure that needs to be chosen. This helps in generating a SQL statement for every measure and gives the correct results.

• Another approach is to include two joints in different contexts, where the problem will get solved by generating two synchronized queries.

 

20. What are the utilities of Derived tables?

Using SQL queries from the database level, Derived tables are created in the universe. The columns of the derived table will be the columns selected in the query. Derived table can be used in the complex calculations which are difficult to be achieved in the report levels. Using a dblink, tables can be accessed from a different schema, is another use of derived tables.

 

21. Define User Objects.

User objects are a universe of classes and objects which is created by the universe designer. Once the objects consisted of the universe does not match your necessities, then the user can create his own objects called User objects.

 

22. List out the @functions.

The @functions are:

• @Aggregate_Aware

• @Script

• @Select

• @Variable

• @where

• @Prompt

 

23. What is the use of @functions?

The @prompt function asks the end user to enter any specific values. The Visual Basics for applications macro’s results will be recovered by using @Script function. An existing statements SELECT statement can be re-used by using @Select function. For a name or variable, the value assigned to it will be referenced using @Variable. An existing object’s where clause can be re-used by @Where functions.

 

24. How many Domains are there in Business Objects? What are they?

There are three Domains in Business Objects and they are:

• Security

• Document

• Universe

 

25. How to access one derived table from another?

Using @Derived_table function, we can access one derived table from another. The syntax is:

@derived_table(the derived table name)

 

26. Define Slice in Business Objects.

Slice works with the master or detail reports and it is used to rename, reset and delete the blocks.

 

27. Differentiate Dice and Slice.

• Slice: It renames, reset and delete the blocks. It works with the master/detail report.

• Dice: It displays the data and removes the data.  It turns the crosstabs and tables into charts and vice versa.

 

28. What is a master/detail report?

• Large blocks of data can be split into sections by using master/detail report. Repeating values can be avoided by using this and also the subtotals can be displayed.

 

 29. Define a class.

The class can be defined as a collection of objects in a universe. Subclasses can be derived from classes and using these classes and the subclasses, we can create a hierarchy.

 

30. How many approaches are there for linking universes?

There are three approaches available for linking the universes and they are:

•   The Kernal approach.

• The Master approach.

•   The Component approach.

 

 31. What is data mining?

Data mining is the process through which you can extract the required details from the database, which can be made used for making conclusions.

 

 32. List out the available Drill modes.

Drill mode helps to analyze data from different angles and different state of details. The available Drill modes are;

•    Drill up.

•    Drill down.

•    Drill by.

•    Drill through.

 

 33. Define aggregate_awarness.

when we have the same fact tables in different grains, we use the aggregate_awarness function to define one object for measures in fact tables. The syntax is as

@aggregate_aware(highest_level.lower level)

 

 34. Define the term fan trap?

A one to many join, links to a table which respond with another one to many join links is called fan trap.

 

35. Define Data provider.

The query or the data source is called as the data provider.

 

 36. When we use a context?

Context is created when the dimension objects are present in one or both fact tables.

 

 37. What is the standard mode?

Only the users within the group can be accessed in this mode.

 

38. List out the schemas supported by Business Objects Designer.

There are five different schemas supported by Business Objects designer and they are:

• star schema.

• Snowflake Schema

• Multistar Schema

• Normalized production schema.

• Data warehouse with aggregates.

 

 39. What is a Channel?

Channel is a website with ‘push’ technology. It is to make the users know up-to-date information. Each and every Business Objects channel will be associated with a broadcast agent, who can have several channels.

 

 40. What are the restrictions over user objects?

User objects are not shared with other end users. It is stored in a specific user object definition file. So if any end-user tries to refresh or edit the query contains another user’s user object, it will be automatically cleaned and removed.

 

 41. List out the tasks of universe designer.

The tasks consist of,

• Designing the universe.

• Creating the universe.

• Maintaining the universe.

• Distributing the universe

 

 42. List out the main components of the designer interface.

The main components it consists of are:

• The table browser.

• The structure pane.

• The universe pane.

 

43. What do you mean by report bursting?

To maintain the version documents according to the user profiles, we use report bursting.

 

44. Define WEBI.

Web intelligence is a solution that is specialized in supporting decisions related to queries, reports, and analysis.

 

 45. Abbreviation of DSS is?

Decision Support Systems.

 

46. Define strategies.

To automatically extract structural information from a database or from a flat file we use a script known as strategy.

 

47. Define the universe.

It is a set of objects and classes. These objects and classes will be intended for an application or a group of users.

 

 48. Define secured mode.

Secured mode restricts the access of specific users over specific commands.

 

 49. What is Drill by?

Using drill by we can move to other hierarchy and analyze the other data, which belongs to another hierarchy.

 

 50. What is a list of values?

 

It is a file which contains the data values associated with an object.

 

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


FAQs
Will this course help me clear the certification exam? +
Which is better - Self-paced training or Instructor-led training? +
Who are the trainers? +
What if I miss a class? +
How will I execute the practical? +
Is the course material accessible after completion of the course? +
Is there any offer/discount that I can avail? +
Will I get a refund if I cancel my enrollment? +
What if I have queries after completion of the course? +

Didn't find what you are looking for?  Contact Us