Web Intelligence Advanced Report Design XI 3.1

After completing this course, delegates will be able to combine queries and use sub-queries. Additionally delegates will be able to use character and date string functions, create variables using "If" logic, redefine calculation contexts, as well as use advanced reporting techniques such as formatting breaks and using custom sorts. 

Who should attend?

The target audience for this course is report designers who are experienced Web Intelligence users and who need to create more advanced Web Intelligence documents.

Delegates will be able to

• Apply alternative query and reporting techniques when creating advanced Web Intelligence documents.
• Create combined queries and use sub-queries
• Use character and date string functions, create variables using "If" logic, redefine calculation contexts and create hyperlinks in your documents using Web Intelligence dialog boxes.

Pre-requisites

Delegates must have attended the following courses,

• SAP BusinessObjects - Web Intelligence XI 3.0/3.1 Report Design or Web Intelligence FastTrack Rich Client or Web Intelligence FastTrack Web Client

Topics covered

Advanced Query Techniques

• Using combined queries
• 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
• Modifying calculation behaviour 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