Instant Recognition - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management

Instant Recognition

Actuate's Spreadsheet Designer makes the most of a familiar paradigm.

As much as people hate to admit it, Microsoft Excel is the most widely used tool for collecting and analyzing data, and, given the market share that Microsoft Office enjoys, Excel may also be the most widely used business intelligence (BI) tool on the market. Unfortunately, Excel spreadsheets are difficult to maintain and frequently disconnected from back-end systems — users must enter (and reenter) data in order to analyze and distribute it.

One of the first goals of most BI projects is to cut down on the number of spreadsheets or reports created by hand, and over the years, different vendors have had their own ideas on how best to accomplish this goal. Most vendors have their own tools to design reports that can be distributed to other users in a wide variety of destinations and formats. The only problem with these tools is the learning curve involved in becoming proficient at report design. Other end users will frequently ask that the report be exported back to Excel anyway for further analysis and distribution.

A Familiar Face

Rather than trying to change this paradigm, Actuate is making the most of this trend with e.Spreadsheet Designer, a report design tool that leverages the user's knowledge of Excel to create feature-rich reports in a familiar interface, with menus, tools, and icons that mimic Excel's.

In addition, you can open existing Excel spreadsheets within e.Spreadsheet Designer and use these spreadsheets as a template for creating reports based on a data source instead of manual data entry. (See Figure 1.) This feature can help eliminate the discontent that users sometimes feel when their Excel spreadsheets are replaced with a proper reporting solution. Instead of a specification for a new report created from a new toolset, users can keep their existing spreadsheets and have them tied directly into back-end systems.

Product Spec Sheet

e.Spreadsheet Designer 10

Actuate Corp.
701 Gateway Blvd.
South San Francisco, CA 94080
888-422-8828 or 800-914-2259
www.actuate.com

Minimum System Requirements: Windows 98, Windoes NT 4.0, Windows 2000, Windows XP Pro with a Pentium 450 or higher, 128MB RAM, 100MB free disk space.

Pricing: Pricing for Actuate 7 starts at $35,000 per CPU, e.Spreadsheet Designer starts at $495 per named user.

Installing e.Spreadsheet Designer is quick and easy, and when you first open the application you may do a double take as the interface looks so similar to Microsoft Excel. There are a number of tutorials in both the printed and online documentation, but you'll find that after the first few steps required to connect to your data source, you'll be able to speed along with the rest of the report design process unaided. The formatting tools are similar to the ones you would find in Excel, and since the majority of report design time is spent arranging fields and formatting data, the common interface will have you up to speed quickly.

The easiest way to get started creating reports is through the Report Range Wizard, which will take you step-by-step through creating a connection to your database, building a SQL query, and setting some basic formatting options. The e.Spreadsheet Designer supports a wide variety of data sources through ODBC, JDBC, text files, and XML.

Making a Connection

If you attempt to connect to an ODBC data source, you'll receive a warning message explaining how the e.Spreadsheet Designer connects to ODBC data sources. The product uses an ODBC-JDBC bridging utility from Sun Microsystems, and Actuate recommends using only ODBC for report development. In order to deploy your report to a production environment, you'll need to obtain and configure the appropriate JDBC driver. This is a potential hurdle, as a number of application and database providers that provide ODBC drivers don't have JDBC drivers available.


Figure 1 A typical report created using an existing spreadsheet format.

Once you have created a connection to your data source, the Report Range Wizard will walk you through selecting the tables and fields for your report, as well as creating any filters you want to add to limit the records that are returned to your report. The e.Spreadsheet Designer also lets you add parameters to a report. But the process of creating and using parameters is not intuitive, and it will take some effort to understand how they work.

You can also use the Report Range Wizard to select the grouping and sorting that you want to appear in your report, as well as any sub- or grand totals. The final steps of the wizard let you select a layout and style for your report, again cutting down on the time you'll need to spend formatting your report.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Previous
1 of 2
Next
Comment  | 
Print  | 
More Insights
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

News
Remote Work Tops SF, NYC for Most High-Paying Job Openings
Jessica Davis, Senior Editor, Enterprise Apps,  7/20/2021
Slideshows
Blockchain Gets Real Across Industries
Lisa Morgan, Freelance Writer,  7/22/2021
Commentary
Seeking a Competitive Edge vs. Chasing Savings in the Cloud
Joao-Pierre S. Ruth, Senior Writer,  7/19/2021
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Monitoring Critical Cloud Workloads Report
In this report, our experts will discuss how to advance your ability to monitor critical workloads as they move about the various cloud platforms in your company.
Slideshows
Flash Poll