SAP BI BO 4.0 Online Content
SAP Business Objects Web Intelligence and BI Launch Pad 4.0
Web-Intelligence Rich Client 4.0
Information Design Tool 4.0
Universe Designer Tool 4.0
Basic BO Administration (CMC)
SAP Business Objects Dashboards 4.0 (Crystal Xcelsius 2011)
SAP Crystal Reports 2011
- Oracle (Basics)
- SAP Business Objects Web Intelligence and BI Launch Pad 4.0
- Web-Intelligence Rich Client (Desktop based tool)
- SAP Business Objects BI Information Designer Tool(IDT )
- SAP Business Objects BI Universe Designer tool (UDT)
- SAP BW Infocubes to Universe with IDT
- SAP HANA to design the Universe with IDT and UDT (SAP HANA with BO)
- Lifecycle Management & Upgrade management tool
- Report Conversion Tool (Deski to Webi Reporting)
- BO Administration/ Security (CMC)
- SAP Business Objects Dashboards 4.0 (Crystal Xcelsius 2011)
- Crystal Reports
- Integration with SAP BW – BO (SAP BI Integration with BO )
- BO Project migration
- BO Deployment and Report Scheduling
- Connecting to Data Sources
- New features of SAP Business Objects 4.1
- Differences between different versions of BO
- Interview Questions and BO Certification
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
DW Concepts
- Definition
- Methodologies
- Dimensional Modeling
- DW Lifecycle
- DW Challenges
- ETL introduction
- Staging Area
- Business Rules
- Performance
- Slowly Changing Dimensions
- Surrogate Keys
- Facts and Dimension Tables
- Different ETL Tools
- History
- Components
- Architecture
- Purpose of Data Services
- Data Services architecture
- Define Data Services objects
- Data Services Designer interface
- Object Hierarchy
- Jobs
- Workflows
- Data Flows
- Data Stores
- File formats for flat files
- File formats for Excel files
- File formats for XML files
- Lab Exercises
- Creating repository
- Setting Job Server
- Setup for realtime operation
- Setting multiple datastores
- Starting Job servers
- Lab Exercises
- Work with objects
- Create a data flow
- Use the Query transform
- Use target tables
- Execute the job
- Lab Exercises
- Use descriptions and annotations
- Validate and tracing jobs
- Use View Data and the Interactive Debugger
- Use auditing in data flows
- Lab Exercises
- Define built-in functions
- Functions in expressions
- Lookup function
- Decode function
- Variables and parameters
- Data Services scripting language
- Scripting custom functions
- Lab Exercises
- Map Operation transform
- Validation transform
- Merge transform
- Case transform
- SQL transform
- Lab Exercises
- Pivot transform
- Hierarchy Flattening transform
- Data Transfer transform
- XML Pipeline transform
- Lab Exercises
- Error Handling
- Recoverable work flows
- Update data over time
- Database native CDC mechanisms
- Source-based CDC
- Target Comparison
- Lab Exercises
- Fundamentals of DQ and Data Cleansing
- Built in DQ Transformations
- Data Validation
- Name & Address cleansing
- De duplication
- Cleansing other data
- Lab Exercises
- Real Time Jobs
- SOAP Introduction
- Web Services
- 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
SAP BW
BI Overview and BI Architecture
Data Modeling:
Data Modeling:
- Data Warehouse Workbench
- Types of Data
- Infoobjects and Types
- Attributes Types
- Star Schema
- Extended star schema
- Infocube and Types
- DSO and Types
- Multiproviders
- Infosets
- Transformations, Infopackage and DTP’s.
- Business Content Installation
- Transport Requests and Maintenance
- Open Hub Service
- Performance Tuning.
- Process Chains.
- Bex Tools introduction
- Query Designer
- Calculated Key Figure and Formulas
- Restricted Key Figure and Selection
- Structures
- Variables
- Conditions
- Exceptions
- Report to Report Interface
- Analyzer
- Query Analysis
- SAP Toolbar Components and usage
- Workbook Design
- Types of Extractors
- Flatfile Extraction
- LO-Cockpit Extraction
- Filling and deleting setup tables
- Initializing Data Source
- Update Types
- Enhancement of Data source
- FI Extraction
- Generic Extraction
- Creation
- Generic Delta
- Extract Structure setting
- Remodeling
- Repartioning
- Web Application Designer
- Creation of Web Templates
- Editing of standard Web Templates
- Report Designer
- Introduction
- Formatting of Static Reports
- Formatting of Dynamic Reports
- Information Broadcasting
- Introduction
- Formats and Distribution Types
- Settings and scheduling
- Publishing of Web Reports, Queries, Workbooks to SAP Portal
- SAP NetWeaver BW 7.3 Feature Overview
- Graphical Data Modeling
- Graphical Data Flow Modeling Basics
- Data Flow Copying
- Data Flow Generation
- Data Flow Migration
- Advanced InfoProviders
- Semantically Partitioned Object (SPO)
- Hybrid InfoProviders
- TransientProviders
- The New BW 7.3 Hierarchy ETL
- SAP BO integration with SAP BW.
- SAP HANA Introduction
- Real Time Scenarios for Hands on Experience
- Discussion on Errors in Support Project and Implementation Projects
- Discussing the challenges in SAP BI projects.
- Sample Interview questions
- Resume Preparation and Interview Guidance