Tag Archives: SAP Business Objects

SAP Business Objects Interview Questions and Answers

SAP BO Interview Questions And Answers

Q. What is a personal connection?

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.

Q. What is Shared connection?

This is a kind of connection that is usually made used by other user via a server which is 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.

Q. 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 with this kind of connection can be set over documents as well as objects. Universes can be brought inside central repository only by making use of secured connection. The parameters regarding these connection care usually saved inside CMS.

Q. 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.

Q. How can custom Hierarchies be created?

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

Q. Define a context in the universe.

Context can be defined as the particular path of 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 to 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 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.

Q. How can Contexts be created?

Context can be created by making use of feature associated with context or by manual procedures. The context are 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 manual procedure.

Q. 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 dimension table.

SAP BO 4.1 & SAP BO 4.2 Interview Questions Please Contact Us

FOR Course Content Click me

SAP BOBJ Online Training

SAP BOBJ Online training Course Content.

DATA WAREHOUSING CONCEPTS

  • OLTP vs. OLAP
  • Multi Dimensional modeling
  • Data warehouse Life cycle
  • Star/Snow/Extended Star schema design

 

Introduction to SAP Business Objects

ARCHITECTURAL OVERVIEW

  • Client tier components
  • Application tier components
  • Intelligence tier
  • Processing tier
  • Data tier
  • Security management Information flow

 

DATABASE CONCEPTS NEEDED FOR DATA WAREHOUSING
Joins & Cardinality

  • Views/Materialized Views
  • Date/Time Functions
  • Conversion functions
  • Derived table & Stored Procedure

 

Information Designer Tool /UNIVERSE DESIGN

  • Understanding Business Objects Universes
  • Creating the Core Universe
  • Building the Universe Structure
  • Business Layer
  • Creating Measure Objects
  • Resolving Loops in a Universe
  • Resolving SQL Traps
  • Using List of Values
  • Applying Restrictions on Objects
  • Using @Functions with Objects
  • Deriving Tables & Indexes
  • Working with Aggregate Awareness
  • Designing Advanced Objects
  • Creating Predefined Condition
  • LOVs & Joins
  • Securing Universes
  • Maintaining & Optimizing Universes
  • Creating Multi Universe from Other Data sources
  • Converting UNV files to UNX files

 

WEB INTELLIGENCE

    • Understand concepts of Web intelligence
    • Create Web Intelligence documents with Queries
    • Restrict data returned by a query
    • Design a report
    • Enhance the presentation of data in reports
    • Format a report
    • Calculate data with formulas and variables
    • Use multiple data sources
    • Analyze data
    • Manage and share Web Intelligence documents
    • Work with Advanced Query techniques
    • Work with calculation contexts
    • Create formulas with character & date string functions
    • Use “If” logic
    • Work with additional reporting techniques
  • Create hyperlinks
  • Multiple query creation

 

CRYSTAL REPORTS

  • Planning a Report
  • Selecting Records
  • Formatting a Report
  • Representing Data Visually
  • Distributing Reports
  • Creating Basic Formulas
  • Organizing Data on a Report
  • Applying Section Formatting
  • Applying Conditional Reporting
  • Using the Repository
  • Using Report Templates
  • Creating Formulas
  • Building Parameterized Reports
  • Summarizing Data with Cross-Tabs
  • Using Report Sections
  • Managing Reports
  • Presenting Data Visually
  • Add hyperlinks to a report

 

DASHBOARD

  • Understanding Dashboard Manager
  • Setting Up Dashboard Manager
  • Creating Metrics
  • Automating Dashboards with Rules
  • Creating Analytics
  • Creating Personal Dashboards
  • Creating Corporate Dashboards
  • Guiding Dashboard Navigation

 

MIGRATION FUNDAMENTALS

  • How Business Objects Enterprise XI 3.0
  • Migration concepts
  • Import Wizard Concepts
  • Understanding object migration
  • Understanding user and group migration
  • Migration planning and assessment
  • After migration with the Import Wizard

 

ADMINISTRATION

  • Understand the Business Objects
  • Enterprise interface & architecture
  • Manage Business Objects Enterprise content
  • Secure Business Objects Enterprise content
  • Secure application security
  • Schedule content
  • Publish reports
  • Identify Business Objects Enterprise architecture
  • Perform common server management tasks
  • Manage the Business Objects Enterprise servers

 

QUERY AS WEB SERVICE

  • Configuring the QWS with BO System
  • Creating Web service report from Universes
  • Creating WSDL reports
  • Using WSDL reports in external application

 

WEBI-RICH CLIENT

  • Installing Web Intelligence Rich Client
  • Web Intelligence Rich Client working modes
  • Launching Web Intelligence Rich Client
  • To set user preferences in Web Intelligence Rich Client
  • Working with documents
  • Working with universes in Web Intelligence Rich Client
  • Accessing Web Intelligence from Info View
  • Working with queries in Web Intelligence Rich Client

 

SECURITY IMPLEMENTATION

  • Creating Secured users & group
  • Creation secured connections
  • Creation of Secured objects
  • Creation of security at Table, Column &row level
  • Creation of secured restriction set and mapping to users or groups

 

IMPORT WIZARDPUBLISHING WIZARD

  • Using Import wizard
  • Creation of BIAR
  • Migrating the BO objects
  • From one CMS TO ANOTHER CMS
  • Migrating the objects from one
  • Domain to another (dev/stage/Prod)
  • Backup & Maintenance Deployment

 

BUSINESS VIEW MANAGER

  • Creation of Semantic layer for Crystal reports
  • Creation of Dynamic list of values in Crystal reports
  • Creation of Cascading list of values in Crystal reports
  • Creating Data connection and Dynamic data connection
  • Creation of Data foundation
  • Creation of Business Element
  • Creation of Business View
  • Creation of LOV
  • Saving the Business view to repository
  • Accessing the Business View in Crystal reports using Database expert
  • Creation of Crystal reports using Business

 

LIVE OFFICE REPORTING

  • Describe the benefits of using Live Office
  • Connect to the repository
  • Navigate the Live Office menu
  • Insert charts, crosstabs, and fields from a Crystal report
  • Insert report parts from a Web Intelligence document
  • Insert a new query based on a Universe
  • Insert Live Office objects into an email
  • Navigate and refresh Live Office objects
  • Enable consolidated prompts
  • Set refresh settings for objects
  • Set parameter binding
  • Take a snapshot
  • Save Live Office documents to the repository
  • Open and view Live Office documents from the repository

 

SAP BW Reporting

  • Creation of Web intelligence reports using Info cube & BW Query
  • Creation of Dash boards using Info cube & BW Query
  • Creation of Crystal reports using Info cube & BW Query
  • Creating BICS and OLAP for BW connections

 

SAP HANA Reporting

  • Creation of Web intelligence reports
  • Creation of Dash boards
  • Creation of Crystal reports

SAP Business Objects Training in Singapore

SAP Business Objects training Course Content.

DATA WAREHOUSING CONCEPTS

  • OLTP vs. OLAP
  • Multi Dimensional modeling
  • Data warehouse Life cycle
  • Star/Snow/Extended Star schema design

 

Introduction to SAP Business Objects

ARCHITECTURAL OVERVIEW

  • Client tier components
  • Application tier components
  • Intelligence tier
  • Processing tier
  • Data tier
  • Security management Information flow

 

DATABASE CONCEPTS NEEDED FOR DATA WAREHOUSING
Joins & Cardinality

  • Views/Materialized Views
  • Date/Time Functions
  • Conversion functions
  • Derived table & Stored Procedure

 

Information Designer Tool /UNIVERSE DESIGN

  • Understanding Business Objects Universes
  • Creating the Core Universe
  • Building the Universe Structure
  • Business Layer
  • Creating Measure Objects
  • Resolving Loops in a Universe
  • Resolving SQL Traps
  • Using List of Values
  • Applying Restrictions on Objects
  • Using @Functions with Objects
  • Deriving Tables & Indexes
  • Working with Aggregate Awareness
  • Designing Advanced Objects
  • Creating Predefined Condition
  • LOVs & Joins
  • Securing Universes
  • Maintaining & Optimizing Universes
  • Creating Multi Universe from Other Data sources
  • Converting UNV files to UNX files

 

WEB INTELLIGENCE

    • Understand concepts of Web intelligence
    • Create Web Intelligence documents with Queries
    • Restrict data returned by a query
    • Design a report
    • Enhance the presentation of data in reports
    • Format a report
    • Calculate data with formulas and variables
    • Use multiple data sources
    • Analyze data
    • Manage and share Web Intelligence documents
    • Work with Advanced Query techniques
    • Work with calculation contexts
    • Create formulas with character & date string functions
    • Use “If” logic
    • Work with additional reporting techniques
  • Create hyperlinks
  • Multiple query creation

 

CRYSTAL REPORTS

  • Planning a Report
  • Selecting Records
  • Formatting a Report
  • Representing Data Visually
  • Distributing Reports
  • Creating Basic Formulas
  • Organizing Data on a Report
  • Applying Section Formatting
  • Applying Conditional Reporting
  • Using the Repository
  • Using Report Templates
  • Creating Formulas
  • Building Parameterized Reports
  • Summarizing Data with Cross-Tabs
  • Using Report Sections
  • Managing Reports
  • Presenting Data Visually
  • Add hyperlinks to a report

 

DASHBOARD

  • Understanding Dashboard Manager
  • Setting Up Dashboard Manager
  • Creating Metrics
  • Automating Dashboards with Rules
  • Creating Analytics
  • Creating Personal Dashboards
  • Creating Corporate Dashboards
  • Guiding Dashboard Navigation

 

MIGRATION FUNDAMENTALS

  • How Business Objects Enterprise XI 3.0
  • Migration concepts
  • Import Wizard Concepts
  • Understanding object migration
  • Understanding user and group migration
  • Migration planning and assessment
  • After migration with the Import Wizard

 

ADMINISTRATION

  • Understand the Business Objects
  • Enterprise interface & architecture
  • Manage Business Objects Enterprise content
  • Secure Business Objects Enterprise content
  • Secure application security
  • Schedule content
  • Publish reports
  • Identify Business Objects Enterprise architecture
  • Perform common server management tasks
  • Manage the Business Objects Enterprise servers

 

QUERY AS WEB SERVICE

  • Configuring the QWS with BO System
  • Creating Web service report from Universes
  • Creating WSDL reports
  • Using WSDL reports in external application

 

WEBI-RICH CLIENT

  • Installing Web Intelligence Rich Client
  • Web Intelligence Rich Client working modes
  • Launching Web Intelligence Rich Client
  • To set user preferences in Web Intelligence Rich Client
  • Working with documents
  • Working with universes in Web Intelligence Rich Client
  • Accessing Web Intelligence from Info View
  • Working with queries in Web Intelligence Rich Client

 

SECURITY IMPLEMENTATION

  • Creating Secured users & group
  • Creation secured connections
  • Creation of Secured objects
  • Creation of security at Table, Column &row level
  • Creation of secured restriction set and mapping to users or groups

 

IMPORT WIZARDPUBLISHING WIZARD

  • Using Import wizard
  • Creation of BIAR
  • Migrating the BO objects
  • From one CMS TO ANOTHER CMS
  • Migrating the objects from one
  • Domain to another (dev/stage/Prod)
  • Backup & Maintenance Deployment

 

BUSINESS VIEW MANAGER

  • Creation of Semantic layer for Crystal reports
  • Creation of Dynamic list of values in Crystal reports
  • Creation of Cascading list of values in Crystal reports
  • Creating Data connection and Dynamic data connection
  • Creation of Data foundation
  • Creation of Business Element
  • Creation of Business View
  • Creation of LOV
  • Saving the Business view to repository
  • Accessing the Business View in Crystal reports using Database expert
  • Creation of Crystal reports using Business

 

LIVE OFFICE REPORTING

  • Describe the benefits of using Live Office
  • Connect to the repository
  • Navigate the Live Office menu
  • Insert charts, crosstabs, and fields from a Crystal report
  • Insert report parts from a Web Intelligence document
  • Insert a new query based on a Universe
  • Insert Live Office objects into an email
  • Navigate and refresh Live Office objects
  • Enable consolidated prompts
  • Set refresh settings for objects
  • Set parameter binding
  • Take a snapshot
  • Save Live Office documents to the repository
  • Open and view Live Office documents from the repository

 

SAP BW Reporting

  • Creation of Web intelligence reports using Info cube & BW Query
  • Creation of Dash boards using Info cube & BW Query
  • Creation of Crystal reports using Info cube & BW Query
  • Creating BICS and OLAP for BW connections

 

SAP HANA Reporting

  • Creation of Web intelligence reports
  • Creation of Dash boards
  • Creation of Crystal reports

SAP Business Objects Training

SAP Business Objects Training Live Instructor Led Classes, Learn SAP Business Objects Online Training with experts ✓BO Course Material ✓Certification Training ✓Job Support Real time Scenarios 24/7 Customer Support Pay Installment

SAP Business Objects training Course Content.

DATA WAREHOUSING CONCEPTS

  • OLTP vs. OLAP
  • Multi Dimensional modeling
  • Data warehouse Life cycle
  • Star/Snow/Extended Star schema design

 

Introduction to SAP Business Objects

ARCHITECTURAL OVERVIEW

  • Client tier components
  • Application tier components
  • Intelligence tier
  • Processing tier
  • Data tier
  • Security management Information flow

 

DATABASE CONCEPTS NEEDED FOR DATA WAREHOUSING
Joins & Cardinality

  • Views/Materialized Views
  • Date/Time Functions
  • Conversion functions
  • Derived table & Stored Procedure

 

Information Designer Tool /UNIVERSE DESIGN

  • Understanding Business Objects Universes
  • Creating the Core Universe
  • Building the Universe Structure
  • Business Layer
  • Creating Measure Objects
  • Resolving Loops in a Universe
  • Resolving SQL Traps
  • Using List of Values
  • Applying Restrictions on Objects
  • Using @Functions with Objects
  • Deriving Tables & Indexes
  • Working with Aggregate Awareness
  • Designing Advanced Objects
  • Creating Predefined Condition
  • LOVs & Joins
  • Securing Universes
  • Maintaining & Optimizing Universes
  • Creating Multi Universe from Other Data sources
  • Converting UNV files to UNX files

 

WEB INTELLIGENCE

    • Understand concepts of Web intelligence
    • Create Web Intelligence documents with Queries
    • Restrict data returned by a query
    • Design a report
    • Enhance the presentation of data in reports
    • Format a report
    • Calculate data with formulas and variables
    • Use multiple data sources
    • Analyze data
    • Manage and share Web Intelligence documents
    • Work with Advanced Query techniques
    • Work with calculation contexts
    • Create formulas with character & date string functions
    • Use “If” logic
    • Work with additional reporting techniques
  • Create hyperlinks
  • Multiple query creation

 

CRYSTAL REPORTS

  • Planning a Report
  • Selecting Records
  • Formatting a Report
  • Representing Data Visually
  • Distributing Reports
  • Creating Basic Formulas
  • Organizing Data on a Report
  • Applying Section Formatting
  • Applying Conditional Reporting
  • Using the Repository
  • Using Report Templates
  • Creating Formulas
  • Building Parameterized Reports
  • Summarizing Data with Cross-Tabs
  • Using Report Sections
  • Managing Reports
  • Presenting Data Visually
  • Add hyperlinks to a report

 

DASHBOARD

  • Understanding Dashboard Manager
  • Setting Up Dashboard Manager
  • Creating Metrics
  • Automating Dashboards with Rules
  • Creating Analytics
  • Creating Personal Dashboards
  • Creating Corporate Dashboards
  • Guiding Dashboard Navigation

 

MIGRATION FUNDAMENTALS

  • How Business Objects Enterprise XI 3.0
  • Migration concepts
  • Import Wizard Concepts
  • Understanding object migration
  • Understanding user and group migration
  • Migration planning and assessment
  • After migration with the Import Wizard

 

ADMINISTRATION

  • Understand the Business Objects
  • Enterprise interface & architecture
  • Manage Business Objects Enterprise content
  • Secure Business Objects Enterprise content
  • Secure application security
  • Schedule content
  • Publish reports
  • Identify Business Objects Enterprise architecture
  • Perform common server management tasks
  • Manage the Business Objects Enterprise servers

 

QUERY AS WEB SERVICE

  • Configuring the QWS with BO System
  • Creating Web service report from Universes
  • Creating WSDL reports
  • Using WSDL reports in external application

 

WEBI-RICH CLIENT

  • Installing Web Intelligence Rich Client
  • Web Intelligence Rich Client working modes
  • Launching Web Intelligence Rich Client
  • To set user preferences in Web Intelligence Rich Client
  • Working with documents
  • Working with universes in Web Intelligence Rich Client
  • Accessing Web Intelligence from Info View
  • Working with queries in Web Intelligence Rich Client

 

SECURITY IMPLEMENTATION

  • Creating Secured users & group
  • Creation secured connections
  • Creation of Secured objects
  • Creation of security at Table, Column &row level
  • Creation of secured restriction set and mapping to users or groups

 

IMPORT WIZARDPUBLISHING WIZARD

  • Using Import wizard
  • Creation of BIAR
  • Migrating the BO objects
  • From one CMS TO ANOTHER CMS
  • Migrating the objects from one
  • Domain to another (dev/stage/Prod)
  • Backup & Maintenance Deployment

 

BUSINESS VIEW MANAGER

  • Creation of Semantic layer for Crystal reports
  • Creation of Dynamic list of values in Crystal reports
  • Creation of Cascading list of values in Crystal reports
  • Creating Data connection and Dynamic data connection
  • Creation of Data foundation
  • Creation of Business Element
  • Creation of Business View
  • Creation of LOV
  • Saving the Business view to repository
  • Accessing the Business View in Crystal reports using Database expert
  • Creation of Crystal reports using Business

 

LIVE OFFICE REPORTING

  • Describe the benefits of using Live Office
  • Connect to the repository
  • Navigate the Live Office menu
  • Insert charts, crosstabs, and fields from a Crystal report
  • Insert report parts from a Web Intelligence document
  • Insert a new query based on a Universe
  • Insert Live Office objects into an email
  • Navigate and refresh Live Office objects
  • Enable consolidated prompts
  • Set refresh settings for objects
  • Set parameter binding
  • Take a snapshot
  • Save Live Office documents to the repository
  • Open and view Live Office documents from the repository

 

SAP BW Reporting

  • Creation of Web intelligence reports using Info cube & BW Query
  • Creation of Dash boards using Info cube & BW Query
  • Creation of Crystal reports using Info cube & BW Query
  • Creating BICS and OLAP for BW connections

 

SAP HANA Reporting

  • Creation of Web intelligence reports
  • Creation of Dash boards
  • Creation of Crystal reports

 

 

Header Content Block

SAP Business Objects Training

SAP>> BOBO AdminBI/BWHANAS/4HANAFIORIBODSBPCHR/HCMSuccess FactorsMMPPHybrisNETWEAVERPSABAP HRABAPFICOSDBASISWork Flow| Sales Force | Oracle Apps ->> TechnicalSCMFinanceOAF | Hyperion ->> EssbasePlanningHFMFDMEEHyperion AdminDRMODI| OBIEE | MS BI| Tableau| Big Data| Data Warehousing | COGNOS TM1 | NetApp | GRA | SQL Server | Android | SAS

Business Objects Online Training

SAP Business Objects Online Training Course Content.

DATA WAREHOUSING CONCEPTS

  • OLTP vs. OLAP
  • Multi Dimensional modeling
  • Data warehouse Life cycle
  • Star/Snow/Extended Star schema design

Introduction to SAP Business Objects

ARCHITECTURAL OVERVIEW

  • Client tier components
  • Application tier components
  • Intelligence tier
  • Processing tier
  • Data tier
  • Security management Information flow

DATABASE CONCEPTS NEEDED FOR DATA WAREHOUSING
Joins & Cardinality

  • Views/Materialized Views
  • Date/Time Functions
  • Conversion functions
  • Derived table & Stored Procedure

Information Designer Tool /UNIVERSE DESIGN

  • Understanding Business Objects Universes
  • Creating the Core Universe
  • Building the Universe Structure
  • Business Layer
  • Creating Measure Objects
  • Resolving Loops in a Universe
  • Resolving SQL Traps
  • Using List of Values
  • Applying Restrictions on Objects
  • Using @Functions with Objects
  • Deriving Tables & Indexes
  • Working with Aggregate Awareness
  • Designing Advanced Objects
  • Creating Predefined Condition
  • LOVs & Joins
  • Securing Universes
  • Maintaining & Optimizing Universes
  • Creating Multi Universe from Other Data sources
  • Converting UNV files to UNX files

WEB INTELLIGENCE

    • Understand concepts of Web intelligence
    • Create Web Intelligence documents with Queries
    • Restrict data returned by a query
    • Design a report
    • Enhance the presentation of data in reports
    • Format a report
    • Calculate data with formulas and variables
    • Use multiple data sources
    • Analyze data
    • Manage and share Web Intelligence documents
    • Work with Advanced Query techniques
    • Work with calculation contexts
    • Create formulas with character & date string functions
    • Use “If” logic
    • Work with additional reporting techniques
  • Create hyperlinks
  • Multiple query creation

CRYSTAL REPORTS

  • Planning a Report
  • Selecting Records
  • Formatting a Report
  • Representing Data Visually
  • Distributing Reports
  • Creating Basic Formulas
  • Organizing Data on a Report
  • Applying Section Formatting
  • Applying Conditional Reporting
  • Using the Repository
  • Using Report Templates
  • Creating Formulas
  • Building Parameterized Reports
  • Summarizing Data with Cross-Tabs
  • Using Report Sections
  • Managing Reports
  • Presenting Data Visually
  • Add hyperlinks to a report

DASHBOARD

  • Understanding Dashboard Manager
  • Setting Up Dashboard Manager
  • Creating Metrics
  • Automating Dashboards with Rules
  • Creating Analytics
  • Creating Personal Dashboards
  • Creating Corporate Dashboards
  • Guiding Dashboard Navigation

MIGRATION FUNDAMENTALS

  • How Business Objects Enterprise XI 3.0
  • Migration concepts
  • Import Wizard Concepts
  • Understanding object migration
  • Understanding user and group migration
  • Migration planning and assessment
  • After migration with the Import Wizard

ADMINISTRATION

  • Understand the Business Objects
  • Enterprise interface & architecture
  • Manage Business Objects Enterprise content
  • Secure Business Objects Enterprise content
  • Secure application security
  • Schedule content
  • Publish reports
  • Identify Business Objects Enterprise architecture
  • Perform common server management tasks
  • Manage the Business Objects Enterprise servers

QUERY AS WEB SERVICE

  • Configuring the QWS with BO System
  • Creating Web service report from Universes
  • Creating WSDL reports
  • Using WSDL reports in external application

WEBI-RICH CLIENT

  • Installing Web Intelligence Rich Client
  • Web Intelligence Rich Client working modes
  • Launching Web Intelligence Rich Client
  • To set user preferences in Web Intelligence Rich Client
  • Working with documents
  • Working with universes in Web Intelligence Rich Client
  • Accessing Web Intelligence from Info View
  • Working with queries in Web Intelligence Rich Client

SECURITY IMPLEMENTATION

  • Creating Secured users & group
  • Creation secured connections
  • Creation of Secured objects
  • Creation of security at Table, Column &row level
  • Creation of secured restriction set and mapping to users or groups

IMPORT WIZARDPUBLISHING WIZARD

  • Using Import wizard
  • Creation of BIAR
  • Migrating the BO objects
  • From one CMS TO ANOTHER CMS
  • Migrating the objects from one
  • Domain to another (dev/stage/Prod)
  • Backup & Maintenance Deployment

BUSINESS VIEW MANAGER

  • Creation of Semantic layer for Crystal reports
  • Creation of Dynamic list of values in Crystal reports
  • Creation of Cascading list of values in Crystal reports
  • Creating Data connection and Dynamic data connection
  • Creation of Data foundation
  • Creation of Business Element
  • Creation of Business View
  • Creation of LOV
  • Saving the Business view to repository
  • Accessing the Business View in Crystal reports using Database expert
  • Creation of Crystal reports using Business

LIVE OFFICE REPORTING

  • Describe the benefits of using Live Office
  • Connect to the repository
  • Navigate the Live Office menu
  • Insert charts, crosstabs, and fields from a Crystal report
  • Insert report parts from a Web Intelligence document
  • Insert a new query based on a Universe
  • Insert Live Office objects into an email
  • Navigate and refresh Live Office objects
  • Enable consolidated prompts
  • Set refresh settings for objects
  • Set parameter binding
  • Take a snapshot
  • Save Live Office documents to the repository
  • Open and view Live Office documents from the repository

SAP BW Reporting

  • Creation of Web intelligence reports using Info cube & BW Query
  • Creation of Dash boards using Info cube & BW Query
  • Creation of Crystal reports using Info cube & BW Query
  • Creating BICS and OLAP for BW connections

SAP HANA Reporting

  • Creation of Web intelligence reports
  • Creation of Dash boards
  • Creation of Crystal reports

SAP BOBJ Online Training Singapore

SAP BOBJ Online Training Singapore Course Content

Introduction – SAP Business objects

Basics: (4 Days)
  • Data Base Concepts
  • Data Ware Housing Concepts
  • SQL Query Writing
  • BO R4.0 – (1 Day)
  • What’s new in BO R4.0
  • BI R4.0 Architecture
  • Universe Design (11 Days) Universe on General System Data (Non Sap)
Day 01: Understanding Business Objects Universes.
  • Unit 1: Understanding Business Objects Universes
  • Using the Universe Development Cycle.
Day 02: Populating the Universe Structure.
  • Unit 2: Building the Universe Structure
  • Defining Joins in a Universe.
Day 03: Objects and Classes.
  • Unit 3: Creating Objects
  • Creating classes and objects.
Day 04: Crating a list of Values.
  • Unit 4: Using List Of Values
  • Working with LOVs in a designer.
  • Creating a cascading LOV
Day5: Understanding the loops.
  • Unit 5: Resolving Loops in a Universe
  • Resolving the loops using Aliases.
Day6: Resolving the loops using shortcut joins.
  • Resolving the loops using contexts.
  • Unit 6: Resolving SQL Traps
Day7: Understanding SQL traps and universes.
  • Resolving chasm traps.
  • Resolving fan traps.
  • Unit 7: Using Functions with Objects & Using Hierarchies
Day8: Using @Functions.
  • Understanding the Hierarchies.
  • Unit 8: Aggregate Awareness
Day 9: Understanding aggregate awareness and Universes.
  • Applying aggregate awareness to Objects.
  • Unit 9: Derived Tables and Indexes & Linking Universes
Day10: Using derived tables
  • Applying index awareness
  • Understanding linked universes.
  • Creating links between universes.
  • Unit 10: Securing Universes & Managing Universes.
Day11: Setting access restrictions on a Universe.
  • Documenting Universes.
  • Deploying Universes.
  • Maintaining Universe.
Day 17: Universe on SAP BW DATA ---- 1 Day
  • Central Management Console
Day 18 :
  • Introduction to CMC
  • Exploring different features in CMC
  • How to Create and Manage Users and Groups
  • Creating Access Levels
Day 19:
  • Assigning Rights to reports, folders, universes, etc.
  • Starting, Stopping, Enabling and Disabling Servers
Day 20:
  • Scheduling the reports
Day 21 to Day 27:
  • InfoView –
  • How to Launch InfoView
  • Setting InfoView Preferences
  • Organizing Folders and Categories
  • Web Intelligence Reporting –
  • Introduction to webI Reporting
  • Exploring Folders, Public Folders, Inbox, Favorties, Copy, Paste, Delete etc.
  • Creating a Simple webI Report
  • Exploring Properties and Tool bars
  • Formatting Options
  • Saving a report and its Options
  • Export Options
  • Viewing a report
  • Modifying a report
  • Query Properties
  • Restricting the data
  • At Query Level
  • Using Pre-defined filters
  • Applying query level filters (Simple and Complex)
  • At Report Level
  • Applying Sorts
  • Applying Sections and Breaks
  • Applying Alerters
  • Applying Ranking
  • Combined Queries
  • Union, Intersect and Minus
  • Applying Sub-queries at query level
  • Represent data in different Tabular formats
  • Horizontal
  • Vertical
  • Cross-Tab
  • Graphical Representation of Data
  • Using different Charts and Graphss
  • Converting Tabular data to Graphs
  • Creating Reports with Multiple Data Providers
  • Merging data from Multiple Data Providers
  • Multi Tabbed Reports
  • Creating Formulas and Variables
  • Using Functions
  • String Functions
  • Date Functions
  • Number Functions
  • Tracking Data
  • Scheduling Reports
Day 28 to Day 33:
  • Crystal Repots –
  • Introduction to Crystal Reports
  • Blank Reports and Templates
  • Planning a Report
  • Creating a Simple Crystal Report
  • Formatting Reports
  • Creating Formulas
  • Organizing Data on report
  • Applying Conditional Reporting
  • Building Reports with Parameters
  • Creating Cross-Tab Reports
  • Managing Reports
  • Creating Sub-Reports
Day 34 to Day 39:
  • Xcelsius –(Dash Board Designer) 5 Days( Day 34 to Day 39)
  • Creating a Model
  • Creating a Connected Model
  • Using Live Office in Xcelsius
  • Using Crystal Reports in Xcelsius
  • Creating a Dashboard using Universe
  • Creating Dashboards with webI Report Data
  • Exploring different
  • Query As Web Services –
  • Using Query as Web Service
  • Configuring QAAWS
  • Creating a Web Service Report using Universe
  • Live Office –
  • Introduction to Live Office
  • Inserting Report parts from a webI document
  • Using Universe in Live Office
Day 40 to Day 41:
  • Migration & Import Wizard – 2 Days (Day 40 to Day 41)
  • What is Migration?
  • Introduction to Import Wizard
  • Creating Biar File
  • Taking Backup
  • Restoring the Backup
  • Server to Server Migration
  • Universe Migration along with Access Restriction
  • Writing Script for taking backup and restoring
  • Real-Time Release procedure
Day 42 to Day 47:
  • IDT (Information Design Tool) : 5 Days (Day 42 to Day 47)
Day 48 to Day 50:
  • Real-Time Scenarios – 3 days (Day 48 to Day 50)
  • Real-Time examples with best practices for
  • WebI Reporting
  • Universe Designer
  • Xcelsius
  • Biar Backups
  • Project
  • About Reporting requirements
  • About Universe requirements
  • Sample Reports and Dashboards

SAP BOBJ Online Training Australia

SAP BOBJ Online Training Australia Course Content

Introduction – SAP Business objects

Basics: (4 Days)
  • Data Base Concepts
  • Data Ware Housing Concepts
  • SQL Query Writing
  • BO R4.0 – (1 Day)
  • What’s new in BO R4.0
  • BI R4.0 Architecture
  • Universe Design (11 Days) Universe on General System Data (Non Sap)
Day 01: Understanding Business Objects Universes.
  • Unit 1: Understanding Business Objects Universes
  • Using the Universe Development Cycle.
Day 02: Populating the Universe Structure.
  • Unit 2: Building the Universe Structure
  • Defining Joins in a Universe.
Day 03: Objects and Classes.
  • Unit 3: Creating Objects
  • Creating classes and objects.
Day 04: Crating a list of Values.
  • Unit 4: Using List Of Values
  • Working with LOVs in a designer.
  • Creating a cascading LOV
Day5: Understanding the loops.
  • Unit 5: Resolving Loops in a Universe
  • Resolving the loops using Aliases.
Day6: Resolving the loops using shortcut joins.
  • Resolving the loops using contexts.
  • Unit 6: Resolving SQL Traps
Day7: Understanding SQL traps and universes.
  • Resolving chasm traps.
  • Resolving fan traps.
  • Unit 7: Using Functions with Objects & Using Hierarchies
Day8: Using @Functions.
  • Understanding the Hierarchies.
  • Unit 8: Aggregate Awareness
Day 9: Understanding aggregate awareness and Universes.
  • Applying aggregate awareness to Objects.
  • Unit 9: Derived Tables and Indexes & Linking Universes
Day10: Using derived tables
  • Applying index awareness
  • Understanding linked universes.
  • Creating links between universes.
  • Unit 10: Securing Universes & Managing Universes.
Day11: Setting access restrictions on a Universe.
  • Documenting Universes.
  • Deploying Universes.
  • Maintaining Universe.
Day 17: Universe on SAP BW DATA ---- 1 Day
  • Central Management Console
Day 18 :
  • Introduction to CMC
  • Exploring different features in CMC
  • How to Create and Manage Users and Groups
  • Creating Access Levels
Day 19:
  • Assigning Rights to reports, folders, universes, etc.
  • Starting, Stopping, Enabling and Disabling Servers
Day 20:
  • Scheduling the reports
Day 21 to Day 27:
  • InfoView –
  • How to Launch InfoView
  • Setting InfoView Preferences
  • Organizing Folders and Categories
  • Web Intelligence Reporting –
  • Introduction to webI Reporting
  • Exploring Folders, Public Folders, Inbox, Favorties, Copy, Paste, Delete etc.
  • Creating a Simple webI Report
  • Exploring Properties and Tool bars
  • Formatting Options
  • Saving a report and its Options
  • Export Options
  • Viewing a report
  • Modifying a report
  • Query Properties
  • Restricting the data
  • At Query Level
  • Using Pre-defined filters
  • Applying query level filters (Simple and Complex)
  • At Report Level
  • Applying Sorts
  • Applying Sections and Breaks
  • Applying Alerters
  • Applying Ranking
  • Combined Queries
  • Union, Intersect and Minus
  • Applying Sub-queries at query level
  • Represent data in different Tabular formats
  • Horizontal
  • Vertical
  • Cross-Tab
  • Graphical Representation of Data
  • Using different Charts and Graphss
  • Converting Tabular data to Graphs
  • Creating Reports with Multiple Data Providers
  • Merging data from Multiple Data Providers
  • Multi Tabbed Reports
  • Creating Formulas and Variables
  • Using Functions
  • String Functions
  • Date Functions
  • Number Functions
  • Tracking Data
  • Scheduling Reports
Day 28 to Day 33:
  • Crystal Repots –
  • Introduction to Crystal Reports
  • Blank Reports and Templates
  • Planning a Report
  • Creating a Simple Crystal Report
  • Formatting Reports
  • Creating Formulas
  • Organizing Data on report
  • Applying Conditional Reporting
  • Building Reports with Parameters
  • Creating Cross-Tab Reports
  • Managing Reports
  • Creating Sub-Reports
Day 34 to Day 39:
  • Xcelsius –(Dash Board Designer) 5 Days( Day 34 to Day 39)
  • Creating a Model
  • Creating a Connected Model
  • Using Live Office in Xcelsius
  • Using Crystal Reports in Xcelsius
  • Creating a Dashboard using Universe
  • Creating Dashboards with webI Report Data
  • Exploring different
  • Query As Web Services –
  • Using Query as Web Service
  • Configuring QAAWS
  • Creating a Web Service Report using Universe
  • Live Office –
  • Introduction to Live Office
  • Inserting Report parts from a webI document
  • Using Universe in Live Office
Day 40 to Day 41:
  • Migration & Import Wizard – 2 Days (Day 40 to Day 41)
  • What is Migration?
  • Introduction to Import Wizard
  • Creating Biar File
  • Taking Backup
  • Restoring the Backup
  • Server to Server Migration
  • Universe Migration along with Access Restriction
  • Writing Script for taking backup and restoring
  • Real-Time Release procedure
Day 42 to Day 47:
  • IDT (Information Design Tool) : 5 Days (Day 42 to Day 47)
Day 48 to Day 50:
  • Real-Time Scenarios – 3 days (Day 48 to Day 50)
  • Real-Time examples with best practices for
  • WebI Reporting
  • Universe Designer
  • Xcelsius
  • Biar Backups
  • Project
  • About Reporting requirements
  • About Universe requirements
  • Sample Reports and Dashboards

SAP BOBJ Online Training UK

SAP BOBJ Online Training UK Course Content

Introduction – SAP Business objects

Basics: (4 Days)
  • Data Base Concepts
  • Data Ware Housing Concepts
  • SQL Query Writing
  • BO R4.0 – (1 Day)
  • What’s new in BO R4.0
  • BI R4.0 Architecture
  • Universe Design (11 Days) Universe on General System Data (Non Sap)
Day 01: Understanding Business Objects Universes.
  • Unit 1: Understanding Business Objects Universes
  • Using the Universe Development Cycle.
Day 02: Populating the Universe Structure.
  • Unit 2: Building the Universe Structure
  • Defining Joins in a Universe.
Day 03: Objects and Classes.
  • Unit 3: Creating Objects
  • Creating classes and objects.
Day 04: Crating a list of Values.
  • Unit 4: Using List Of Values
  • Working with LOVs in a designer.
  • Creating a cascading LOV
Day5: Understanding the loops.
  • Unit 5: Resolving Loops in a Universe
  • Resolving the loops using Aliases.
Day6: Resolving the loops using shortcut joins.
  • Resolving the loops using contexts.
  • Unit 6: Resolving SQL Traps
Day7: Understanding SQL traps and universes.
  • Resolving chasm traps.
  • Resolving fan traps.
  • Unit 7: Using Functions with Objects & Using Hierarchies
Day8: Using @Functions.
  • Understanding the Hierarchies.
  • Unit 8: Aggregate Awareness
Day 9: Understanding aggregate awareness and Universes.
  • Applying aggregate awareness to Objects.
  • Unit 9: Derived Tables and Indexes & Linking Universes
Day10: Using derived tables
  • Applying index awareness
  • Understanding linked universes.
  • Creating links between universes.
  • Unit 10: Securing Universes & Managing Universes.
Day11: Setting access restrictions on a Universe.
  • Documenting Universes.
  • Deploying Universes.
  • Maintaining Universe.
Day 17: Universe on SAP BW DATA ---- 1 Day
  • Central Management Console
Day 18 :
  • Introduction to CMC
  • Exploring different features in CMC
  • How to Create and Manage Users and Groups
  • Creating Access Levels
Day 19:
  • Assigning Rights to reports, folders, universes, etc.
  • Starting, Stopping, Enabling and Disabling Servers
Day 20:
  • Scheduling the reports
Day 21 to Day 27:
  • InfoView –
  • How to Launch InfoView
  • Setting InfoView Preferences
  • Organizing Folders and Categories
  • Web Intelligence Reporting –
  • Introduction to webI Reporting
  • Exploring Folders, Public Folders, Inbox, Favorties, Copy, Paste, Delete etc.
  • Creating a Simple webI Report
  • Exploring Properties and Tool bars
  • Formatting Options
  • Saving a report and its Options
  • Export Options
  • Viewing a report
  • Modifying a report
  • Query Properties
  • Restricting the data
  • At Query Level
  • Using Pre-defined filters
  • Applying query level filters (Simple and Complex)
  • At Report Level
  • Applying Sorts
  • Applying Sections and Breaks
  • Applying Alerters
  • Applying Ranking
  • Combined Queries
  • Union, Intersect and Minus
  • Applying Sub-queries at query level
  • Represent data in different Tabular formats
  • Horizontal
  • Vertical
  • Cross-Tab
  • Graphical Representation of Data
  • Using different Charts and Graphss
  • Converting Tabular data to Graphs
  • Creating Reports with Multiple Data Providers
  • Merging data from Multiple Data Providers
  • Multi Tabbed Reports
  • Creating Formulas and Variables
  • Using Functions
  • String Functions
  • Date Functions
  • Number Functions
  • Tracking Data
  • Scheduling Reports
Day 28 to Day 33:
  • Crystal Repots –
  • Introduction to Crystal Reports
  • Blank Reports and Templates
  • Planning a Report
  • Creating a Simple Crystal Report
  • Formatting Reports
  • Creating Formulas
  • Organizing Data on report
  • Applying Conditional Reporting
  • Building Reports with Parameters
  • Creating Cross-Tab Reports
  • Managing Reports
  • Creating Sub-Reports
Day 34 to Day 39:
  • Xcelsius –(Dash Board Designer) 5 Days( Day 34 to Day 39)
  • Creating a Model
  • Creating a Connected Model
  • Using Live Office in Xcelsius
  • Using Crystal Reports in Xcelsius
  • Creating a Dashboard using Universe
  • Creating Dashboards with webI Report Data
  • Exploring different
  • Query As Web Services –
  • Using Query as Web Service
  • Configuring QAAWS
  • Creating a Web Service Report using Universe
  • Live Office –
  • Introduction to Live Office
  • Inserting Report parts from a webI document
  • Using Universe in Live Office
Day 40 to Day 41:
  • Migration & Import Wizard – 2 Days (Day 40 to Day 41)
  • What is Migration?
  • Introduction to Import Wizard
  • Creating Biar File
  • Taking Backup
  • Restoring the Backup
  • Server to Server Migration
  • Universe Migration along with Access Restriction
  • Writing Script for taking backup and restoring
  • Real-Time Release procedure
Day 42 to Day 47:
  • IDT (Information Design Tool) : 5 Days (Day 42 to Day 47)
Day 48 to Day 50:
  • Real-Time Scenarios – 3 days (Day 48 to Day 50)
  • Real-Time examples with best practices for
  • WebI Reporting
  • Universe Designer
  • Xcelsius
  • Biar Backups
  • Project
  • About Reporting requirements
  • About Universe requirements
  • Sample Reports and Dashboards

SAP BOBJ Online Training USA

SAP BOBJ Online Training USA Course Content

Introduction – SAP Business objects

Basics: (4 Days)
  • Data Base Concepts
  • Data Ware Housing Concepts
  • SQL Query Writing
  • BO R4.0 – (1 Day)
  • What’s new in BO R4.0
  • BI R4.0 Architecture
  • Universe Design (11 Days) Universe on General System Data (Non Sap)
Day 01: Understanding Business Objects Universes.
  • Unit 1: Understanding Business Objects Universes
  • Using the Universe Development Cycle.
Day 02: Populating the Universe Structure.
  • Unit 2: Building the Universe Structure
  • Defining Joins in a Universe.
Day 03: Objects and Classes.
  • Unit 3: Creating Objects
  • Creating classes and objects.
Day 04: Crating a list of Values.
  • Unit 4: Using List Of Values
  • Working with LOVs in a designer.
  • Creating a cascading LOV
Day5: Understanding the loops.
  • Unit 5: Resolving Loops in a Universe
  • Resolving the loops using Aliases.
Day6: Resolving the loops using shortcut joins.
  • Resolving the loops using contexts.
  • Unit 6: Resolving SQL Traps
Day7: Understanding SQL traps and universes.
  • Resolving chasm traps.
  • Resolving fan traps.
  • Unit 7: Using Functions with Objects & Using Hierarchies
Day8: Using @Functions.
  • Understanding the Hierarchies.
  • Unit 8: Aggregate Awareness
Day 9: Understanding aggregate awareness and Universes.
  • Applying aggregate awareness to Objects.
  • Unit 9: Derived Tables and Indexes & Linking Universes
Day10: Using derived tables
  • Applying index awareness
  • Understanding linked universes.
  • Creating links between universes.
  • Unit 10: Securing Universes & Managing Universes.
Day11: Setting access restrictions on a Universe.
  • Documenting Universes.
  • Deploying Universes.
  • Maintaining Universe.
Day 17: Universe on SAP BW DATA ---- 1 Day
  • Central Management Console
Day 18 :
  • Introduction to CMC
  • Exploring different features in CMC
  • How to Create and Manage Users and Groups
  • Creating Access Levels
Day 19:
  • Assigning Rights to reports, folders, universes, etc.
  • Starting, Stopping, Enabling and Disabling Servers
Day 20:
  • Scheduling the reports
Day 21 to Day 27:
  • InfoView –
  • How to Launch InfoView
  • Setting InfoView Preferences
  • Organizing Folders and Categories
  • Web Intelligence Reporting –
  • Introduction to webI Reporting
  • Exploring Folders, Public Folders, Inbox, Favorties, Copy, Paste, Delete etc.
  • Creating a Simple webI Report
  • Exploring Properties and Tool bars
  • Formatting Options
  • Saving a report and its Options
  • Export Options
  • Viewing a report
  • Modifying a report
  • Query Properties
  • Restricting the data
  • At Query Level
  • Using Pre-defined filters
  • Applying query level filters (Simple and Complex)
  • At Report Level
  • Applying Sorts
  • Applying Sections and Breaks
  • Applying Alerters
  • Applying Ranking
  • Combined Queries
  • Union, Intersect and Minus
  • Applying Sub-queries at query level
  • Represent data in different Tabular formats
  • Horizontal
  • Vertical
  • Cross-Tab
  • Graphical Representation of Data
  • Using different Charts and Graphss
  • Converting Tabular data to Graphs
  • Creating Reports with Multiple Data Providers
  • Merging data from Multiple Data Providers
  • Multi Tabbed Reports
  • Creating Formulas and Variables
  • Using Functions
  • String Functions
  • Date Functions
  • Number Functions
  • Tracking Data
  • Scheduling Reports
Day 28 to Day 33:
  • Crystal Repots –
  • Introduction to Crystal Reports
  • Blank Reports and Templates
  • Planning a Report
  • Creating a Simple Crystal Report
  • Formatting Reports
  • Creating Formulas
  • Organizing Data on report
  • Applying Conditional Reporting
  • Building Reports with Parameters
  • Creating Cross-Tab Reports
  • Managing Reports
  • Creating Sub-Reports
Day 34 to Day 39:
  • Xcelsius –(Dash Board Designer) 5 Days( Day 34 to Day 39)
  • Creating a Model
  • Creating a Connected Model
  • Using Live Office in Xcelsius
  • Using Crystal Reports in Xcelsius
  • Creating a Dashboard using Universe
  • Creating Dashboards with webI Report Data
  • Exploring different
  • Query As Web Services –
  • Using Query as Web Service
  • Configuring QAAWS
  • Creating a Web Service Report using Universe
  • Live Office –
  • Introduction to Live Office
  • Inserting Report parts from a webI document
  • Using Universe in Live Office
Day 40 to Day 41:
  • Migration & Import Wizard – 2 Days (Day 40 to Day 41)
  • What is Migration?
  • Introduction to Import Wizard
  • Creating Biar File
  • Taking Backup
  • Restoring the Backup
  • Server to Server Migration
  • Universe Migration along with Access Restriction
  • Writing Script for taking backup and restoring
  • Real-Time Release procedure
Day 42 to Day 47:
  • IDT (Information Design Tool) : 5 Days (Day 42 to Day 47)
Day 48 to Day 50:
  • Real-Time Scenarios – 3 days (Day 48 to Day 50)
  • Real-Time examples with best practices for
  • WebI Reporting
  • Universe Designer
  • Xcelsius
  • Biar Backups
  • Project
  • About Reporting requirements
  • About Universe requirements
  • Sample Reports and Dashboards
Top ↑