Web Search
Designing BIRT Information Objects
One
Introducing Information Object Designer
About information objects
About Information Object Designer
About the Information Object Designer environment
Displaying hidden messages
Creating projects, data connection definitions, and maps
Creating an Actuate BIRT project
How to create an Actuate BIRT project
Propagating column and parameter renaming and deletion
Creating a data connection definition
Creating a data connection definition for a database
How to create a data connection definition for a database
Creating a data connection definition for an ODA data source
How to create a data connection definition for an ODA data source
About connection properties
About the IANAAppCodePage property
About Informix database connections
Specifying a production database schema
Encrypting and decrypting data source connection property values
Understanding the encryption extension point plug‑in
Extending the encryption extension point plug‑in
How to make the encryption extension point plug-in available to Eclipse
How to create a plug-in project
How to include required JAR files in the plug-in JAR file
How to select an extension point
How to create the plug-in class
How to implement the encrypt and decrypt methods
How to package the plug-in
How to deploy the plug-in
How to set the Type attribute to masked
Troubleshooting an encryption extension
Externalizing data source connection property values
About the data source connection configuration file
Externalizing connection property values for a preconfigured connection type
Externalizing connection property values for a configurable connection type
Externalizing connection property values for an ODA connection type
Creating maps
Creating a map of a database table or view
How to create a map of a database table or view
Updating a map of a database table or view
How to update a map
How to update several maps at once
Creating a map of a native SQL query
How to create a map of a native SQL query
Creating a map of a stored procedure result set
How to create a map of a stored procedure result set
How to modify an .epr file for a stored procedure
Creating a map of an ODA data source query result set
How to create a map of an ODA data source query result set
How to modify an .epr file for an ODA data source query
Creating information objects
Creating an information object
How to create an information object
Creating a graphical information object query
Using the expression builder
Choosing maps and information objects
How to choose maps and information objects
How to open a source map or information object in an editor
Defining output columns
How to define output columns
How to delete output columns
Creating and displaying column categories
How to create a column category or subcategory
How to rename, move, or remove a category or subcategory
Setting column properties
How to specify default values for analytics properties
About column property inheritance
Creating a filter for use in queries on an information object
How to create a filter for use in queries on an information object
Specifying a join
How to define a join condition
How to delete a join condition
Optimizing joins
Using join algorithms
How to specify a join algorithm
Improving the selectivity of a join
How to provide a value for the Cardinality property
How to provide values for join column properties
Creating a Cartesian join
Filtering data
Creating a filter condition
How to create a filter condition using Actuate SQL
Creating multiple filter conditions
Selecting a logical operator
Specifying the evaluation order
Prompting for filter values
Grouping data
Creating a GROUP BY clause
How to create a GROUP BY clause manually
Removing a column from the GROUP BY clause
How to remove a GROUP BY column manually
Filtering on an aggregate column
Defining parameters
How to define a parameter
How to delete a parameter
Specifying a parameter’s prompt properties
How to specify a parameter prompt’s properties
Setting parameter properties
Setting source parameters
How to set a source parameter
Synchronizing source parameters
Creating a textual information object
Displaying output columns
Displaying parameters
Displaying and testing information object output
How to display and test information object output
Displaying a data source query
How to display a data source query and information about the query
Understanding query execution plan operators
Understanding node operators
Augment
Box
CallExecutionUnit
DependentJoin
Dup
Materialize
MergeJoin
Move
MultiAugment
Nest
NestedLoopJoin
Project
Select
Sort
Union
Understanding leaf operators
FakeData
FakeFileData
IteratorAsLeaf
NoOp
ODA
SortedOuterUnion
SQL
Storing a query plan with an information object
Saving an information object’s query plan
Saving query plans for source and dependent information objects
Deleting an information object’s query plan
Localizing an information object
How to localize an information object
How to modify a translation string
How to modify a translation key
How to disable localization for a column or parameter property
How to restore localization for a column or parameter property
Caching information objects
About information object caching
Creating a cache connection definition
Creating a cache object
Refreshing the data rows in a cache table
Database-specific limitations
How to create a cache object
Building and publishing a project
Building a project
Propagating column and parameter property values
Publishing a project
How to create an iServer profile
Publishing information object files as resources
How to copy information object files to the shared resources folder
How to publish information object files as resources
Publishing information object files as non-resources
How to publish information object files as non-resources
Downloading files from an Encyclopedia volume
How to download information object files from an Encyclopedia volume
Assessing the impact of project changes
About project dependencies
Searching for data connection definitions, maps, and columns
How to search for a data connection definition, map, or column
Displaying the project model diagram
How to display the project model diagram
How to display a specific part of the project model diagram
How to reinstate the project model diagram’s initial layout
How to collapse or expand column and parameter lists
How to display an impact path
How to clear an impact path
How to refresh the project model diagram
How to display an impact report
How to open the editor associated with a file
Assessing the impact of a change on files in an Encyclopedia volume
Downloading files from an Encyclopedia volume
Determining the dependencies between project files
Generating an impact report
Actuate SQL reference
About Actuate SQL
Differences between Actuate SQL and ANSI SQL-92
Limitations compared to ANSI SQL-92
Extensions to ANSI SQL-92
Database limitations
FILTERS statement in report designers
Actuate SQL syntax
Actuate SQL grammar
Using white space characters
Using keywords
Using comments
Specifying maps and information objects in Actuate SQL queries
Using identifiers in Actuate SQL
Using column aliases in Actuate SQL
Specifying parameter values
Using subqueries in Actuate SQL
Using derived tables in Actuate SQL
Data types and data type casting
Facets
Casting rules
String comparison and ordering
Functions and operators
Comparison operators: =, <>, >=, >, <=, <
Range test operator: BETWEEN
Comparison operator: IN
Arithmetic operators: +, -, *, /
Numeric functions
FLOOR, CEILING, MOD
ROUND
POWER
Null test operators: is [not] null
Logical operators: and, or, not
String functions and operators
Case conversion functions: UPPER, LOWER
Concatenation operator: ||
Length function: CHAR_LENGTH
LIKE operator
Substring functions: LEFT, RIGHT, SUBSTRING
Trimming functions: LTRIM, RTRIM, TRIM
Search function: POSITION
Timestamp functions
CURRENT_TIMESTAMP
CURRENT_DATE
DATEADD
DATEDIFF
DATEPART
DATESERIAL
Aggregate functions: COUNT, MIN, MAX, SUM, AVG
System function: CURRENT_USER
Providing query optimization hints
Indicating that a table in a join is optional
Using the OPTIONAL keyword with a computed field
Using the OPTIONAL keyword with parentheses ( )
Using the OPTIONAL keyword with aggregate functions
Specifying the cardinality of a join
Using pragmas to tune a query
Disabling cost-based optimization
Disabling indexing
Specifying a threshold value for indexing
Two
Understanding database types
About database types
About connection types
About mappings
About preconfigured database types
DB2 data type mapping and issues
Informix data type mapping and issues
Oracle data type mapping and issues
SQL Server data type mapping and issues
Sybase data type mapping and issues
About configurable database types
How to configure a database type
Working with XML files
Configuring connection types
About configuring connection types
JDBC driver requirements and installation
JDBC driver requirements
Installing a JDBC driver
Working with datasources.xml
Configuring connection types: ConnectionTypes element
Configuring database types: DatabaseTypes element
Mapping data types
About data type mapping
DataTypeMapper element
MaxSize attribute
DataType child element: Aliases
Mapping functions and operators
About mapping functions and operators
About ODBC escape sequences
Disabling the default mapping for a function
Differences between Actuate SQL functions and database functions
About Generic_ODBC mappings.xml
Syntax for mapping functions and operators
Mapping functions and operators: FunctionMapping element
Mapping Boolean operators: BooleanOpMapper element
Mapping comparison operators: ComparisonOpMapper element
Mapping arithmetic operators: ArithOpMapper element
Mapping numeric functions: NumericFuncMapper element
Mapping string functions: BasicStringFuncMapper element
Mapping substring functions: SubStringFuncMapper element
Mapping the LIKE operator: LikeOpMapper element
Example: Mapping the LIKE operator
Mapping DATEPART functions: DatePartMapper element
Mapping date subtraction functions: DateDiffMapper element
Mapping date addition functions: DateAddMapper element
Mapping date serialization functions: DateSerialMapper element
Mapping NULL functions: NullFuncMapper element
Mapping conditional functions: CondFuncMapper element
Mapping aggregate functions: AggrFuncMapper element
Mapping multi-row Boolean operators: MultiRowBoolFuncMapper element
Mapping cast functions: CastFuncMapper element
Using operators in a mapping
Symbolic operators require parentheses
Negative sign must be followed by a space
Less than (<) and greater than (>) symbols must be escaped
Example: Mapping the not-equal-to operator
Example: Mapping the CONCAT function
Example: Mapping the DATEDIFF function
Example: Mapping the CHAR_LENGTH function
Example: Mapping the negative sign (-)
Using initialization statements
Example: Specifying the behavior of concatenation with NULL
Mapping literals and clauses
Mapping literals: LiteralMapper element
Template format for VARCHAR literals
Template format for TIMESTAMP literals
Example: Mapping VARCHAR and TIMESTAMP literals
Mapping clauses
Mapping the ORDER BY clause: OrderByClauseMapper element
Mapping the GROUP BY clause: GroupByClauseMapper element
Working with collations and byte-based strings
Working with collations
About Integration service collations
About database collations
About collation implementations
Specifying the Integration service and database collations
How to specify the Integration service and database collations
Working with byte-based strings