Saturday, 23 February 2013

SAP BO Training | SAP BODS Training | SAP BO Course


SAP Business Objects Course Content

SAP Business Objects Course Content
  • Oracle Basics
  • SAP BO Web Intelligence and  BI Launch Pad 4.0
  • Web Intelligence Rich Client (Desktop)
  • SAP BO BI Information Designer Tool
  • SAP BO BI Universe Designer Tool
  • SAP BW Infocubes
  • Crystal reports
  • BO Project Migration
  • Connecting data Sources
SAP Business Objects Web Intelligence and BI Launch Pad 4.0.
  • SAP Business Objects Dashboards 4.0
  • BI launch pad: What's new in 4.0
  • Customizing BI launch pad
  • Overview of Interactive Analysis core functions
  • Creating Interactive Analysis documents with queries
  • Restricting data returned by a query
  • Designing Interactive Analysis reports
  • Enhancing the presentation of data in reports
  • Formatting reports
  • Calculating data with formulas and variables
  • Using multiple data sources
  • Analyzing data
  • Managing and sharing Interactive Analysis documents
  • Reporting from Other Data Sources
  • Introducing Web Intelligence
  • Accessing corporate information with Web Intelligence
  • Understanding how universes allow you to query databases using everyday business terms.
  • 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
  • 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 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


Web-Intelligence Rich Client 4.0

  • Introducing Web Intelligence
  • Accessing information with Web Intelligence
  • Understanding how universes allow you to query databases using everyday business terms
  • Create reports using webservises as a Data source
  • Understanding Web Intelligence core functionalities
  • Creating a document in the Web Intelligence Rich Client
  • 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
  • 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

Information Design Tool 4.0
  • What is the Information Design Tool (IDT)
  • Create a project
  • Create a connection to a relational database (Single and Multiple databases)
  • Create the data foundation with Single & Multiple databases
  • Define the different types joins in a data foundation
  • Create a business layer
  • Create folders and objects
  • Resolve Loops and Use alias
  • Resolve Loops Use contexts
  • Resolving the fan traps and Chasm traps problem
  • Define data restrictions
  • Work with LOVs
  • Use Parameters restrict data
  • Use @functions also Aggregate Awareness
  • Create Derived Tables and Index Awareness
  • Maintain universes
  • Deploy and manage and maintain universes
  • Documentation of the universes
Universe Designer Tool 4.0
  • 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.
  • Derived Tables
  • Securing Universes.
  • Managing Universes.

Basic BO Administration (CMC)
  • Understanding BusinessObjects Enterprise What is BusinessObjects Enterprise? Working in InfoView
  • Working in the Central Management Console BusinessObjects 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
  • Setting up groups and users
  • Organizing and changing Folders & Categories
  • Authentication
  • Managing Servers
  • Connections
  • Controlling Universes
  • Scheduling through CMC
  • User Security
  • Database Configuration
  • Modify Settings for Applications
  • Access Levels
  • Security

SAP Business Objects Dashboards 4.0 (Crystal Xcelsius 2011)
  • Crystal Xcelsius Overview
  • Creating Dashboards using Query As A Web Service (QAAWS) and Live Office
  • Create Drill Down dashboard reports
  • What's new in SAP Business Objects Dashboards 4.0
  • 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
  • Using live data sources
  • Connecting to BO Universes using Query as a Web Service
  • Using Live Office data
  • Creating Complex dashboards

SAP Crystal Reports 2011
  • Creating reports
  • Selecting records
  • Organizing data on reports
  • Formatting & section formatting
  • Creating basic and complex formulas
  • Using variables
  • Using report templates
  • Applying conditional reporting
  • Building parameterized and specialized reports
  • Summarizing data with cross tabs
  • Using report sections
  • Representing data visually
  • Managing reports
  • Distributing reports
  • Using repository and repository data sources
  • Report processing
  • Linking Crystal Reports to Webi reports
  • Drill down reports

SAP BODS Course Content



DW Concepts
  • Definition
  • Methodologies
  • Dimensional Modeling
  • DW Lifecycle
  • DW Challenges
ETL Overview
  • ETL introduction
  • Staging Area
  • Business Rules
  • Performance
  • Slowly Changing Dimensions
  • Surrogate Keys
  • Facts and Dimension Tables
  • Different ETL Tools
Business Objects Overview
  • History
  • Components
  • Architecture
Data Services
  • Purpose of Data Services
  • Data Services architecture
  • Define Data Services objects
  • Data Services Designer interface
Data Services Objects
  • Object Hierarchy
  • Jobs
  • Workflows
  • Data Flows
Source and Target Metadata
  • Data Stores
  • File formats for flat files
  • File formats for Excel files
  • File formats for XML files
  • Lab Exercises
Environment setup
  • Creating repository
  • Setting Job Server
  • Setup for realtime operation
  • Setting multiple datastores
  • Starting Job servers
  • Lab Exercises
Batch Jobs
  • Work with objects
  • Create a data flow
  • Use the Query transform
  • Use target tables
  • Execute the job
  • Lab Exercises
Troubleshooting Jobs
  • Use descriptions and annotations
  • Validate and tracing jobs
  • Use View Data and the Interactive Debugger
  • Use auditing in data flows
  • Lab Exercises

Functions, Scripts and Variables
  • Define built-in functions
  • Functions in expressions
  • Lookup function
  • Decode function
  • Variables and parameters
  • Data Services scripting language
  • Scripting custom functions
  • Lab Exercises
Important Transforms
  • Map Operation transform
  • Validation transform
  • Merge transform
  • Case transform
  • SQL transform
  • Lab Exercises
Other Transforms
  • Pivot transform
  • Hierarchy Flattening transform
  • Data Transfer transform
  • XML Pipeline transform
  • Lab Exercises
Error Handling
  • Error Handling
  • Recoverable work flows
Change Data Capture
  • Update data over time
  • Database native CDC mechanisms
  • Source-based CDC
  • Target Comparison
  • Lab Exercises
Data quality Overview
  • Fundamentals of DQ and Data Cleansing
  • Built in DQ Transformations
  • Data Validation
  • Name & Address cleansing
  • De duplication
  • Cleansing other data
  • Lab Exercises
Web-Services and Real-Time Integration
  • Real Time Jobs
  • SOAP Introduction
  • Web Services
SAP Integration
  • Creating datastores for SAP databases
  • Accessing SAP data
  • Data extraction from ECC system to File, Table and SAP BI
  • Data extraction from ECC Extractors
  • Data Extraction from SAP BW

http://www.itprofessionalsnetwork.com
itprofessionalsnetwork@gmail.com


SAP BW-BI COURSE CONTNENT


SAP BI – Introduction to SAP Netweaver 2004s (7.0 BI) system

SAP BI – DATA WAREHOUSING (DW)

·         Overview, Posting & Fundamental of Data Warehousing
·         Objects in the BI DW layer
·         Data Acquisition & Transformation from SAP Source Systems
·         Data Acquisition from other systems
·         Business Content
·         Other Info Providers
·         Administration of Data Targets
·         Introduction to Query Performance Optimization
·         BI System upgrade and migration of dataflow from BW 3.x to BI 7.0
·         Transformation &UoM conversions
·         Write routines in transformations and debugging routines
·         DTP & DTP Error handling
·         Bi Integrated planning
·         Concepte - BI Accelerator and Analysis Process Designer (APD)

SAP BI - REPORTING & ANALYSIS

·         Introduction to BI Enterprise Reporting
·         Get to know BEx Query Designer
·         Key Figures, Characteristics, Variables, Exceptions and Conditions
·         BExAnalyzer
·         Enterprise Portal Integration and Document integration
·         Report - Report - Interface
·         Managing Query Objects
·         Business Content
·         Further SAP BI Reporting Tools
·         Information Broadcasting

SAP BI - DATA STAGING & EXTRACTION

·         Overview of Data Staging in SAP BI - BW Content
·         Data Transfer with the service API
·         Delta Management
·         Transferring data from flat files
·         XML Based extraction
·         Data Mart Interface
·         Application Specific Extraction

SAP BI - MODELING & AUTHORIZATION

·         Logical Model and BI Data Model
·         Tracking history and hierarchies
·         Modeling characteristics and key figures
·         Modeling ODS/DSO Objects and InfoCubes, Open Hub Service
·         Multidimensional Modeling
·         Changing Data Model
·         Special Modeling aspects
·         Authorizations - Setting up for reporting, standard roles and templates
·         Securing requirements in SAP BI
·         System Security

SAP BI - PERFORMANCE & ADMINISTRATION

·         InfoProvidermodeling and administration for performane
·         Optimize and monitor query performance and data acquisition performance
·         Aggregates and rollup
·         Transport Management for BI Objects
·         Process chains - Development & Monitoring


SAP BUSINESS OBJECTS COURSE CONTNENT




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)





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 & Customization

POLESTAR/BUSINESS EXPLORER

·         Creating Polestar Reports
·         Configuring Pole star with BO System



THANKYOU

Google+ Followers

Google+ Badge