Visualizing the Impact of Database Changes with BIRT and ActuateOne
Posted by
mwilliams
, 17 January 2013 - 12:50 PM
To help soften the blow, Actuate 11SP4 introduces new Impact and Dependency Analysis capabilities. This allows the developer to identify what applications and content must be updated with the change to the database schema, giving a much clearer picture on the cost and resources needed to complete the update, before it even begins. Additionally, such analysis allows the development team to easily identify which BIRT designs depend upon certain libraries, Information Objects, or Data Object, to easily assess the impact of updating or removing these resources.
The Database Search also allows BIRT developers to easily identify files that use and are dependent on the selected database component. With a couple clicks of the mouse, a BIRT developer can access a diagram, showing the dependency tree, for the project. The diagram also highlights the dependency path from the selected BIRT item, to all other items that would be affected by a change to this element.
The dependency Impact Analysis view can also be invoked by clicking on any file in the Outline view of the BIRT designer, such as a BIRT design, a Data Object, an Information Object, BIRT Library, etc. This gives the developer another way to access the dependency analysis information for a given file, before making any changes.

Another new feature, in Actuate 11SP4, is the ability to create and preview Information Objects within BIRT Designer Pro, rather than having to deploy them to a BIRT iServer as part of the authoring process. BIRT developers will still have the familiar experience they're used to, when creating the Information Object, they just no longer have to specify an iServer, though, Information Objects published to an iServer will still be available when creating designs, just like in the past. Also, to make things easier on the developer, report designs and Information Objects no longer have to be created in separate projects, allowing the BIRT developer to create Information Objects and the designs that consume them, at the same time, as part of the same project.
Publishing to your BIRT iServer, in Actuate 11SP4, has also been made easier, providing a single BIRT Designer Pro dialog for publishing your designs and resources. The dialog allows BIRT developers to choose the files they'd like to publish and also choose whether or not they should overwrite the previous version, if it exists, already, on the server. Publishing to the iServer isn't the only thing that's gotten simpler. BIRT Designer Pro also provides a new download dialog to download published or user created content, for re-use or enhancement.
Next time, I'll show how Actuate 11SP4 enhances the usability of the BIRT product line. In the meantime, download a free trial version of Actuate BIRT iServer and BIRT Designer Pro, to check it out for yourself.
Actuate's 11SP4 Release Provides Many Powerful New Capabilities, Including HTML5 Charts and more!
Posted by
mwilliams
, 30 October 2012 - 05:15 PM
- HTML5 charts to enable consistent user experience and enhanced interactivity across conventional and mobile platforms
- New data source types, such as, Hadoop and Salesforce.com
- Impact and dependency analysis to ease develpment and management of applications
- Simplified publishing to the BIRT iServer
- Performance Optimization in BIRT Studio and Information Objects
- Relative time period support, enabling more powerful and dynamic comparisons across time
- and more...
One of the more major enhancements, of the bunch, is that all commonly used BIRT chart types now support HTML5 output format, along with the existing formats, SVG, JPG, PNG, and BMP. Catching your user's attention will be easier than ever with the out-of-the-box animation effects and new levels of interactivity. Custom animation effects and interactivity can also be defined, through scripting, making being forced to rely on pre-determined visualizations, a thing of the past.
Adding an HTML5 chart to your report is easy. Simply drag a chart from the palette, into your report layout, as you've always done. Only, choose HTML5 from the dropdown, instead of one of the other supported formats. Upgrading charts to HTML5, from one of the existing formats can be done by changing this same setting.
Making this change exposes the HTML5 chart specific properties, allowing you to preview the chart animation effects in the preview window of the chart builder. A script tab is now present in the chart builder, where custom animations, for HTML5 charts, are scripted. This script tab is also available with the other formats, for convenience of seeing everything in one place. Starting in 11SP4, theme functionality is available for all chart-specific formatting properties, like legend formatting, chart title formatting, etc. These themes can be used across all charts to give a common look/feel to your BIRT visualizations. The themes can also be exported to a library for reusability.
Next time, I'll detail how developer productivity will get a boost with Actuate 11SP4. In the meantime, download a free trial version of Actuate BIRT iServer and BIRT Designer Pro, to check it out for yourself.
Last Week in the Forums: Using the Same Masterpage for All Reports, Stopping SQL Execution when You Don't Want to Display Your Sub Report, and more...
Posted by
mwilliams
, 03 October 2011 - 06:42 AM
The first topic I'll cover from the past week's posts is how to use the same masterpage across multiple reports. In many instances, your reports you make will all have the same page size and page header and footer information. Rather than making the same masterpage over and over again, BIRT allows you to store a masterpage in a report library. You can then attach this library to all of your reports and use the masterpage. If you need to make changes in the masterpage for all of your reports, you don't need to change each individually. A change to the masterpage in your library will be inherited by all reports that use this library masterpage. Another option suggested in the thread would be to create a template that has this masterpage linked in it so that the report developer has this masterpage from the start.
The second topic we'll cover this week is preventing your SQL from running when you don't display your subreport. If you have a parameter that decides whether you want to show detail information that is in a subreport, you don't have to just hide the table. If you know you want to hide a table by a parameter, you can simply drop the table from the design in your beforeFactory method and the database will not be accessed. The code to do this is shown in the forum thread.
The last topic for this week is changing the title of the report viewer. If you're looking to change the title of the BIRT viewer, you can simply use the url parameter __title to set whatever value you'd like. If you'd like another option, you can go into the viewer's FramesetFragment.jsp page and change the title value there.
Again, this is just a small sample of what went through the forums this past week. For more questions and answers that have been posted, check out the forums. As always, if you have a question, feel free to ask it, and if you see a question you know the answer to or have a similar experience to, feel free to post an answer or comment.
Recent Entries
Creating Derived Cube Measures and More with BIRT and ActuateOne
Drop Elements Depending on Output Format
Solving a TOC Bookmark Issue by Using Multiple Fields in a Single Group Expression
Visualizing the Impact of Database Changes with BIRT and ActuateOne
Actuate's 11SP4 Release Provides Many Powerful New Capabilities, Including HTML5 Charts and more!
Getting a Marker in the Middle of a Gantt Chart Bar, Multi-Level HTML List Numbering, and more...
Switch to a Default Table if no Values Returned in Query, Parameterize the From Portion of an SQL Query, and more...
Adding Text to an Image, Using Table Data for a Crosstab's Data, and more...
Only Highlight Bars of a Certain Series in a Chart, Reordering a Table's Columns, and more...
My Blog Links
Recent Comments
- mwilliams on Drop Elements Depending on Output Format
- donino on Drop Elements Depending on Output Format
- mwilliams on Creating a BIRT report as a calendar view
- lnallamalli on Creating a BIRT report as a calendar view
- For Birt on Last Week in the Forums: BIRT and R Statistical Language, Specified Sort Order for a Table, and more...
- Bhanwar on Last Week in the Forums: Filtering Blank Spaces from Distinct Count Aggregation, Adding a Line at 0 in a Chart with Negative Values, and more...
- Srividya Sharma on Sorting a Crosstab by a Field Not Displayed in the Crosstab
- mwilliams on Last Week in the Forums: Using the Concatenate Aggregate, Hiding a Column When There is No Data, and more...
- java032 on Last Week in the Forums: Using the Concatenate Aggregate, Hiding a Column When There is No Data, and more...
- java032 on Last Week in the Forums: Using the Concatenate Aggregate, Hiding a Column When There is No Data, and more...
0 user(s) viewing
0 member(s)
0 anonymous member(s)
Categories
- .rptdocument
- 11 SP4
- Actuate
- ActuateJavaComponent
- ActuateOne
- aggregating data
- aggregation
- alignment issues
- Alternating Highlight
- archived BIRT versions
- area chart
- axis label
- barcodes
- batch file
- BDPro
- BIRT
- BIRT Exchange
- BIRT functions
- BIRT Studio
- BIRT-Exchange
- bookmarks
- border
- border color
- bursting
- calendar
- cascading parameter
- CEAPI
- cell border
- chart
- charting
- charts
- color
- color codes
- command line
- computed column
- connection profile
- contest
- crosstab
- CSS
- CSV
- CSV export
- custom group
- custom sort
- Data Analyzer
- data cube
- Data Object
- data point label spacing
- data row security
- data set filter
- data set parameters
- dataset parameters
- Date Format
- deapi
- deploy
- devShare
- display name
- drop
- drop series
- dynamic chart
- dynamic chart labels
- dynamic chart marker
- dynamic chart scale
- dynamic chart title
- dynamic column sort
- Dynamic Column Visibility
- dynamic data set
- dynamic grid content
- dynamic grouping
- dynamic labels
- dynamic min/max
- dynamic scale
- Dynamic Text
- Dynamic Width
- Eclipse
- elapsed time format
- embedded grid
- empty csv error
- Event Handlers
- exception handling
- export data
- expression builder
- filter
- Firefox
- flash map
- Forum
- Forums
- fragmented schema
- gantt
- gantt chart
- global function
- GMT date
- grids
- group numbering
- grouping
- hide label
- hide measure detail
- hide series
- Hierarchy
- hierarchy report
- highlight
- highlight negative numbers
- HTML
- HTML listbox
- html lists
- HTML select form
- HTML Table
- HTML5
- https
- hyperlink
- image
- Impact Analysis
- Import Elements
- Ineractive Viewer
- Information Objects
- Interactive Viewer
- invalid dates
- iServer
- JAX-WS
- joint data set
- jquery
- jsapi
- JSF
- JSP
- legend
- legend color
- Library
- line height
- locale
- localization
- marker range color
- master page
- masterpage
- Maximo
- merge data
- multi-line text
- multi-select parameter
- multi-select parameters
- multi-value parameter
- multiple series
- NetWeaver
- newspaper
- newspaper layout
- optional y-series grouping
- osgi
- overlaying elements
- page break
- parameter
- parameters
- parameters in query
- PDF Complete
- Perl
- Pie Chart
- plug-in
- postgresql encoding issue
- progress bar
- property file
- R Statistical Language
- refresh report
- relative path
- reorder table
- report engine
- report viewer title
- reporting
- Reports
- Rolling Sum
- rotated text
- rptdesign
- rptlibrary
- runtime
- scatter plot
- script
- scripted dataset
- scroll bars
- Seam
- secure connection
- series color
- series name
- session variable
- sort
- Sort Order
- SP4
- special characters
- SQL
- SQL injection
- stacked bar
- stored procedure
- Styles
- Sub Report
- summing values from two different elements
- SVG
- table
- table footer
- Themes
- TOC
- TOC with page numbers
- tomcat
- Tooltip
- transient report cache
- truncated text
- user parameters
- Vaadin
- value-of format
- version features
- Viewer
- viewer title
- visibility
- Web Service
- web viewer
- Webshpere
- Word
- xls
- XML data source


