SAP BO Course Content

sap bo online training

Web Intelligence:

Introducing Web Intelligence

  • BO Architecture
  • Describing Web Intelligence concepts
  • Explaining Web Intelligence core functionality

Creating Web Intelligence Documents with Queries

  • Querying with Web Intelligence
  • Creating a new document
  • Modifying a document’s query
  • Working with query properties

Restricting Data Returned by a Query

  • Restricting data with query filters
  • Applying a single-value query filter
  • Using prompts to restrict data
  • Using Input Control filters
  • Using Report level filter on report
  • Modifying a query with a predefined query filter
  • Using complex filters

Designing Web Intelligence Reports

  • Working with Web Intelligence documents
  • Displaying data in tables and charts
  • Creating tables
  • Working with tables
  • Presenting data in charts

Enhancing the Presentation of Data in Reports

  • Using breaks and Sections
  • Using sorting and Ranking
  • Using report filters
  • Ranking data to see top or bottom values
  • Organizing a report into sections

Formatting Reports

  • Formatting documents
  • Formatting charts

Calculating Data with Formulas and Variables

  • Explaining formulas and variables
  • Using formulas and variables
  • Creating Formulas with Character and Date String Functions
  • Using character string functions
  • Hide a column based on value select in a prompt
  • Concatenating different data types
  • Using date functions

Using Multiple Data Sources

  • Creating multiple queries in a document
  • Synchronizing data with merged dimensions

Analyzing Data

  • Drilling in Web Intelligence documents
  • Applying Scope of Analysis on reports
  • Custom Hierarchies
  • Setting Web Intelligence drill options

Working with Advanced Query Techniques

  • Using combined queries
  • Dynamic visibility of block
  • Creating a query based on another query

Creating Hyperlinks

  • Working with hyperlinks in Web Intelligence documents
  • Creating hyperlinks in the Interactive panel
  • Linking one report to another report.

Universe Design Tool (UDT):

Understanding Business Objects Universes

  • Understanding how universes allow users to query databases using their everyday business terms

Creating the Universe

  • Creating a universe with single source system

Building the Universe Structure

  • Populating the universe structure
  • Defining joins in a universe

Creating Dimension Objects

  • Understanding classes and objects
  • Creating classes and objects

Creating Measure Objects

  • Understanding measure objects
  • Creating measure objects

Resolving SQL Traps

  • Resolving Loops in a Universe
  • Resolving loops using aliases
  • Resolving loops using shortcut joins
  • Resolving loops using contexts
  • Resolving chasm traps
  • Resolving fan traps

Using Lists of Values

  • Working with LOVs in Designer
  • Creating a cascading LOV
  • Working with Predefined filters

Applying Restrictions on Objects

  • Restricting the data returned by objects

Using Functions with Objects

  • Using @ Functions

Using Hierarchies

  • Working with hierarchies

Aggregate Awareness

  • Applying aggregate awareness to objects
  • Applying index awareness
  • Using derived tables

Securing Universes

  • Setting access restrictions on a universe

Information Design Tool :

Key Concepts:

  • Introduction to the Information Design Tool
  • What’s new in SAP Business Objects Information Design Tool 4.1
  • Concept: Navigate the interface
  • Concept: Create a universe
  • Concept: Create a multisource-enabled universe
  • Concept: Create joins
  • Concept: Compare the information design tool to the universe design tool
  • Creating the Data Foundation
  • Creating a Business Layer
  • Resolving Loops in a Universe
  • Applying Restrictions
  • Using List of Values and Parameters

Getting Started:

  • Create a project
  • Create a connection to a relational database
  • Create a data foundation based on a single source relational database
  • Create a business layer based on a single relational data source
  • Publish a new universe file based on a single data source
  • Retrieve a universe from a repository location
  • Publish a universe to a local folder
  • Retrieve a universe from a local folder
  • Open a local project
  • Delete a local project
  • Convert a repository universe from a UNV to a UNX
  • Convert a local universe from a UNV to a UNX

Connecting to Data Sources:

  • Create a connection shortcut
  • View and filter data source values in the connection editor
  • Create a connection to an OLAP data source
  • Create an OLAP connection to SAP BW using BICS
  • Create a relational connection to SQL Server using OLEDB providers
  • Create a relational connection to an Excel spreadsheet or text file using ODBC drivers
  • Create a connection to an OData data source
  • Create an OLAP connection to an SAP HANA view

Building the Structure of a Universe

  • Arrange tables in a data foundation
  • View table values in a data foundation
  • View values from multiple tables in a data foundation
  • Filter table values in a data foundation
  • Filter values from multiple tables in a data foundation
  • Sort and re-order table columns in a data foundation
  • Edit table values in a data foundation
  • Create an equi-join
  • Create a theta join
  • Create an outer join
  • Create a shortcut join
  • Create a self-restricting join using a column filter
  • Modify and remove a column filter
  • Detect join cardinalities in a data foundation
  • Manually set join cardinalities in a data foundation
  • Refresh the structure of a universe
  • Create a calculated column using string values
  • Create a calculated column using a date value
  • Create a calculated column using numeric values

Creating the Business Layer of a Universe:

  • Create business layer folders
  • Create business layer subfolders
  • Create a business layer folder and objects automatically from a table
  • Create a business layer subfolder and objects automatically from a table
  • Create dimension objects automatically from a table
  • Create a dimension
  • Create an attribute
  • Create a measure
  • Hide folders and objects in a business layer
  • Organize folders and subfolders in a business layer
  • View table and object dependencies
  • Create a dimensional business layer from an OLAP data source
  • Copy and paste folders and objects in a business layer

Filtering Data in Objects:

  • Create a pre-defined native filter
  • Create a pre-defined business filter
  • Create a pre-defined native filter using multiple objects
  • Create a pre-defined business filter using multiple objects

Working with Derived Tables:

  • Create a derived table based on an existing table in a data foundation
  • Create a derived table using the SQL Builder
  • Merge tables in a data foundation

Visualizing Data in a Universe:

  • Run a business layer query
  • Edit a business layer query
  • Run a business layer query with pre-defined filters
  • Profile column values in a chart

Building a Multi-Source Universe:

  • Add a connection to an existing multisource-enabled data foundation
  • View values from multiple tables in a multisource data foundation
  • Run a query using objects from a multisource business layer

Working with Parameters and Lists of Values:

  • Create a list of values based on query results of business objects
  • Create a list of values based on a hierarchy of business layer objects
  • Create a static list of values
  • Create a list of values based on a SQL expression
  • Create an index-aware prompt
  • Assign a list of values to a business layer object
  • Create a parameter
  • Assign a parameter to a business layer object
  • Test a parameter in a query

Resolving Loops in a Universe:

  • Resolve a loop by automatically inserting an alias table in a data foundation
  • Resolve a loop by manually inserting an alias table in a data foundation
  • Resolve a loop by automatically inserting contexts in a data foundation
  • Resolve a loop by manually inserting contexts in a data foundation

Applying Index Awareness

  • Set up primary key index awareness
  • Set up foreign key index awareness
  • Apply a WHERE clause restriction to a primary key index
  • Apply a WHERE clause restriction to a foreign key index
  • Set up multiple foreign key index awareness

Setting up Aggregate Awareness

  • Insert aggregate tables into a data foundation
  • Define aggregate aware objects in a business layer
  • Set aggregation navigation in a business layer

Securing Universes:

  • Create a data security profile for connection and query options
  • Create a data security profile that restricts access to specific rows
  • Create a business security profile for query data
  • Create a business security profile for filtered data
  • Assign security profiles to users
  • Assign security profiles to a group

SAP BOBJ 4.1 Server Admin

Understanding Business Objects Enterprise 

  • Working in Central Management Console
  • Promotional Management tool
  • Upgrade  Management tool
  • Report Conversion Tool
  • Central Configuration Manager
  • Using Central Management Server
  • Access levels

Creating and Securing Folders, Users and Groups

  • Creating folders, new users and groups
  • Applying security

Scheduling:

  • Scheduling objects
  • Scheduling on events
  • Scheduling with business calendars

Application Security  

  • Security applications
  • Lesson summary

Business Object Dashboards

Getting to know Dashboard/ Xcelsius:

  • Define the purpose of the buttons in the Xcelsius toolbar a of the Components, Object Browser, and Properties windows
  • Make changes to the canvas and access help sources

Query  as a Web Service:

  • Live Dash boards using Query as a Web Service and Live Office

Live Office:

  • Created through the use of Live Office

Importing Excel files

  • Describe the best ways to plan your models and set up your source files
  • Differentiate between the file types involved in the process
  • Import a source file
  • Define ways to update your models when your data source changes

Using charts:

  • Identify the chart components available in dashboards
  • Describe how to link to sources
  • Define when to use data ranges and series
  • Define category axis labels for a chart
  • Use the ignore end blanks option works

Using single value components:

  • Describe how single value components can add interactivity to model
  • Identify the single value components available in Crystal Xcelsius
  • Define how play options can automate the interactive parts of your models

Using selectors:

  • Describe how selectors work
  • Define how to use insert in functionality for selectors
  • Identify the selectors available in Xcelcius
  • Identify the unique requirements including in setting up to select multiple items

Applying formatting:

  • Change individual components
  • Change the font for a model
  • Apply global styles to a model
  • Apply skins to a model

Publishing models:

  • Define the different formats available to publish your models
  • Export to all formats

Setting up dynamic visibility:

  • Define how to make components visible based on conditions
  • Describe the process for setting up dynamic visibility
  • Identify the options available for dynamic visibility

Crystal Reports

Getting Started:

  • Defining database concepts
  • Planning and developing a report prototype
  • Creating a report
  • Adding tables
  • The design environment
  • Inserting objects on a report
  • Previewing a report
  • Saving a report
  • Conditional formatting
  • Positioning and sizing objects
  • Formatting objects
  • Creating sub reports and Hyperlinking

SAP Design Studio

  • Overview of Design Studio
  • Log on to the Business Object Design Studio
  • Navigate the interface
  • Create an application
  • Add a data source to an application
  • Connect to HANA and BW sources
  • Created dashboards using universe
  • Set up a basic component as a filter     
  • Display static and dynamic text in an application
  • Design interactive dashboard using HTML and scripting
  • Upload a local application to the Business Intelligence platform

SAP Lumira

  • Overview of  Lumira
  • Creating reports using Excel Sheets
  • Creating reports using HANA views
  • Creating reports by Universe
  • Manage connections and associated documents
  • Build visualizations
  • Sort, rank, calculate, and filter values in a visualization


About BharathTrainings

Bharathtrainings is best online training institute for IT Software and ERP Courses by real-time working and experienced trainers.

Be part of our bharathtrainings team!

Register As Trainer

Our Online Services