SAP BO & Crystal Reports Course Content

Universe Designer

Ø Understanding Business-Objects Universes.
Ø Understanding how universes allow users to query databases using their everyday business terms.
Ø Creating Universe Connections.
Ø The course database and universe.
Ø Creating the universe.
Ø Building and populating the Universe Structure.
Ø Defining joins in a universe.
Ø Creating Dimension Objects.
Ø Understanding classes and objects.
Ø Creating Measure Objects.
Ø Understanding measure objects.
Ø Using List of Values.
Ø Resolving Loops.
Ø Resolving loops using aliases.
Ø Resolving loops using contexts.
Ø Chasm traps and Fan traps.
Ø Restricting the data returned by objects.
Ø Using Functions with Objects.
Ø Using @ Functions.
Ø Using Hierarchies.
Ø Working with hierarchies.
Ø Aggregate Awareness.
Ø Linking Universes.
Ø Creating links between universes.
Ø Securing Universes.
Ø Managing Universes.
Desktop Intelligence (Basic) ^Top
Ø Introduction to Desktop Intelligence.
Ø Understanding core concepts of Desktop Intelligence.
Ø Understanding core functionality of Desktop Intelligence.
Ø Getting Started with Desktop Intelligence.
Ø Logging on to Desktop Intelligence.
Ø Modifying start up options.
Ø Accessing help.
Ø Opening documents Viewing reports Saving documents
Ø Creating Desktop Intelligence Documents with Queries.
Ø Getting new data with Desktop Intelligence.
Ø Creating a query Modifying the query Understanding Report Manager
Ø Projecting data
Ø Restricting Data Returned by a Query
Ø Applying query conditions
Ø Using condition objects
Ø Understanding relational operators in conditions
Ø Using logical operators for multiple conditions
Ø Designing Reports
Ø Displaying data in tables and charts
Ø Formatting Desktop Intelligence documents
Ø Enhancing Presentation of Reports
Ø Formatting Desktop Intelligence documents using the Slice and Dice Panel Applying functions
Ø Filtering data
Ø Applying calculations to data
Ø Applying breaks to data
Ø Ranking data
Ø Creating Variables and Alerters
Ø Creating variables and formulas Creating alerters
Ø Creating running calculations
Ø Synchronizing Data from Multiple Data Providers Concepts of combining data from multiple sources Building a document with blocks of data
Ø Grouping Data using Sections
Ø Concepts of grouping data using sections
Ø Creating templates
Ø Applying styles
Ø Analyzing in Drill Mode
Ø Analyzing the data cube
Ø Using the drill-down mode Taking a snapshot of the data
Ø Sharing reports with BusinessObjects users
Ø Creating reports for non-BusinessObjects users Retrieving reports from the repository Exporting data

Desktop Intelligence (Advanced) ^Top
Ø Alternative Query Techniques Defining Combined Query Types Using Combined Queries
Ø Using Sub-Queries
Ø Creating a Query on a Query
Ø Character and Date String Functions Understanding Character Strings
Ø Using the Replace Function
Ø Using the Right Function
Ø Using the SubString() Function
Ø Using the Pos() Function Concatenating Different Data Types
Ø Using Date Functions User-Defined Objects Creating User Objects
Ø Using a User Object in a Query
Ø Editing a User Object Deleting a User Object Storing a User Object Grouping Data
Ø Grouping Data Using "If... Then... Else..."
Ø Reporting from Other Data Sources
Web-Intelligence (INFOVIEW)
Ø Introducing Web Intelligence
Ø Accessing corporate information with Web Intelligence
Ø Understanding how universes allow you to query databases using everyday business terms.
Ø Getting Started with InfoView
Ø Managing documents in InfoView
Ø Viewing a Web Intelligence document in InfoView
Ø Customizing InfoView
Ø Setting InfoView Preferences
Ø Creating Web Intelligence Documents with Queries
Ø Getting new data with Web Intelligence
Ø Creating a new Web Intelligence document
Ø Modifying a document’s query
Ø Working with query properties
Ø Restricting Data Returned by a Query
Ø Modifying a query with a predefined query filter
Ø Applying a single-value query filter
Ø Using prompts to restrict data
Ø Using complex filters
Ø Displaying data in tables and charts
Ø Presenting data in free-standing cells
Ø Enhancing the Presentation of Reports
Ø Using breaks, calculations, sorts and report filters
Ø Ranking data to see top or bottom values
Ø Using alerters to highlight information
Ø Organizing a report into sections
Ø Copying data to other applications
Ø Alternative Query Techniques Using Combined Queries Using Sub-Queries
Ø Creating a Query based on another Query
Ø Character and Date String Functions Using the character string functions Concatenating different data types Using date functions
Ø Using If Logic
Ø Grouping data using If() logic
Ø Using If() to modify calculation behavior
Ø Advanced Reporting Features Formatting breaks
Ø Creating custom sorts
Ø Displaying document data in free-standing cells
Web-Intelligence Rich Client XI R3
Ø Introducing Web Intelligence
Ø Accessing information with Web Intelligence
Ø Understanding how universes allow you to query databases using everyday business terms
Ø Understanding Web Intelligence core functionalities
Ø Creating a document in the Web Intelligence Rich Client
Ø Viewing a Web Intelligence document in InfoView
Ø Creating Web Intelligence Documents with Queries
Ø Building a simple query
Ø Restricting data with query filters
Ø Applying a single-value query filter
Ø Using prompts to restrict data
Ø Using complex filters
Ø Report Design
Ø Working in the Report Panel
Ø Displaying data in tables and charts
Ø Presenting data in free-standing cells
Ø Enhancing the Presentation of Data in Reports
Ø Using breaks, calculations, and report filters
Ø Formatting breaks and crosstabs
Ø Using default and custom sorts
Ø Ranking data to see top or bottom values
Ø Tracking data changes
Ø Using alerters to highlight information
Ø Organizing a report into sections
Ø Copying data to other applications
Ø Formatting Reports
Ø Preparing documents for PDF and print
Ø Calculating Data with Formulas and Variables
Ø Understanding formulas and variables
Ø Understanding how Web Intelligence calculates data
Ø Creating formulas and variables to calculate data
Ø Using Multiple Data Sources
Ø Adding a new query using a personal data provider
Ø Creating multiple queries in a document
Ø Synchronizing data with merged dimensions
Ø Analyzing Data
Ø Drilling into the data
Ø Setting Web Intelligence drill options
Ø Managing and Sharing Web Intelligence Documents
Ø Exporting documents from the Rich Client
Ø Accessing InfoView
Ø Managing documents in InfoView
Ø Sharing documents in InfoView
Ø Scheduling a Web Intelligence document
Ø Setting InfoView preferences
Ø Advanced Query Techniques
Ø Using combined queries
Ø Using sub-queries
Ø Creating a query based on another query
Ø Changing data sources
Ø Using the query drill
Ø Using query sampling
Ø Understanding dimensions and details
Ø Character and Date String Functions
Ø Using character string functions
Ø Concatenating different data types
Ø Using date functions
Ø Calculation Contexts
Ø Understanding calculation contexts
Ø Redefining calculation contexts
Ø Using If Logic
Ø Grouping data with If() logic
Ø Using IF/ELSEIF
Ø Additional Reporting Techniques
Ø Using data tracking
Ø Displaying data restricted by a filter or ranking
Ø Using additional report functions
Ø Linking to Documents
Ø Linking to documents and URLs in Web Intelligence
Ø Creating hyperlinks in the HTML Report Panel
Ø Creating hyperlinks in the Web Intelligence Rich Client and Java Report Panel

Basic BO Administration (CMC) ^Top
Ø Understanding BusinessObjects Enterprise What is BusinessObjects Enterprise? Working in InfoView
Ø Working in the Central Management Console Busi nessObjects Enterprise Architecture
Ø Understanding the BusinessObjects Enterprise architecture Busi nessObjects Enterprise Security Creating users, groups, and folders The Busi nessObjects Enterprise security model
Ø Categories
Ø Guidelines for planning security
Ø Profiles
Ø Publishing
Ø Scheduling
Crystal Reports Basic: Fundamentals of Report Design
• Planning a Report
o Define database concepts
o Plan and develop a report prototype
• Creating a Report
o Create a report
o Add tables
o Describe the design environment
o Insert objects on a report
o Preview a report
o Save a report
o Position and size objects
o Format objects
• Selecting Records
o Define the Select Expert
o Determine the criteria for record selection
o Understanding saved and refreshed data
o Apply record selection
o Apply additional record selection criteria
o Modify record selection
o Apply time-based record selection
• Organizing Data on a Report
o Sort records
o Group records
o Summarize data
• Formatting a Report
o Add graphical elements
o Combine text objects with database fields
o Apply specialized formatting
o Insert fields with pre-built functions
• Applying Section Formatting
o Format sections
o Create a summary report
• Creating Basic Formulas
o Define a formula and its purpose
o Create formulas
o Apply Boolean formulas
o Apply If-Then-Else formulas
o Apply date calculations
o Apply number calculations
o Apply string manipulation
• Applying Conditional Reporting
o Determine trends in data
o Format data conditionally
• Representing Data Visually
o Create a chart
• Distributing a Report
o Export a report
o Save a report to BusinessObjects™ Enterprise
b): Crystal Reports - Business Reporting Solutions
• Using the Repository
o Use the repository
o Create a report from a repository data source
• Creating Formulas
o Use functions and operators
o Define control structures available in Crystal Reports Syntax
• Managing Reports
o Use the Workbench
o Publish reports to BusinessObjects Enterprise
• Using Variables and Arrays
o Use variables
o Use arrays
• Using Report Templates
o Apply report templates
o Build a template without a data source
o Remove a template
• Building Parameterized Reports
o Define and create parameters
o Build a report with multiple parameters
o Use edit masks and descriptions
o Create a date range parameter
o Group using parameters
• Summarizing Data with Crosstabs
o Build a basic crosstab
o Format a crosstab
• Using Report Sections
o Use sections
o Use group related functions to format sections
o Use section underlay
o Use multiple-column reporting
• Building Specialized Reports
o Use the Running Total Expert
o Create a form letter
o Add a hyperlink to a report
o Use Dynamic Graphic Locations
o Build a report with alerts
o Build a top N report
o Integrate an Xcelsius Flash SWF into a Crystal report
c) Crystal Reports: Report processing strategies:
• Report Processing
o Use multi-pass reporting
o Use evaluation time functions
o Use a dynamic array
• Using Subreports
o Define subreports
o Create an unlinked subreport
o Create a linked subreport
o Create an on-demand subreport
o Use shared variables with subreports
o Link “unlinkable” data with subreports
o Describe alternate solutions to using subreports
• Creating Complex Formulas
o Use Print State functions
o Use loop control structures
o Use loop control structures with arrays
• Using Custom Functions
o Describe a custom function
o Use custom functions
• Using XML and Web Services Data
o Use XML and web services data
o Use a transform in XML exporting
Courses Offerings

• Android
• AIX Administration
• Business Analyst
• Citrix XenApp
• Cognos 10 BI & Tm1
• Data Stage
• DB2 DBA
• Dot Net
• DAC
• Google Web Tool Kit
• IBM Lotus Notes (Development)
• IBM Lotus Notes Domino Server Administration
• IBM Message Broker
• IBM MQ Series
• IBM Tivoli Access Manager
• IBM Web Sphere Application Server Administration (WAS)
• IBM WAS Portal server Development
• Informatica
• I Phone
• Java/J2EE
• J Query
• MicroSoft .NET Technologies (VB.NET, C#, ASP.NET)
• Microstrategy
• MicroSoft Business Intelligence
• MicroSoft Dynamics CRM
• OBIEE 11 g
• Oracle APPS – HRMS
• Oracle APPS – SCM
• Oracle APPS – Financial
• Oracle APPS – Technical
• Oracle BI Apps
• Oracle BI Publisher
• Oracle DBA 11g
• Oracle RAC
• Oracle Fusion SOA
• Oracle SQL , PL SQL
• PHP
• Perl Scripting
• SAP SD , BO , FICO , BI / BW , APO
• Sales Force CRM
• SharePoint Server 2010
• Shell Scripting
• Siebel CRM , EAI, E-Scripting
• SQL Server DBA
• Springs and Hibernate
• Storage Area Network ( SAN)
• Testing Tools - QTP, QC, Load Runner, Selenium, ISTQB
• TIBCO BW, BE, TIBCO I Process
• Tivoli Access Manager
• Unix Administration
• VN Ware
• WCF, WPF, LINQ, AJAX, SILVER LIGHT
• Webmethods
• Webservices , SOAP ( JAVA)




Visit www.futurepointtech.com for course curriculum

Drop a mail info@futurepointtech.com we will get in touch with u