Reporting with Desktop Intelligence Advanced Workshop
Workshop Description
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 analyse this information in a Desktop Intelligence document.
This workshop is designed to give learners the comprehensive skills needed to apply advanced reporting techniques in the creation of Desktop Intelligence documents. After completing this workshop 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.
Workshop Topics
Lesson #1 – Alternative Query Techniques
- Designing Combined Query Types
- Using Combined Queries
- Using Sub-Queries
- Creating a Query on a Query
Lesson #2 – Character and Date String Functions
- Understanding Character Strings
- Using the Replace Function
- Using the Right Function
- Using the SubString () Function
- Using the Pos() Function
- Concatenating Different Data Types
- Using Date Functions
Lesson #3 – User-Defined Objects
- Creating User Objects
- Using a User Objects in a Query
- Editing a User Object
- Deleting a User Object
- Storing a User Object
Lesson #4 – Grouping Data
- Grouping Data Using "If...Then...Else"
- Using If...Then...Else to Modify Calculations
Lesson #5 – Calculation Contexts
- Understanding Calculation Contexts
- Using Forced Output Calculation Context
- Using Forced Input Calculation Context
- Identifying Input and Output Context
Lesson #6 – Advanced Charting
- Using Charts
- Invoking a Scondary Y-axis
- Applying Multiple Suples on a Sing Y-axis
Lesson #7 – Reporting from Other Data Sources
- Using XML as a data source
Business Objects 6.x and Business Objects XI R2/R3
This workshop is designed to teach learners using the XI R2/R3 version how to apply advanced reporting techniques in the creation of documents using Desktop Intelligence. Note that there is not an XI R1 version of Desktop Intelligence and that the previous version is Business Objects 6.x full client. New features covered in this course include:
- WebConnect is no longer available as a data source for reporting
Audience
The target audience for this workshop is business users who need to generate effective reports using SAP Business Objects Desktop Intelligence.
The audience for this workshop may consist of BusinessObjects 6.5, BusinessObjects XI Release 1 and Business Objects XI Release 2/3 customers.
Pre requisite Knowledge, Experience and Education
Experience building Desktop Intelligence XI R2 Report Design
Delivery & Duration
This is a 1 day, instructor led workshop, which can be delivered either on your site or at our training suite in Birmingham.
Request More Information
For more information regarding this workshop, please call today 0845 124 9495 and speak to one of our team or complete our short form below.
