Here is an example of how could be implemented and developed a data warehouse to support genomic analysis.

Here are the DB scripts (.sql) in order to integrate into the DW

In this folder there are the ER-Schema model needed to understand the major external databases integrable into the DW

There are the SQL scripts in order to develop a DW for genomes.

Are the scripts used by Pentaho data-integration for the external

There is a simple example of report for Pentaho reporting

Here are the xml of simple cubes developed starting from the DW

===

For a more detailed knowledge of how to develop a data warehouse for genomes with Pentaho read "datawarehouse_thesis.pdf"