Reporting & Coghead
by Greg Olsen
Ever since there have been database applications they have served two roles:
- a transaction processing system: an operational system of record that manages a central information repository and that controls additions, deletions, and modifications to the repository.
- a system for reporting and analysis: a system used to examine generated data to help people understand what it means.
Sometimes these two roles overlap - e.g. simply looking at a list of sales orders sorted by date or value provides useful analytical information regarding sales activity. Often, however, reporting and analysis needs are very different from transaction processing needs, and require separate capabilities. The whole point of a transaction processing system is to be always 'up to date' and to support read, write, and delete access to the information. For reporting and analysis we look at information with respect to a particular point in time or period of time, focus only on read access to the information, and often need to look at very large volumes of data all at once.
Improving and expanding the reporting and analysis capabilities of the Coghead service is a key area of focus for us over the next several months.
Here is how people are currently using Coghead to meet their reporting and analysis needs:
- use the native form/view/collection features: by using calculated and aggregate fields, collection linking, and customized actions people are able to merge many basic data analysis needs directly into the transactional systems they are building. There are limits to this approach, however, as performance optimization for operational needs and reporting & analysis needs are typically at odds.
- extract data from Coghead into a desktop application: people use the Excel and Word addins to extract data from their Coghead accounts and then use those products to display, print, or analyze the data.
- extract data from Coghead into a server-based 'business intelligence' system: some Coghead users already use high-powered business intelligence products from vendors like Cognos or Business Objects and extract data from Coghead for use in those products.
Here is what we're planning to release in the very short term (4 to 8 weeks):
- an improved 'print from Coghead' capability: We are adding the ability to upload customized templates to Collections, and then to print reports directly from the browser.
- an improved external API: Release of our API and the documentation will make it much easier for people to extract information from Coghead for use in various reporting solutions.
Here is what is going to start arriving in the next 2 to 4 months:
- improved query flexibility: e.g. better ability to group and organize results.
- analysis-optimized Collections: the ability to create separate collections specifically optimized for analysis & reporting needs
- expanded set of reporting-oriented widgets: this includes graphs and charts and other data visualization oriented widgets.
- better integration to 3rd party business intelligence products: we will be adding features to make it easier to integrate to on-premise BI products and to some of the BI services that have recently come on the market.
In summary, improving the native reporting and analysis capabilities of the Coghead platform is a very high priority on our roadmap, and many new capabilities will be arriving soon. The general category of 'reporting and analysis' capabilities, however, is extremely large and we need your continued feedback to help us understand which features are most important to you.







