SAP BO Online Training
SAP Business Objects is a suite of applications that allows the users to view, sort and analyze business intelligence data. The applications are Crystal Reports, Dashboards, Web Intelligence and Explorer.
Session 1: Introduction to Business Objects and its product suite
Designer tool – Universe Designer
Reporting tools – Desktop Intelligence, Web Intelligence, Crystal Reports
Administration tools- CMC, CMS
Different servers with its usage/Impact
Detailed Caching Mechanism.
Session 2: Universe Designer
What is Semantic Layer/Business Layer?
What is a Universe?
Understand the role of a Designer
Know more about the way Business Objects generates SQL
Universe Connections - Types of Connection
Creating a Universe
What are Universe Objects?
Organize the universe into classes and sub-classes
(i)Define what a loop is
(ii)Detect and recognize loops within a universe structure
(iii)Resolve loops in a universe
(iv)Resolve loops using aliases – when and how to do it
(v)Recognize candidates for aliases from the “table tree” concept
(vi)Resolve loops using contexts – when and how to do it
(vii)Context? In which context they are used? Advantages and Disadvantages of the same?
(viii)Understand when and why contexts need to be updated
(ix)Recognize situations in which manual resolution of loops is obligatory
List of values
(i)Associate or remove a list of values for an object
(ii)Control how lists of values are refreshed
(iii)Export a list with the universe
(iv)Modify a list of values using a condition
(v)Base a list of values on a personal data file
Creating Prompts in Universe
Usage of @Functions in Designer, main focus on @aggregate_aware.
Row level security at Designer level with examples?
Linking universes? Advantages and disadvantages. Different approaches.
Maintaining, managing Universes
Testing universe with reporting tool
Session 3: Desktop Intelligence
Introduction to Business Objects Analytical Reporting
Types of Data Providers
Inserting a Table, Chart, Cross Tab reports
Creating different Chart reports
Changing Chart style
Personal Data File as Data Provider Free hand SQL as Data Provider
Exporting documents to PDF, HTML etc.
Grouping of Data
Calculating and displaying Rank
Variables and functions
Creating Drill Down Reports
Publishing, Sending a Document to User(s)/Group(s)
Linking Data Providers
Creating and using Prompts
Session 4: Web Intelligence
About Infoview application
Getting started with Infoview
Creating and viewing WebIntelligence Documents on Web (Infoview)
Creating and viewing Full Client/Business Objects Documents on Web (Infoview)
Restricting data returned by a query
Create formulas and variables
Analyzing Data at a deeper level
Corporate documents, Personal documents, Inbox documents
Sending documents to user(s)/group(s)
Hands on practice session
Session 5: Infoview
Log on to and off from InfoView
Manage document categories
Set password options
Use online Help
Customize a personalized view of InfoView
Create dashboards for My InfoView
Managing documents in InfoView
Viewing a Web Intelligence document in InfoView
Setting InfoView Preferences
Creating an InfoView dashboard with My InfoView
Set viewing options
View and modify WebIntelligence documents in HTML Interactive format
View documents in different formats
Analyze Web Intelligence documents in Drill mode
Refresh and Print documents from InfoView
Using Discussion and Encyclopedia
Session 6: Business Objects Security – CMC
Business Objects Repository, Creation and Maintenance
Business Objects Repository Domains – (Security, Universe and Document domains)
Setting properties of users
Setting Privileges to users & groups
Session 7: Crystal Reports
About Crystal Report Architecture.
Differentiate between Business Objects Reporting and Crystal Reporting.
Working with simple table report, Chart report, Cross-tab Report
Creating Drill down reports
Session 8: Crystal Xcelsius
Basic Dashboard Design