SAP BW-BEX Query
• Introduction to SAP BW
• SAP BW InfoProvider
• SAP BW-BEx Query Designer and Analyzer
• Create a SAP BW-BExQuery.
• Learn how to filter data in the Query Designer.
Information Design Tool IDT
• Understanding of Information Design Tool
• Creating OLAP and Relational Connections.
• Creation of Business and Data foundation layer
• Making UNX files and exporting to repository
• Introduction to CMC, establishing OLAP connections in CMC
SAP Business Objects Web Intelligence and BI Launch Pad 4.1
• Overview of Interactive Analysis concepts and core functions
• Creating Interactive Analysis documents withBex
• Restricting data returned by a query
• Designing Interactive Analysis reports
• Formatting reports
• Calculating data with formulas and variables
• Using multiple data sources
• Analyzing data
• Managing and sharing Interactive Analysis documents
• Using prompts to restrict data
• Displaying data in tables and charts
• Presenting data in free-standing cells
• Using breaks, calculations, sorts and report filters
• Ranking data to see top or bottom values
• Creating Hyperlink in reports
Dashboard Design (Xcelsius)
• • Getting around in Xcelsius
• Creating Dashboard with BEX
• 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 dynamic visibility
SAP BO-Crystal Reports
• Creating reports in Crystal reports Enterprise
• Creating Reports withBex
• Exporting reports to Launch Pad
• Selecting records
• Organizing data on reports
• Formatting & section formatting
• Creating basic formulas
• Using variables
• Summarizing data with cross tabs
• Using report sections
• Subreports
SAP BO-Analysis for OLAP and Office
• Navigate the interface in the edition for OLAP
• Create a workspace
• Save to a public folder
• Insert a data source using an OLAP connection to SAP BW
• Insert a crosstab and Add data to a crosstab
• Insert a chart
• Insert a simple calculation
SAP Business objects Explorer
• Introduction to SAP Business Objects Explorer
• Exploring data based on UNX files
• Creating and managing spaces
• Creating Indexes for the reports
• Set properties, scheduling
• BI Launch Pad integration