SAP Business Objects is the reporting tool owned by SAP. SAP Business Objects Business Intelligence solutions can be leveraged across the organization - from analysts to information workers to executives.
Data warehousing/Dimensional modeling/ SAP BW 7.3 Concepts
- OLTP vs. OLAP ,Types of OLAP
- Multi Dimensional Modeling Of SAP BW 7.3
- SAP BW 7.3 Cubes, DSO’s ,Multi Providers, Infosets
- Business Explorer (Bex) Queries in BW 7.3 system as Data sources
- Data Flow in BW 7.3 and Activating Business Content Cube.
- Joins & Cardinality
- Views/Materialized Views
- Date/Time Functions
BOXI 4.0 Architecture
- Architectural overview
- Client tier components
- Application tier components
- Intelligence tier
- Processing tier
- Data tier
- Security management
- Information
Information Design Tool
- Understanding Business Objects Universes
- Creating the Course Universe
- Building the Universe Structure
- Creating Dimension Objects
- Creating Measure Objects
- 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
- Securing Universes
- Implementing Universe Life Cycle Management
- Maintaining & Optimizing Universes
- Creating Universe from Other Data sources
Universe Design Tool
- Understanding Business Objects Universes
- Using the Universe Development Cycle
- Populating the Universe Structure
- Defining Joins in a Universe
Admininstration
- 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
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
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
- Creation of Web intelligence report with auto scheduling
- Creation of Corporate dashboard for Supply chain mgmt/Banking Domain
- 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
- Format a report
- Work with additional reporting techniques
- Create hyperlinks
Crystal Reports 2011
- 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 Design Tool
- 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
- 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
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
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
- Applying Conditional Reporting
- Enable consolidated prompts
- Set refresh settings for objects
- Set parameter binding
- Save Live Office documents to the repository
- Open and view Live Office documents from the repository
Query as Web service
- Configuring the QWS with BO System
- Creating Webservice report from Universes
- Creating WSDL reports
- Using WSDL reports in external application
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