SAP BO course Beginner level by TARGET TECH SOLUTION

Day 1: Demo and Xcelsius Core and Connectivity
Day 2: Hands on Xcelsius components, Data Insertion, dynamic visibility
Day 3: Xcelsius:
Using live data sources
Connecting to XML Data
Connecting to data using an existing Web Service
Connecting to BusinessObjects Universes using Query as a Web Service
Using Live Office data
Working with Business Requirements
Crystal Reports: Crystal Reports Basic: Fundamentals of Report Design
Planning a Report
Define database concepts
Plan and develop a report prototype
Creating a Report
reate a report
Add tables
Describe the design environment
Insert objects on a report
Preview a report
Save a report
Position and size objects
Format objects
Selecting Records
Define the Select Expert
Determine the criteria for record selection
Understanding saved and refreshed data
Apply record selection
Apply additional record selection criteria
Modify record selection
Apply time-based record selection
Organizing Data on a Report
Sort records
Group records
Summarize data
Formatting a Report
Add graphical elements
Combine text objects with database fields
Apply specialized formatting
Insert fields with pre-built functions
Applying Section Formatting
Format sections
Create a summary report
Creating Basic Formulas
Define a formula and its purpose
Create formulas
Apply Boolean formulas
Apply If-Then-Else formulas
Apply date calculations
Apply number calculations
Apply string manipulation
Applying Conditional Reporting
Determine trends in data
Format data conditionally
Representing Data Visually
Create a chart
Distributing a Report
Export a report
Save a report to BusinessObjects Enterprise
Day 4: Crystal Reports - Business Reporting Solutions
Using the Repository
Use the repository
Create a report from a repository data source
Creating Formulas
Use functions and operators
Define control structures available in Crystal Reports Syntax
Managing Reports
Use the Workbench
Publish reports to BusinessObjects Enterprise
Using Variables and Arrays
Use variables
Use arrays
Using Report Templates
Apply report templates
Build a template without a data source
Remove a template
Building Parameterized Reports
Define and create parameters
Build a report with multiple parameters
Use edit masks and descriptions
Create a date range parameter
Group using parameters
Summarizing Data with Crosstabs
Build a basic crosstab
Format a crosstab
Using Report Sections
Use sections
Use group related functions to format sections
Use section underlay
Use multiple-column reporting
Building Specialized Reports
Use the Running Total Expert
Create a form letter
Add a hyperlink to a report
Use Dynamic Graphic Locations
Build a report with alerts
Build a top N report
Integrate an Xcelsius Flash SWF into a Crystal report
Crystal Reports: Report processing strategies:
Report Processing
Use multi-pass reporting
Use evaluation time functions
Use a dynamic array
Using Subreports
Define subreports
Create an unlinked subreport
Create a linked subreport
Create an on-demand subreport
Use shared variables with subreports
Link unlinkable data with subreports
Describe alternate solutions to using subreports
Creating Complex Formulas
Use Print State functions
Use loop control structures
Use loop control structures with arrays
Using Custom Functions
Describe a custom function
Use custom functions
Using XML and Web Services Data
Use XML and web services data
Use a transform in XML exporting
Day 5:
Business Objects: Installation and Administration
Preparing, Installing, and Configuring Business Objects Enterprise
Explain how to prepare, install, and configure Business Objects Enterprise
Test Business Objects Enterprise once it is installed
Verify what updates were applied to the Business Objects Enterprise
Installation
Business Objects Enterprise Architecture
Describe the Business Objects Enterprise architecture
Describe the Business Objects Enterprise components
Explain the information process flows in Business Objects Enterprise
Performing Common Server Management Tasks
Describe the Central Configuration Manager (CCM) to manage servers
Describe the Server Intelligence Agent (SIA)
Describe the Central Management Console (CMC) to manage servers
Managing the Web Application Services
Understand the web application services
Configure the Java Web Application Server
Describe the role of Web Application Container Server
Deploy Business Objects Enterprise web applications using wdeploy
Managing the Central Management Server and the System Database
Use the Central Management Server
Migrate and backup the CMS system data
Manage auditing
Describe authentication and single sign-on
Map third-party accounts to Business Objects Enterprise
Managing the File Repository Servers
Use the File Repository Servers
Configure the File Repository Servers
Use the Repository Diagnostic Tool
Managing the Web Intelligence Servers
Describe the role of Web Intelligence servers
Configure the Web Intelligence servers
Describe how documents viewing requests are processed by the Web Intelligence servers
Describe how scheduling requests are processed by the Web Intelligence servers
Managing the Crystal Reports Server
Use the Crystal Reports Server
Configure the Crystal Reports Job Server
Configure the List of Values (LOV) Job Server and LOV objects
Configure the Crystal Reports Cache Server
Configure the Crystal Reports Processing Server
Configure the Report Application Server
Set and run a schedule for a report
Managing the Desktop Intelligence Servers
Configure the Desktop Intelligence Job Server
Configure the Desktop Intelligence Processing Server
Configure the Desktop Intelligence Cache Server
Configure the Connection Server
Managing the Adaptive Servers
Describe the role of the Adaptive Job Server
Describe the role of the Adaptive Processing Server
Configure different types of Adaptive Servers
Managing the Event Servers
Understand events in the Business Objects Enterprise
Configure the Event Server
Managing the Program Job Servers
Use the Program Job Server
Configure the Program Job Server
Describe how scheduled programs are processed
Managing the Destination Job Servers
Use the Destination Job Server
Configure the Destination Job Server
Set a schedule to send an object or instance to a destination
Troubleshooting Business Objects Enterprise
o Use best practices when troubleshooting
Installing and Configuring SAP Integration kit
Day 6:
Business Objects Enterprise: Administration
What is Business Objects Enterprise?
o Describe Business Objects Enterprise
o Use InfoView and the Central Management Console to view content
o Configure the Central Management Console
o Describe the Business Objects Enterprise Architecture
Managing Business Objects Enterprise Content
o Add objects to the Repository
o Manipulate objects in Business Objects Enterprise
Securing Business Objects Enterprise Content
o Create users, groups, folders and categories
o Understand the Business Objects Enterprise security model
o Describe guidelines for planning security
Application Security
o Secure Business Objects Enterprise applications
Scheduling Content
o Schedule objects
o Schedule with business calendars
o Manage instances
Publishing and Publications
o Publish personalized reports and documents to multiple recipients
o Describe the process of publishing personalized reports to dynamic
recipients
o Manage profiles
Day 7:
Business Objects Universe Design:
Understanding Business Objects Universes
o Define Business Objects universe concepts
o Use the universe development cycle
Creating the Course Universe
o Describe the course database and universe
o Create the course universes
Building the Universe Structure
o Populate the universe structure
o Define joins in a universe
Creating Dimension Objects
o Describe classes and objects
o Create classes and objects
Creating Measure Objects
o Define measure object concepts
o Create measure objects
o Create delegated measure objects
Day 8:
Business Objects Universe Design:
Resolving Loops in a Universe
o Understand loops
o Resolve loops using aliases
o Resolve loops using contexts
Resolving SQL Traps
o Understand SQL traps and universes
o Resolve fan traps
o Resolve chasm traps
Applying Restrictions on Objects
o Restrict the data returned by objects
Using @functions with Objects
o Use @functions
Using Hierarchies
o Understand hierarchies and universes
o Work with hierarchies
Using Lists of Values
o Create a list of values
o Work with LOVs in Universe Designer
o Create a cascading LOV
Creating Derived Tables and Indexes
o Use derived tables
o Apply index awareness
Linking Universes
o Understand linked universes
o Create links between universes
Applying Universe Access Restrictions
o Set access restrictions on a universe
Managing Universes
o Document universes
o Deploy universes
o Maintain universes
o Deploy universes in multiple languages
Day 9:
Business Objects Web Intelligence:
Introducing Web Intelligence
o Describing Web Intelligence concepts
o Explaining Web Intelligence core functionality
o Describing Web Intelligence and Business Objects Enterprise
Creating Web Intelligence Documents with Queries
o Querying with Web Intelligence
o Creating a new document
o Modifying a document s query
o Working with query properties
Restricting Data Returned by a Query
o Restricting data with query filters
o Modifying a query with a predefined query filter
o Applying a single-value query filter
o Using wildcards in query filters
o Using prompts to restrict data
o Using complex filters
Designing Web Intelligence Reports
o Working with Web Intelligence documents
o Displaying data in tables and charts
o Creating tables
o Working with tables
o Presenting data in free-standing cells
o Presenting data in charts
Enhancing the Presentation of Data in Reports
o Using breaks, calculations
o Using sorts
o Formatting breaks and cross tabs
o Using report filters
o Ranking data to see top or bottom values
o Tracking data changes
o Using alerter to highlight information
o Organizing a report into sections
o Copying data to other applications
Formatting Reports
o Formatting documents
o Formatting charts
Calculating Data with Formulas and Variables
o Explaining formulas and variables
o Using formulas and variables
Using Multiple Data Sources
o Synchronizing data from multiple data sources
o Creating multiple queries in a document
o Synchronizing data with merged dimensions
o Using a personal data provider
Analyzing Data
o Analyzing the data cube
o Drilling in Web Intelligence documents
o Setting Web Intelligence drill options
Managing and Sharing Web Intelligence Documents
o Exporting documents to the CMS
o Logging into Info View
o Managing documents in Info View
o Viewing a Web Intelligence document in Info View
o Sharing Web Intelligence documents
o Setting Info View preferences
o Describing Web Intelligence report panels
o Logging off from Info View
Advanced Webi Reporting:
Working with Advanced Query Techniques
Working with Calculation Contexts
Creating Formulas with Character and Date
String Functions
Using If Logic
Working with Additional Reporting Techniques
Creating Hyperlinks
Day 10: Voyager and Business Objects Explorer
Day 11 & 12: Business Objects Integration kit for SAP