OXiane Luxembourg > Filières > Business Intelligence et Aide à la décision avec SAP BusinessObjects > SAP BusinessObjects Desktop Intelligence XI Advanced Report Design

BOR220

Durée

  • 1 journée

Objectifs

  • Apply alternative query techniques
  • Create advanced documents and reports

Public

  • Business users

Pré-requis

  • BusinessObjects Desktop Intelligence XI : Report Design

Tarif d'inscription

  • 475 € H.T. par personne (déjeuner inclus)

Planning Luxembourg

Calendrier 2013

  • Le 28 juin
  • Le 30 septembre
  • Le 30 octobre
  • Le 16 décembre

Planning France

Consulter la fiche

SAP BusinessObjects Desktop Intelligence XI Advanced Report Design

Desktop Intelligence is an integrated query, reporting and analysis solution that allows business users to access the data in their corporate databases directly from their desktop and present and analyze this information in a Desktop Intelligence document.

This course is designed to give learners the comprehensive skills needed to apply advanced reporting techniques in the creation of Desktop Intelligence documents. After completing this course learners will be able to apply alternative query techniques in the creation of advanced Desktop Intelligence documents and reports. Learners will also be able to apply character and date string functions, create user-defined objects, group data, and use calculation contexts to further develop their documents and reports.

Programme

Lesson #1 - Alternative Query Techniques

  • Using combined queries
  • Using sub-queries
  • Creating a query based on another query

Lesson #2 - Character and Date String Functions

  • Using the character string functions
  • Concatenating different data types
  • Using date functions

Lesson #3 – Using If Logic

  • Grouping data using If() logic
  • Using If() to modify calculation behavior

Lesson #4 - Advanced Reporting Features

  • Formatting breaks
  • Creating custom sorts
  • Displaying document data in free-standing cells
  • Overriding filters and ranking

Lesson #5 - Calculation Contexts

  • Understanding calculation contexts
  • Redefining the calculation context

Lesson #6 - Advanced Charting

  • Using Charts
  • Invoking a Secondary Y-axis
  • Applying Multiple Styles on a Single Y-axis

Lesson #7 - Reporting from Other Data Sources

  • Using XML as a data source