Does anyone know of a OLAP product that works with MySQL. I read a news story about DAT-A, but can't find further info.
We basically would like to have something that functions like an Excel PivotTable, but connecting via ODBC to MySQL.
PivotTables do connect, but they are not efficient in their query of the db and easily max out resources even querying a few hundred thousand records.

Thanks,
Warren.

You may be interested in exploring OLAP product with JDBC connectivity / Java APIs.
Please check for Open Finance Laboratory OLAP Reporting (OFL OLAP)
at www.objcentric.com.

Envoronment
================
MySQL version: 4.0.15
MySQL Connector/J 3.0.7 Stable
MySQL AB's JDBC Driver for MySQL
Copyright (c) 2002 MySQL AB
Tested: version: 4.0.15-nt

Regards,
objcentric