SAP Business Objects Training

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 System

SAP BO training is intended for:

• IT & business intelligence professionals who want to hone their skills in SAP Business Objects or SAP BO
• Students & individuals who wants to make their career in Business Intelligence.

We guarantee learning at your convenience & pace.

• Instant Access:
  Get instant access to self-paced training after signup.
• Streaming video recording:
  Watch lessons any time at your schedule, free recording.
• Exercises:
  Practical exercises help you test what you are learning as you go.
• Free Demo:
  Sign up for free demo to check whether the course is right for you and interact with the faculty live.
• Experienced Trainers:
  We only hire the industry’s best trainers
• Live free interactive web sessions:
  Ask the Expert Shell Scripting trainers about the career prospects and clarify your questions any time after you complete the course.
• Structured Curriculum Schedule:
  Progress with your complete daily interactive lessons and assignments.
• Faculty Mentoring:
  Turn in daily and weekly homework for personalized feedback from faculty.
• Virtual Office Hours:
  Live interaction with the faculty and other students around the world.
• Hands on Live Projects:
  Work on live lab sessions to tackle real-world projects. Get 100% faculty guidance and ratings.

N/A