BODS
Duration: 45 Hours
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
Dashboard Builder
Understanding Dashboard Manager
Setting Up Dashboard Manager
Creating Metrics
Automating Dashboards with Rules
Creating Analytics
Creating Personal Dashboards
Creating Corporate Dashboards
Guiding Dashboard Navigation
Xcelsius-Scorecard Builder
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
Migration from BO5.X to BOXIR3
Migration fundamentals
How Business Objects Enterprise XI 3.0
Compares with versions 5.x and 6.x
Migration concepts
Import Wizard Concepts
Understanding object migration
Understanding user and group migration
Migration planning and assessment
After migration with the Import Wizard
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)
Webi-rich Client
Installing Web Intelligence Rich Client
Web Intelligence Rich Client working modes
Launching Web Intelligence Rich Client
To set user preferences in Web Intelligence Rich Client
Working with documents
Working with universes in Web Intelligence Rich Client
Accessing Web Intelligence from InfoView
Working with queries in Web Intelligence Rich Client
Working with reports
Universe Builder & Query Builder
Universe Builder basics
Building universes from XML metadata sources
Updating XML metadata source universes
Exporting a universe to a XML file format
Query as Web service
Configuring the QWS with BO System
Creating Webservice report from Universes
Creating WSDL reports
Using WSDL reports in external application
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/Edge 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
Introduction to BO-SDK
Introduction of BO Enterprise SDK
Choosing the right SDK
Customizing the Webi reports using SDK
Introduction to BO Extension points:
How to use & Leverage BO Extension points in Business Objects
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
Installation of BOXIR3 suite with System/Audit/Performance mgmt repositories using Oracle/SQLSERVER/SAPBW
BO installation with Oracle
BO installation with SQL Server
BO installation with MYSQL
BO installation with SAPBW
Testing & Migration of BO components from Dev/Stage/Production environment
Migrating the BO objects to Stage & Production
Testing the BO Reports using TOAD Developer
Creating LDAP Security model for migration
Polestar/Business Explorer
Creating Polestar Reports
Configuring Pole star with BO System
BO XI R3 Certification Guidelines:
Sample questions on Business Objects Certified Professional – Business Objects Web Intelligence XI 3.0 – Level One
Sample questions on Business Objects Certified Professional – Business Objects Web Intelligence XI 3.0 –Level two
Want to Learn SAP BODS Online Training Contact at BigClasses.com
Duration: 45 Hours
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
Dashboard Builder
Understanding Dashboard Manager
Setting Up Dashboard Manager
Creating Metrics
Automating Dashboards with Rules
Creating Analytics
Creating Personal Dashboards
Creating Corporate Dashboards
Guiding Dashboard Navigation
Xcelsius-Scorecard Builder
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
Migration from BO5.X to BOXIR3
Migration fundamentals
How Business Objects Enterprise XI 3.0
Compares with versions 5.x and 6.x
Migration concepts
Import Wizard Concepts
Understanding object migration
Understanding user and group migration
Migration planning and assessment
After migration with the Import Wizard
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)
Webi-rich Client
Installing Web Intelligence Rich Client
Web Intelligence Rich Client working modes
Launching Web Intelligence Rich Client
To set user preferences in Web Intelligence Rich Client
Working with documents
Working with universes in Web Intelligence Rich Client
Accessing Web Intelligence from InfoView
Working with queries in Web Intelligence Rich Client
Working with reports
Universe Builder & Query Builder
Universe Builder basics
Building universes from XML metadata sources
Updating XML metadata source universes
Exporting a universe to a XML file format
Query as Web service
Configuring the QWS with BO System
Creating Webservice report from Universes
Creating WSDL reports
Using WSDL reports in external application
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/Edge 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
Introduction to BO-SDK
Introduction of BO Enterprise SDK
Choosing the right SDK
Customizing the Webi reports using SDK
Introduction to BO Extension points:
How to use & Leverage BO Extension points in Business Objects
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
Installation of BOXIR3 suite with System/Audit/Performance mgmt repositories using Oracle/SQLSERVER/SAPBW
BO installation with Oracle
BO installation with SQL Server
BO installation with MYSQL
BO installation with SAPBW
Testing & Migration of BO components from Dev/Stage/Production environment
Migrating the BO objects to Stage & Production
Testing the BO Reports using TOAD Developer
Creating LDAP Security model for migration
Polestar/Business Explorer
Creating Polestar Reports
Configuring Pole star with BO System
BO XI R3 Certification Guidelines:
Sample questions on Business Objects Certified Professional – Business Objects Web Intelligence XI 3.0 – Level One
Sample questions on Business Objects Certified Professional – Business Objects Web Intelligence XI 3.0 –Level two
Want to Learn SAP BODS Online Training Contact at BigClasses.com
