About Using Actuate BIRT Designer Professional
Accessing data
Supported data sources
How a report accesses data
Creating data objects
About data objects
Design considerations
Designing data objects for dashboards
Designing data objects for reports created with Actuate BIRT Studio
Designing data objects for reports created with Actuate BIRT Designer
Building a data object
How to create a data object
Creating new items for a data object
Exporting items to a data object
How to export data items to a data object
Creating a shared dimension for cubes
How to create a shared dimension
How to convert a cube dimension into a shared dimension
Configuring data set columns for summary tables
How to set the analysis type of a data set column
Creating hyperlinks to provide drill-down capability
How to create a hyperlink from a data set column
How to create a hyperlink from a dimension or measure in a cube
Hiding data sets from users
How to hide data sets from users
Providing cached data
How to create a data object store
Publishing a data object
How to publish a data object in an iHub volume
Enabling incremental updates
How to enable incremental updates
How to apply incremental updates to a .data file stored in the file system
Managing user access
Maintaining a data object
Accessing data in a data object
Using data object data in a report
Connecting to a data object
How to connect to a data object
Specifying the data to retrieve from a data object
How to specify what data to retrieve from a data object
Using a cube in a data object
How to use a cube in a data object
Accessing data in an information object
Using information object data in a report
Connecting to an information object
How to connect to an information object
Specifying the data to retrieve from an information object
How to specify what data to retrieve from an information object
Accessing data in a report document
Using report document data
Creating a report document
Specifying bookmark names
How to specify a bookmark name
Specifying element names
How to specify an element name
Connecting to a report document
How to connect to a report document
Specifying the data to retrieve from a report document
How to retrieve data from a report document
Accessing data in an e.report
Using ActuateOne for e.Reports Data Connector
About ActuateOne for e.Reports Data Connector functionality
Accessing an e.report using Page Level Security
Accessing an e.report having multiple sections
Connecting to an e.report
How to create an ActuateOne for e.Reports data source
Specifying the data to retrieve from an e.report
How to create an ActuateOne for e.Reports data set
Accessing data in Amazon DynamoDB
Using Amazon DynamoDB data in a report
Connecting to Amazon DynamoDB
How to create an Amazon DynamoDB data source
Specifying the data to retrieve from Amazon DynamoDB
How to specify what data to retrieve from an Amazon DynamoDB database
Filtering data
Filtering by a composite primary key
Filtering by an attribute
Accessing data in Amazon Relational Database Service
Using Amazon RDS data in a report
Connecting to Amazon RDS
How to create a Amazon RDS data source
Specifying the data to retrieve from Amazon RDS
How to specify what data to retrieve from a database in Amazon RDS
Accessing data in Salesforce.com
Using Salesforce.com data in a report
Connecting to Salesforce.com
How to create a Salesforce.com data source
Specifying the data to retrieve from Salesforce.com
How to specify what data to retrieve from a database in Salesforce.com
Combining data from multiple data sources
Ways to combine data
Creating a union data set
How to create a union data set
Creating a joined data set
How to create a joined data set
Joining on more than one key
Specifying a join condition not based on equality
Formatting a report
Formatting features in Actuate BIRT Designer
Removing the default themes
Hiding columns in a table
Using a Quick Response (QR) code to link to content
Designing for optimal viewer performance
Building HTML5 charts
About HTML5 charts
Comparing HTML5, Flash, and BIRT charts
Rendering platform
Creating an HTML5 chart
Formatting an HTML5 chart
Applying a chart theme
Creating a chart theme
Creating a general chart theme
How to create a general chart theme
Creating a JavaScript chart theme
How to create a JavaScript chart theme
Writing event handlers
Writing event handlers that respond to user interactions
Writing event handlers that respond to chart events
About the HTML5 chart events
Setting chart options through scripting
Scripting example 1
Scripting example 2
Scripting example 3
Using Flash objects in a report
About Flash
Software requirements
Ways to add Flash objects in a report
Output formats that support Flash
Using built‑in Flash charts and gadgets
About Flash charts and gadgets
Creating a Flash chart and gadget
Formatting a Flash chart
Formatting a Flash gadget
General properties
Scale properties
Needle properties
Needle base or pivot properties
Number formatting properties
Region properties
Tick properties
Threshold properties
Anchor properties
Plot properties
Value indicator properties
Tooltip properties
Font properties
Padding and margin properties
AddOn properties
Using animation and other visual effects
Creating effects
How to create an effect
How to apply an effect to multiple parts in a chart or gadget
Managing effects
Animation effect
Bevel effect
Blur effect
Font effect
Glow effect
Shadow effect
Tutorial 1: Creating a Flash chart
Task 1: Create a new report
Task 2: Build a data source
Task 3: Build a data set
Task 4: Add a Flash chart to the report
Task 5: Select data for the Flash chart
Task 6: Animate the x-axis labels
Task 7: Animate the y-axis labels
Task 8: Change the animation effect of the columns
Tutorial 2: Creating a Flash gadget
Task 1: Add a Flash gadget to the report
Task 2: Select data for the linear gauge
Task 3: Divide the data area into regions
Task 4: Add thresholds
Task 5: Animate the region labels
Task 6: Animate the sales value
Task 7: Add a glow effect to the needle
Limitations
Using the Flash object library
About the Flash object library
About Flash charts
About Flash gadgets
About Flash maps
About Flash power charts
Flash object components
Inserting a Flash object in a report
How to insert a Flash object
Providing data to a Flash object
Generating the XML data
Using the dataXML variable to pass XML data
How to use the dataXML variable to pass data to the Flash object
Using the dataURL variable to pass XML data
How to use the dataURL variable to pass data to the Flash object
Using the Flash object library documentation
Tutorial 3: Creating a Flash map that gets data through the dataXML variable
Task 1: Create a new report
Task 2: Build a data source
Task 3: Build a data set
Task 4: Find a suitable Flash map
Task 5: Review the map specifications
Task 6: Map the data set values to the Flash map entity values
Task 7: Add the Flash map to the report
Task 8: Generate an XML data string
Task 9: Create the dataXML variable and pass the data
Task 10: Format the Flash map
Display sales values in a more readable format
Building the XML string in readable pieces
Change the colors used in the map
Define data ranges and apply different colors to each range
Create city markers
Tutorial 4: Creating a Flash chart that gets data through the dataURL variable
Task 1: Create a new report
Task 2: Build a data source
Task 3: Build a data set
Task 4: Add a Flash chart to the report
Task 5: Create a plug-in
Task 6: Define an extension
Task 7: Create a Java class
Task 8: Implement methods in the class
Import the required packages
Implement the initialize( ) method
Implement the output( ) method
Implement the release( ) method
Task 9: Deploy the plug-in
Task 10: Create the dataURL variable
Debugging a Flash object
Using the Flash object’s debug mode
How to enable debug mode
How to disable debug mode
Resolving errors
Writing expressions using EasyScript
About EasyScript
Choosing between EasyScript and JavaScript
Syntax rules
Using the EasyScript expression builder
Changing the default expression syntax
Functions
ABS( )
ADD_DAY( )
ADD_HOUR( )
ADD_MINUTE( )
ADD_MONTH( )
ADD_QUARTER( )
ADD_SECOND( )
ADD_WEEK( )
ADD_YEAR( )
BETWEEN( )
CEILING( )
DAY( )
DIFF_DAY( )
DIFF_HOUR( )
DIFF_MINUTE( )
DIFF_MONTH( )
DIFF_QUARTER( )
DIFF_SECOND( )
DIFF_WEEK( )
DIFF_YEAR( )
FIND( )
IF( )
IN( )
ISNULL( )
LEFT( )
LEN( )
LIKE( )
LOWER( )
MATCH( )
MOD( )
MONTH( )
NOT( )
NOTNULL( )
NOW( )
QUARTER( )
RIGHT( )
ROUND( )
ROUNDDOWN( )
ROUNDUP( )
SEARCH( )
SQRT( )
TODAY( )
TRIM( )
TRIMLEFT( )
TRIMRIGHT( )
UPPER( )
WEEK( )
WEEKDAY( )
YEAR( )
Operators
Specifying filter conditions at report run time
About report parameters and filters
Enabling the user to specify a filter condition
Creating a dynamic filter report parameter
How to create a dynamic filter report parameter
Making a filter parameter optional
Accepting multiple values
Creating a dynamic filter
How to create a dynamic filter
Getting information about queries
Displaying cross tab data by relative time periods
About relative time periods
Aggregating data by a relative time period
How to aggregate data by a relative time period
Examples of relative time period aggregations
Supported time periods
Using the * to Date and Trailing N * time periods
Adding HTML buttons to a report
About HTML buttons
Creating an HTML button
How to create an HTML button
Writing code for an HTML button
Accessing report data
How to add a variable to an HTML button
Using the Actuate JavaScript API
Testing an HTML button
Changing the appearance of an HTML button
How to change the name or value of an HTML button
Controlling user access to report pages and data
About the security model
About access control lists (ACLs) and security IDs
ACL expression syntax
Controlling user access to report pages
Adding page-level security to a report
Enabling and disabling page-level security
How to turn page-level security on or off
Configuring page numbers
How to configure page numbers
Testing page-level security
How to test page-level security
Controlling user access to data
Adding security to a data object
Adding security to a data set
Adding security to a cube
Enabling and disabling data security
How to turn data security on or off
Testing data security
How to test data security in a report in Actuate BIRT Designer
Accessing iHub environment information
Writing event handlers to retrieve iHub environment information
Writing a JavaScript event handler
Writing a Java event handler
About the serverContext object
JavaScript event handler example
Java event handler example
Debugging event handlers that use the iHub API
iHub API reference
appendToJobStatus( )
getAuthenticationId( )
getServerWorkingDirectory( )
getUserAgentString( )
getUserRoles( )
getVolumeName( )
setHeadline( )
setVersionName( )
Performing impact analysis
About impact analysis
Searching for database items used in BIRT objects
How to search for files that use a specific database, table, or column
Identifying the files impacted by a BIRT object
Viewing the relationships among files in a project
Assessing the impact of changes in an Actuate BIRT iHub volume
How to create a new iHub profile
How to download content from an iHub volume
Deploying BIRT reports to iHub
About deploying BIRT reports
Publishing a report to iHub
How to create a new iHub profile
How to publish a report design to iHub
Publishing a report resource to iHub
How to change the Resource folder on an Encyclopedia volume
How to publish a resource from the Resource folder to iHub
Deploying Java classes used in BIRT reports
How to configure BIRT reports and deploy a JAR file to an Encyclopedia volume
How to deploy a JAR file to an iHub /resources folder
Installing a custom JDBC driver
Installing custom ODA drivers and custom plug-ins
Configuring data source connections in iHub
About data source connection properties
Using a connection profile
Creating a connection profile
How to create a connection profile using Data Explorer
How to create a connection profile from Data Source Explorer
Managing a connection profile
Exporting connection profiles
How to export a connection profile
Importing connection profiles
How to import a connection profile
Editing connection profile properties
How to edit connection profile properties
Deploying a connection profile
Encrypting connection profile properties
Binding connection profile properties
Binding Connection Profile Store URL property
Binding a connection profile name to a report parameter
How to bind Connection Profile Store URL property to a report parameter
Using a connection configuration file
Setting up the connection configuration file
Understanding how iHub uses the connection configuration file
Setting the location of a connection configuration file
How to set up a configuration file in iHub Configuration Console
Encrypting the connection properties
How to encrypt a configuration file in BIRT Designer
Externalizing the connection profile properties on the iHub
Understanding externalization precedence
Referencing an external connection profile
Accessing the BIRT report design and BIRT resource path in custom ODA plug‑ins
Accessing resource identifiers in the run-time ODA driver
Accessing resource identifiers in the design ODA driver
Configuring fonts in iHub
About configuring fonts
Understanding font configuration file priorities
Understanding how the BIRT engine locates a font
Understanding the font configuration file structure
<font-aliases> section
<composite-font> section
<font-paths> section
Working with BIRT encryption in iHub
About BIRT encryption
About the BIRT default encryption plug-in
About supported encryption algorithms
About the components of the BIRT default encryption plug-in
About acdefaultsecurity.jar
About encryption.properties
About META-INF/MANIFEST.MF
About plugin.xml
Creating a BIRT report that uses the default encryption
Deploying multiple encryption plug‑ins
How to create a new instance of the default encryption plug‑in
Deploying encryption plug-ins to iHub
How to deploy a new encryption plug‑in instance to iHub
Generating encryption keys
How to generate a symmetric encryption key
How to generate a public key using RSA encryption
Creating a custom encryption plug‑in
Using encryption API methods
Using custom emitters in iHub
About custom emitters
Deploying custom emitters to iHub and Information Console
Rendering in custom formats
How to deploy a custom emitter to iHub
How to deploy and use a custom emitter in Actuate BIRT Designer
How to export a BIRT report in iHub Management Console
How to export a BIRT report from Information Console or iHub
How to export a BIRT report from Actuate BIRT Viewer or Actuate BIRT Interactive Viewer
Configuring the default export options for a BIRT report
Using the BIRT data object API
About generating data objects from an application
Generating data object elements for BIRT report designs
Creating data object data sets for BIRT report designs
Creating data object data cubes for BIRT report designs
Tutorial 5: Creating a data element using the Design Engine API
Task 1: Set up a project
Task 2: Create a GenerateDataObject Java class
Task 3: Create the main( ) method to test the code
Task 4: Run the code
About Using Actuate BIRT Designer Professional
Run the code
operators