BUSINESSOBJECTS DESKTOP INTELLIGENCE XI R2:
ADVANCED REPORT DESIGN-------Duration – 1 day

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

BUSINESS OBJECTS XI R1/R2: ADVANCED UNIVERSE DESIGN----Duration – 2 days
Universe Development Process
• Understanding the metadata
• Universe Development Cycle
• Best practices for universe design

Universe Parameters
• Data access files and connection parameters
• Business Objects dynamic SQL parameters
• Connection and user credential parameters

Advanced Objects Scenarios
• Combining database functions in objects
• Constructing relative date-time objects
• Working with Transact_SQL functions

Complex Predefined Conditions, LOVs and Joins
• Complex predefined conditions
• Advanced LOVs
• Advanced Join syntaxes

SQL Traps Revisited
• Chasm Traps
• Fan Traps

Extended Index Awareness and Derived Tables
• Applying Index Awareness
• Derived Tables

External Strategies
• Creating and using external strategies

Contact Us : Call: + 91 80 40636167 Hotline: + 91 80 40636161 Email:afzal.m@colossaltechnologies.com For further details visit :www.verticaldivers.com