This course is delivered both in the classroom and virtually (remote classroom). Participants will gain the comprehensive skills and in-depth knowledge needed to apply alternative query and reporting techniques when creating complex Web Intelligence documents. After completing this course, participants will be able to create combined queries and use sub-queries. They will also be able to use character and date string functions, create variables using “If” logic, and redefine calculation contexts. They will learn how to link Web Intelligence documents using the hyperlink functionality and also create their documents using various SAP data sources.

Audience: The target audience for this course is report designers who are experienced Web Intelligence users and who need to create complex Web Intelligence documents.
Course Duration: 1 day
Prerequisites:

Students should attend our SAP BusinessObjects Web Intelligence course. We also recommend they have experience designing Web Intelligence reports.

Course Outline:
  • Review Web Intelligence Report Design Concepts
    • Using Combined Queries
    • Using Subqueries
    • Creating a Query Based on Another Query
    • Changing Data Sources

 

  • Working with calculation contexts
    • Understanding Calculation Contexts
    • Redefining Calculation Contexts

 

  • Creating formulas with character and date string functions
    • Using Character Strings
    • Using the Right() function
    • Using the Replace() function
    • Using the SubStr() function
    • Using the Pos() function
    • Concatenating Different Character Strings
    • Using Date Functions

 

  • Using If logic
    • Using If() to Group Data
    • Using the If() Function to Modify Calculation Behavior

 

  • Working with additional reporting techniques
    • Using Data Tracking
    • Using Additional Report Functions

 

  • Creating hyperlinks
    • Working with Hyperlinks in Interactive Analysis Documents
    • Creating Hyperlinks in the Interactive Analysis Interactive Panel
    • Creating Hyperlinks in Interactive Analysis Desktop and the Java Report Panel

 

  • Creating a document using other data sources
    • Using the SAP Data Source Options
    • Creating a Document using an Existing BEx Query
    • Creating a Document using a Hierarchical Universe
    • Creating a Document using an Analysis View