Business Objects- Reporting (Workshop-22nd-23rd June, Hyderabad) (BOXI-Reporting)
Venue: Madhapur
Location: Hyderabad, Andhra Pradesh, India
Event Date/Time: Jun 22, 2009 | End Date/Time: Jun 24, 2009 |
Early Registration Date: Jun 16, 2009 |
Description
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