We have a client that is running Microstrategy on PostGreSQL 8.0,
BizGres to be precise (www.bizgres.com). However the metadata for MSTR
resides on another database, for support reasons and the server
component is running on Windows 2003, Linux might be possible but
wasn't at the time, the web component could run on a Linux based
Application server if need be.
The performance on PostGreSQL depended on the SQL generated by MSTR
(which can be tweaked) and the underlying database itself. Basically if
you can write a quicker query by hand then you can always register the
query in MSTR.
Alternatively.
Using a combination of PostGreSQL for the warehouse and Jasper or BIRT
for the reporting layer, you can achieve a certain level of OLAP
reporting. If you add Mondrian to the mix things might go a little
further but it depends on what you are trying to do.
cono wrote:
> Hi,
>
> I have to choose an OLAP solution for the company I work for. I've
> been pushing for months until I could finally move our servers away
> from windows (we moved to FreeBSD). Now we need to build a solution
> that integrates OLAP and (if possible) has a web client, and I need to
> pick one that runs on linux/freebsd, and uses mysql or postgresql (I
> prefer postgresql).
>
> I came up with a few options:
>
> -Actuate: they say they run on RH linux, not sure how good the
> performance is. I don't know if they use postgresql, although I think
> it's possible to use ODBC.
>
> -Microstrategy: they say it runs on linux, not sure about the DB or
> the performance
>
> -Hyperion: I read a post of a guy who got it to run on several distros
> of linux, and I've also read that it interacts with pgsql using odbc.
>
> I apologize in advance if the information is available on vendor's
> site and I couldn't find it. I am sick of corporate sites with MBA
> mumbo-jumbo-BS and no useful technical info.
>
>
> Any advices and information are welcomed, and if you can point me in
> the right direction or simply want to share your experience even
> better
>
> 
>
> thanks
>
> --
> Posted using the http://www.dbforumz.com interface, at author's request
> Articles individually checked for conformance to usenet standards
> Topic URL: http://www.dbforumz.com/OLAP-help-choosing-solutions-run-pgsql-ftopict...068.htm
> Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=823230 >> Stay informed about: help choosing OLAP solutions that run on/with pgsql 
FAQ
Search
Profile
Private Messages
Log in
