Data Mart with Postgres

<div class="moz-text-flowed" lang="x-western" style="font-family: -moz-fixed; font-size: 13px;">Hello everybody, <br
/><br/> I´m working with a small project to a client, using Postgres to store data in a dimensional model,
fact-oriented,e.g., a Datamart. <br /><br /> At this time, all I have is a populated database, with the "star schemma"
commonrelations (PK´s / FK´s). <br /><br /> Below is a list of the main goals of this project : <br /> 1. Front-end app
(PHP5)<br /> 2. Transactional database for this app (Postgres) <br /> 3. Datamart in Postgres (described above) <br />
4.ROLAP server that supports Postgres (Java - Mondrian) <br /> 5. Front-end app to manage querys to the ROLAP server
(JSP- JPivot) <br /><br /> Users will have web access to (1), and will be enable to create views using (5). <br /><br
/>It seems like I´m trying to reinvent the wheel, but the point here is that the client can´t afford to use proprietary
BIsolutions, nor proprietary OS. <br /> What I have read all across the internet is that Postgres does not support this
kindof application, wich demands materialyzed views, built-in bitmap index, and so on. In the open-source world, I find
thosemissing features with Mondrian/JPivot. <br /><br /> Does anyone has ever used this structure before ? At least
Mondrianand JPivot ? <br /><br /><div class="moz-txt-sig"><span class="moz-txt-tag">-- <br /></span>[]´s, <br /> André
Volpato<br /></div></div>