pocOLAP - the little OLAP project / News: Recent posts

"poco" (Spanish & Italian for "little") OLAP provides a web-based, crosstab reporting tool for your datawarehouse. While it's not an OLAP server or full fledged data mining solution, pocOLAP makes your data easy to use and understand ... for free!

Version 0.2.1 adds the following functionnalities:
- New design for the application
- Xls export
- Possibility to use the same database for measures and filters
- New layout for the pivot table in order to make it more readable: grouping of identical columns, spans in row headers
- Simplified way of managing filters (limited the process to just one interface instead of 2)
- Possibility to have cumulate sums... read more

"poco" (Spanish & Italian for "little") OLAP provides a web-based, crosstab reporting tool for your datawarehouse. While it's not an OLAP server or full fledged data mining solution, pocOLAP makes your data easy to use and understand ... for free!

Version 0.2.1 adds a new selection on the main report page titled "Select Format". This offers users the ability to generate a PDF file of the information in the report grid. Four styles are available for users to choose from. Administrators can choose to enable, or disable, this feature. Thanks to Rashmi for adding this functionality!... read more

"poco" (Spanish & Italian for "little") OLAP provides a web-based, crosstab reporting tool for your datawarehouse. While it's not an OLAP server or full fledged data mining solution, pocOLAP makes your data easy to use and understand ... for free!

Version 0.2.0 represents significant improvements over version 0.1.0. Logging, saved reports, many bug fixes and UI improvements make 0.2.0 suitable for use in production settings. Most of the new features can be seen at our live demo site (http://www.pocolap.com:8080/pocolap/ReptPage.jsp).... read more

"poco" (Spanish & Italian for "little") OLAP provides a web-based, crosstab reporting tool for your datawarehouse. While it's not an OLAP server or full fledged data mining solution, pocOLAP makes your data easy to use and understand ... for free!

This version adds the ability to save reports, allowing users to select a full crosstab report (complete with drilldowns and filters) with a single click. You can also add icons to your reports without having to put them inside the application - simply drop them into a directory, add a tag to the report definition, and you've got graphics! Very easy and very cool!... read more

"poco" (Spanish & Italian for "little") OLAP provides a web-based, crosstab reporting tool for your datawarehouse. While it's not an OLAP server or full fledged data mining solution, pocOLAP makes your data easy to use and understand ... for free!

Version 0.1.6 allows adding report descriptions and links to external pages (to a home page or help file) within crosstab definition files. And with a new Admin.jsp that allows you to reload definition files on the fly, you no longer need to restart the application to have changes available to your user. ... read more

"poco" (Spanish & Italian for "little") OLAP provides a web-based, crosstab reporting tool for your datawarehouse. While it's not an OLAP server or full fledged data mining solution, pocOLAP makes your data easy to use and understand ... for free!

This version contains many internal changes, including a new parsing mechanism of the crosstab definition files. We are now using XMLBeans. This means a few minor changes to crosstab definition files you are using with previous versions. Take a look at the CHANGES.txt file for more information.... read more

"poco" (Spanish & Italian for "little") OLAP provides a web-based, crosstab reporting tool for your datawarehouse. While it's not an OLAP server or full fledged data mining solution, pocOLAP makes your data easy to use and understand ... for free!

Installing the application is a breeze. Unzip and within minutes, you'll have a web based crosstab application serving information from one of two sample databases (HSQLDB and Derby). ... read more

"poco" (Spanish & Italian for "little") OLAP provides a web-based, crosstab reporting tool for your datawarehouse. While it's not an OLAP server or full fledged data mining solution, pocOLAP makes your data easy to use and understand ... for free!

Installing the application is a breeze. Unzip and within minutes, you'll have a web based crosstab application serving information from one of two sample databases (HSQLDB and Derby). ... read more

"poco" (Spanish & Italian for "little") OLAP provides a web-based, crosstab reporting tool for your datawarehouse. While it's not an OLAP server or full fledged data mining solution, pocOLAP makes your data easy to use and understand ... for free!

Installing the application is a breeze and features two sample databases (HSQLDB and Derby). You can connect up just about any JDBC enabled database to pocOLAP by creating an xml file that descibes your data structure. ... read more

Version 0.1.1 has been released. Unfortunately, due to a known issue at SourceForge, the file is not available for download from our project page. If you would like a copy, please email todd_run at yahoo dot com.

The new release includes an additional sample database implemented in Derby. This is the beginning of an "internal database" that will be used for upcoming features.

If you are using an older version of pocOLAP, all configuration files will continue to work. You will need to update your web.xml file however, as all whs_ parameters should be defined for the ConfigurationServlet instead of XTabMain.

Rashmi Banthia has joined the pocOLAP team. Rashmi will initially be working on incorporating logging into the project. For background information on our newest members qualifications, you can find a resume at www.geocities.com/b_rashmi

Welcome Rashmi!

Version 0.1.0 has been released. See the live demo to see the new look and feel.

CVS also contains new documentation which will make using pocOLAP easier. We hope to add this information to our website soon.

Thanks to everyone involved for helping to get this version completed and released!

Roderic Campbell is the newest addition to the pocOLAP team. Roderic is planning on updating our javadoc comments prior to our next release.

Welcome Roderic!

On a related note, Srilatha has other obligations that restrict the time available for our project, and has therefore decided to leave us.

This is a bug fix release, fixing a problem with selecting the same table for columns and rows (which first appeared in 0.0.4a). There are also additional corrrections to the sample database.

Apparently, HSQLDB uses 0 as the first digit when assigning identity values. This caused inconsistant data that wasn't noticed until recently. This release fixes that issue.

As was the case with 0.0.4a, this release contains a lot of changes that are incomplete and contains some know bugs. Use 0.0.4b for testing and to help identify bugs, but it is recommended that you not use it for production. If you need a version suitable for production, either wait for version 0.0.5 (should be out by the end of June???) or email one of the developers and we'll get you a copy of 0.0.4.

It was recently discovered that boolean values in the sample database were not being properly recognized when filters were used. Therefore, this release replaces those sample database files.

There is actually a lot of code that has been updated, but not completely incorporated. If you are using pocolap version 0.0.4 with your own database (in other words, you don't care about the sample database), you may want to continue using that. On the other hand, testing 0.0.4a would be extremely helpful - just make sure you let one of the developers know if you find a problem.

Version 0.0.4 has been released, fixing a bug that caused an exception in certain situations where fields contained empty strings.

One of the biggest opportunities for improving pocOLAP is the GUI. We'd like to welcome Nicole as a new project member who has provided direction and inspiration for finding a new front end design for our cross tab viewer. Look for design samples and changes to the application to start appearing soon!

Release 0.0.3 has been released. Instead of having to run install scripts to set up a sample database, or change configuration files to fit your environment, we've made installation much easier. Simply unzip the distribution, place the war file in your web server and copy a couple of files to either "/tmp" or "C:/", and you've got pocOLAP set up with the sample database.

Installation instructions are included in the distribution. All source code is available through CVS.

Go to the Home Page and click "Go to the Live Demo!" link. This will take you to the Mycgiserver site that hosts a live version of pocOLAP. The demo currently uses a very small set of data, but it shows how pocOLAP appears to an end user.

Please note: Mycgiserver is a free/low cost hosting service for Java/J2EE applications. They don't promise 100% uptime, so the demo may not be available at all times. We still consider Mycgiserver to be an invaluable provider - without them, the live demo would never have been possible.

pocolap-express makes installing pocOLAP a breeze. Instead of requiring you to set up and configure a database in MySQL, pocolap-express comes with HSQLDB and database files in the distribution. Just copy the war file to your webapps directory, change a couple of text files, and you'll get a taste of what pocOLAP can provide.

This release does not include any source code, but everything is available in CVS. It is not clear whether future releases will be restricted to pocolap-express - if you have any opinion, please let us know!

pocOLAP version 0.0.2 has been released. This features more filtering options and some minor fixes. There are also some conversion tools intended for use with the MCS live demo.

In an attempt to create a live online demo of the application, a deployment was planned on mycgiserver (MCS), a free J2EE hosting service. During preparation, it was announced that MCS could no longer provide free space. Then it was announced that, with the help of JavaLobby, the free space would continue.

So deployment plans that were put on hold were once again activated. After converting the database scripts to work with HSQLDB (first to version 1.7.1, then to the required 1.6.1), uploading the database files and testing the user permissions, it was discovered that the free space is a "shared" application. Basically this boils down to no WEB-INF directory, which means no custom tags. In short, there's no way pocOLAP will run in such a restrictive environment.... read more

Version 0.0.1 has been released. This is bare bones and really rough, but it should be stable.

CVS stats don't appear to be updating correctly, but new code is being added - you can get updated content from CVS at any time.