|
|
|
|
|
|
|
|
|
|
|
| Category |
Computers: Software
|
|
|
|
|
|
|
|
|
|
|
|
| Description |
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
|
|
| Additional Information |
Contact Us :
Call: + 91 80 40636167
Hotline: + 91 80 40636161
Email:afzal.m@colossaltechnologies.com
For further details visit :www.verticaldivers.com
|
|
