SAP BusinessObjects: Desktop Intelligence Advanced Report Design XIr2
Starting dates and places
Description
Overview
• Use alternative query techniques
• Use sub-queries
• Use date string functions
• Use XML as a data source
This one day course is designed to give delegates the comprehensive skills needed to apply advanced reporting techniques in the creation of Desktop Intelligence documents.
After completing this course delegates will be able to apply alternative query techniques in the creation of advanced Desktop Intelligence documents and reports. Delegates 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.
This course is suitable for delegates who use either SAP Busi…
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
Overview
• Use alternative query techniques
• Use sub-queries
• Use date string functions
• Use XML as a data source
This one day course is designed to give delegates the
comprehensive skills needed to apply advanced reporting techniques
in the creation of Desktop Intelligence documents.
After completing this course delegates will be able to apply
alternative query techniques in the creation of advanced Desktop
Intelligence documents and reports. Delegates 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.
This course is suitable for delegates who use either SAP
BusinessObjects versions 6.x or XI Release 2.
Prerequisites
This course is for report designers who are experienced Desktop
Intelligence users and who need to create more advanced Desktop
Intelligence documents. Delegates must have attended one of the
following courses:
• SAP BusinessObjects: Desktop Intelligence Report Design
(BOR210)
• SAP BusinessObjects: Desktop Intelligence FastTrack (BOFT)
Course Outline.
Alternative Query Techniques
• Defining Combined Query Types
• Using Combined Queries
• Using Sub-Queries
• Creating a Query on a Query
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
User-Defined Objects
• Creating User Objects
• Using a User Object in a Query
• Editing a User Object
• Deleting a User Object
• Storing a User Object
Grouping Data
• Grouping Data Using "If… Then… Else…"
• Using If…Then…Else to Modify Calculations
Calculation Contexts
• Understanding Calculation Contexts
• Using Forced Output Calculation Context
• Using Forced Input Calculation Context
• Identifying Input and Output Context
Advanced Charting
• Using Charts
• Invoking a Secondary Y-axis
• Applying Multiple Styles on a Single Y-axis
Reporting from Other Data Sources
• Using XML as a data source
QA reserves the right to improve the specification and format of
its courses for the benefit of its customers without notice to the
customer.
Share your review
Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.