Web Intelligence – Advance Report Design – SAP Business Objects BI

Request info

Duration: 1 Day

CONTENT

  • Reviewing Web Intelligence core report design
  • Working with advanced query techniques
  • Working with calculation contexts
  • Creating formulas with character and date string functions
  • Using If logic
  • Working with additional reporting techniques
  • Creating hyperlinks
  • Switching 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.

 
PREREQUISITES:

 
ESSENTIAL

  •  Learners should have attended the following courses: SAP Business Objects Web Intelligence: Report Design

RECOMMENDED

  • Experience designing Web Intelligence reports

GOALS

  • 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.

Cost: £395 + VAT

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2025-03-19' ) ) AND ((wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (2219) AND ((wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC