Inline..
--- Jacopo Cappellato <[EMAIL PROTECTED]> wrote:
> Chris,
>
> first of all, thanks for your interest on this subject.
> Please, see my comments inline:
>
> Building ETL services and an initial star schema (that I guess is
> what
> you refer to with denormalized entities) is my primary goal now.
>From the Pentaho site
* Mondrian - Open Source OLAP Server
* JFreeReport - Open Source Reporting
>> * Kettle - Open Source Data Integration (E.T.T.L.) <<
* Pentaho - Comprehensive Open Source BI Suite
* Weka - Open Source Data Mining
ETTL means...
* Extraction of data from one or more databases
* Transport of data from one location to an other
* Transformation of data
* Loading of data in a data warehouse
So their's even has an extra "T" ;)
>
> The star schema will be built in a relational database but
> essentially
> is composed of:
> a fact table (e.g. "Sales Transactions")
> a set of dimension tables (e.g. "Products", "Date", "Time", "Stores"
> etc..)
> Usually the fact table is only useful inside one star schema, while
> dimensions are shared among many star schemas.
> I'd like to build a common, based on best practices set of dimensions
>
> (and a few fact tables that use them) derived from the OFBiz data
> model.
> You can then use the tool you want to run your reports/analysis
> etc...
> I don't know how Mondrian works, but by what you say here it seems
> that
> you can use Mondrian on top of these star schemas.
>
That is almost an exact description of what a cube is in Mondrian and
from what I understand Microsoft's OLAP as well
http://mondrian.pentaho.org/documentation/schema.php#Cube
