Re: OLAP for MySQL or an Aggregrate Table

2006-10-12 Thread Gary Richardson
' time of each piece of data, you could do it as: select DATE(datetime_field) AS period, Avg (A), Min(A), Max(A), AVG(B) min(B), max(B) from table1 left join table2 on table1.field = table2.field GROUP BY period On 10/11/06, Ow Mun Heng [EMAIL PROTECTED] wrote: Anyone here uses OLAP, running

OLAP for MySQL or an Aggregrate Table

2006-10-11 Thread Ow Mun Heng
Anyone here uses OLAP, running in MySQL? Any OpenSOurce OLAP query tools? How does one goes about doing OLAP? Is there any documentation w/ MySQL anywhere. (I'm currently looking at Pentaho and Mondrian etc but the Pre-configured demo didn't work as it should, meaning it doesn't run for X reasons

olap

2005-08-05 Thread Haisam K. Ido
Does OLAP work with MySQL? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

reporting tools for mysql- OLAP functionality possibly

2005-06-06 Thread Angelo Zanetti
Hi, I have a system that im busy designing using PHP, mysql apache and linux. I will need to do alot of intense reporting from the system, like viewing statistics for country, province, district etc... so its basically drill down and roll up functionality (OLAP). This will probably run ontop

OLAP Proposal for MySQL

2003-08-25 Thread Philip Stoev
Hi all, Please tell me if any of this makes sense. Any pointers to relevant projects/articles will be much appreciated. Philip Stoev http://www.stoev.org/pivot/manifest.htm === OLAP PROPOSAL FOR MYSQL The goal is to create an OLAP engine coupled

OLAP TOOLS

2002-04-08 Thread Mardem Barbosa
Good morning friends. We have the a project, what is search the OLAP SYSTEM for SUPORT DECISION. I like to know if anybody have the knwoledge about FREE OLAP SYSTEM TOOL and any what use the MYSQL with DW ? - Before posting

OLAP

2001-05-07 Thread Thalis A. Kalfigopoulos
Is anyone using mysql for OLAP? Any particular tools to check? thanks in advance, thalis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

OLAP and MySQL

2001-03-02 Thread Paul Ulrich
Does anyone know if there an open-source OLAP product for MySQL?

Re: OLAP and MySQL

2001-03-02 Thread Jan Dvorak
Hi, Hmm, MySQL in itself is a wonderful cornerstone for OLAP. I've set up a MIS that's been running for 16 months now, without a glitch. The 25 million rows in the main fact table are not a problem. The trick reads: compressed tables. But the interface is very poor, MS Query. Perhaps it would