BI And The Web API - 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.

Software // Information Management
03:47 PM

BI And The Web API

BI applications are at the leading edge of the battle between thick desktop and thin Web clients. We track the trends between thick and thin in the world of BI.

Among enterprise applications, BI often leads the way in user interface capabilities. Think of tabular and chart output, pivot tables, and graphic reports on the desktop. Now the Web application programming interface (API), using a variety of tools from XML and JavaScript to Flash, allows BI vendors to deliver desktop-like clients in the more universally accessible Web browser. In effect, BI is on the forefront of the battle between thick and thin clients. It just so happens that BI vendors are adding a lot of user interface muscle to their thin clients so that, like Charles Atlas weightlifters, they don't have to worry about getting UI sand kicked in their faces by PC-based Fat Clients.

BI vendors have been courting the Web browser for the last ten years -- or is it the other way around? A Web browser can deliver BI Reports and output to any machine with an Internet connection. With just HTML formatting using tables, colors, and simple font control, the styling can still be quite a few steps ahead of what can be delivered on even most black and white laser printers. Yet those same HTML reports bypass printing (or allow printing on a few required pages), saving reams of output and speeding up access to data through text search in the browser. BI report output to the Web has seen many advances.

From the late 1980's to the early 1990's, when developing major reporting applications in Information Builders' Focus or in Oracle, it was easy to enhance the output-to-file capability. Thus, in the mid 1990's, the transition to Web output with the appropriate HTML headers and internal tags was trivial. Developers even added logos and background images with light watermark gray dates, "SEP 11TH 1996," for example, in bold across the page. At the same time, BI vendors like Crystal Reports and R&R Reportwriter were delivering charts and graphics to the Web. BI vendors then added sub-report blocks; first in the footers and headers, then embedded right on the page with the major report items. That was quickly followed by output to Excel files and then Adobe PDF -- and it was all automated.

Reports to Excel set a new standard because Excel allowed savvy users to hide columns and rows either by manually clicking with a mouse or with filters. Also the data could be easily cut and pasted into another spreadsheet table for further analysis or graphing/charting. On the high end, PDF output became popular because very high quality reports with embedded fonts and graphics could be shipped over the Web and then delivered by laptop or color inkjet output to decision-makers. The next real step up was customized reports, OLAP output and data mining views, again brought to your desktop in HTML format often as special pivot table applets or ActiveX-aided reports. More recently, Java report-writers like Actuate's new Business Intelligence Reporting Tools (BIRT) open source project are committed to the full set of HTML and Web-based output.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
1 of 3
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.

Remote Work Tops SF, NYC for Most High-Paying Job Openings
Jessica Davis, Senior Editor, Enterprise Apps,  7/20/2021
Blockchain Gets Real Across Industries
Lisa Morgan, Freelance Writer,  7/22/2021
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
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.
Flash Poll