Contact us on +91 83745 39043 (44) 07448456791 or info@globaltnc.com

SAP BOBJ Online Training

SAP BOBJ Online Training

Course Duration : 35 Hrs

SAP BOBJ Course Content
Data warehousing/Dimensional modeling Practical Concepts

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

Database Concepts needed for Data warehousing

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

BOXIR3 Architecture

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

Universe Design

  • Understanding Business Objects Universes
  • Creating the Course Universe
  • Building the Universe Structure
  • Creating Dimension Objects
  • Creating Measure Objects
  • Resolving Loops in a Universe
  • Resolving SQL Traps
  • Using List of Values
  • Applying Restrictions on Objects
  • Using @Functions with Objects
  • Using Hierarchies
  • Deriving Tables & Indexes
  • Working with Aggregate Awareness
  • Designing Advanced Objects
  • Creating Predefined Condition
  • LOVs & Joins
  • Securing Universes
  • Implementing Universe Life Cycle Mgmt
  • Maintaining & Optimizing Universes
  • Creating Universe from Other Data sources

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

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

Xcelsius(SAP Dashboard Design)

  • Creating a Model
  • Adding Interactivity to a Model
  • Creating a Connected Model
  • Connect to Crystal Reports data and create Dashboard
  • Connect to Web intelligence report data and
  • Create Dashboard
  • Connect to Business Objects Universes
  • Using Query as a web service and create Dashboard
  • Use Live Office data and create Dashboard
  • Use other connectivity components and create Dashboard

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

Widgets

  • Installing BI Widgets
  • Using BI Widgets to Access BI Content
  • Working with widgets
  • BI Widgets Content Authoring Guidelines
  • Auto refresh of Widgets

Desktop Intelligence

  • Introduction to desktop intelligence
  • Scope of analysis
  • ZABO
  • Report creation
  • Saving the reports in local repository
  • Publishing the report
  • Report conversion (desktop) to (Webi)

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 InfoView
  • Working with queries in Web Intelligence Rich Client
  • Working with reports

Query as Web service

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

Voyager

  • Getting Started with Business Objects Voyager
  • Using Queries to Analyze Cube Data
  • Using Charts to Visualize Data
  • Selecting Members to Display in Crosstabs and Charts
  • Sorting, Filtering, and Ranking Data
  • Highlighting Exceptions in Data
  • Saving and Sharing Voyager Workspaces

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

OLAP Universe

  • Creation of OLAP Universe by connecting to an Info cube
  • Updating the OLAP Universe (Cube)
  • Creating the Custom Hierarchies in OLAP Universes.
  • Accessing multiple info cubes to create an OLAP Universe

Import Wizard\Publishing 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
  • View

Performance Management

  • Creation of Metric Universe
  • Creation of Metrics & Analytics
  • Creation of Dashboard using Metric
  • Creating Performance dashboards using set analysis

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

BO-SAP Integration Series

  • Understanding BO-SAP Integration kit
  • Configuring single sign on authentication
  • Creating SAP Authentication in BO
  • Importing the roles of SAP into BO
  • Entitlement settings of SAP & BO System

SAP Webi/Dashboard Reporting:

  • Creation of Web intelligence reports using Info cube & BW Query

Comparison of all BO Versions (5.x/6.5/XIR1/XIR2/XIR3)

  • Architecture changes
  • Report creation charges
  • Universe level changes
  • Security level changes
  • Addition of new features

Performance Tuning of Database w.r.t BO

  • BO Query tuning
  • BO Execution plan/Tracing
  • Combined Query
  • Views/Derived tables

Performance Tuning of BO

  • Universe Tuning
  • Webi report Tuning
  • Database Tuning
  • Deployment methods
  • Crystal reports tuning
  • BO Query optimization & Customizatio

Polestar/Business Explorer

  • Creating Polestar Reports
  • Configuring Pole star with BO Syste

Request for Training

OR