Talk to a Training Advisor
Availability
Schedule available upon request within 24 hours.
|
|
About this class This programme is for you if want to understand the power of BusinessObjects reporting using Web Intelligence. In a series of practical sessions, you will create queries, format reports and execute complex data manipulation. It embraces much of the material covered on the two day programme - Reporting with Web Intelligence- so the pace is that much quicker and the day a little longer than most other programmes. What delegates will learn Delegates will learn to: - Define the role of universes, classes, objects, measures, dimensions and details
- Construct queries using pre-defined and ad-hoc conditions
- Format reports
- Manipulate data by applying filters, sorts, breaks, calculations and ranking
- Create cross-tabular and financial reports
- Generate and modify charts
- Analyse data at different levels of detail
What prerequisites are required - Working knowledge of Microsoft Excel or Microsoft Access
- A basic understanding of BusinessObjects
Contents of this class Introduction - Web Intelligence
- Getting help
- Universes, classes and objects
- Measure, dimension and detail objects
- Presentation blocks
- Logging into Web Intelligence
Using InfoView - Accessing InfoView
- The home page
- Accessing public and personal documents
- Accessing documents from the Inbox
- Refreshing documents from InfoView
- Saving documents from InfoView
- What is my InfoView
- Configuring InfoView
- Display, list and view options
- Create and edit options
- Password options
- Configuring my InfoView
- Basic document editing
- Logging out of InfoView
Creating new documents with queries - Result objects
- Editing queries and blocks
- The query panel
- Predefined and ad-hoc query filters
- Using wildcards in conditions
- Prompted queries
- Multiple conditions and logical operators
Changing presentation styles - Presentation styles
- Vertical and horizontal tables
- Multiple blocks
- Cross tabs, forms and charts
- Changing presentation styles
- Converting data to a cross tab
- Converting data to a horizontal block
- Converting data to forms and charts duplicating blocks
Applying functions and sections - Functions
- Breaks
- Simple calculations
- Sorts
- Removing breaks, sorts and calculations
- Filters
- Applying filters to charts and multiple blocks
- Sectioned reports
- Aggregate totals in a sectioned report
- Multiple blocks in a sectioned report
- Sizing sections
Document formatting - Document properties
- Report formats
- Table formats
- Cell formats
- Inserting and formatting page numbers
- Formatting sections and charts
Variables and formulas - Report variables
- Creating formulas
- Converting formulas to variables
- Editing and deleting variables
- Using formula functions
Drill reports - Simple drilling
- Saving a snapshot of analysis
- Drilling on multiple hierarchies in a cross tab
- Drilling on charts
- Drilling in HTML viewing mode
Merging dimensions - Creating multiple queries
- Arranging dimensions
- Merging dimensions
- Workshop - merging dimensions
Review of Programme Optional follow-on classes - BusinessObjects Advance Reporting with Web Intelligence
|