SAP Business Objects

What is ERP , SAP company History, SAP ERP, SAP Products Portfolio and SAP Certification overview.

• How to start the SAP program
• How to log on and off
• How to identify screen elements
• How to Use Help Functions
• How to recognize screen elements.

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

• Relational Database Management System
• SQL Language introduction
• Use of basic SQL statement, clauses, operator, joins etc

• Introducing Web Intelligence
• BI launch pad: What’s new in 4.1
• Customizing BI launch pad
• Creating Web Intelligence Documents with Queries
• Restricting Data Returned by a Query
• Report Design in the Java Report Panel
• Enhancing the Presentation of Reports
• Formatting Reports
• Creating Formulas and Variables
• Synchronizing Data
• Analyzing Data
• Drilling
• Filtering data
• Alerts
• Input Control
• Scheduling (email)
• Data Refresh introduction
• Sharing Web Intelligence Documents

• 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

• Create a connection shortcut
• View and filter data source values in the connection editor
• Create a connection to an OLAP data source
• Create a BICS connection to SAP BW for client tools
• Create a relational connection to SQL Server using OLEDB
providers

• 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
• Apply a wildcard to filter table values in a data foundation
• Apply a wildcard to 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, theta join, outer join, 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

• Create business layer folders and 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, attribute , measure
• Hide folders and objects in a business layer
• Organize folders and subfolders in a business layer
• View table and object dependencies
• Create a custom navigation path
• Create a dimensional business layer from an OLAP data source
• Copy and paste folders and objects in a business layer

• 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
• Visualizing Data in a Universe
• Building a Multi-Source Universe
• Working with Parameters and Lists of Values
• Resolving Loops in a Universe
• Managing and Deploying Universes

• What’s new in SAP Business Objects Dashboards 4.1
• Creating a Visualization
• Producing interactive visualizations
• Getting around in Xcelsius
• Working with your Excel workbook
• Visualizing data with charts
• Using Xcelsius Components
• Formatting a Visualization
• Applying formatting options
• Using themes and templates to apply formatting
• Adding Interactivity to a Visualization
• Using selectors
• Adding dynamic visibility
• Troubleshooting interactivity
• Creating a Connected Visualization
• Using live data sources
• Connecting to XML Data
• Connecting to BO Universes using Query as a Web Service
• Using Live Office data
• Working with Business Requirements

• Setting up groups and users
• Organizing and changing Folders & Categories
• Time Out sessions
• Authentication
• Managing Servers
• Connections
• Controlling Universes
• Scheduling through CMC
• Publication
• User Security
• Database Configuration
• Modify Settings for Applications
• Access Levels
• Security