-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.1.22-rc-community


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema repository
--

CREATE DATABASE IF NOT EXISTS repository;
USE repository;

--
-- Definition of table `fas_agg_mes`
--

DROP TABLE IF EXISTS `fas_agg_mes`;
CREATE TABLE `fas_agg_mes` (
  `MES_ID` int(11) DEFAULT NULL,
  `COL_ID` int(11) DEFAULT NULL,
  `AGT_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_agg_mes`
--

/*!40000 ALTER TABLE `fas_agg_mes` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_agg_mes` ENABLE KEYS */;


--
-- Definition of table `fas_aggexclude`
--

DROP TABLE IF EXISTS `fas_aggexclude`;
CREATE TABLE `fas_aggexclude` (
  `AEX_ID` int(11) DEFAULT NULL,
  `AEX_PATTERN` text,
  `AEX_CESENSITVIE` varchar(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_aggexclude`
--

/*!40000 ALTER TABLE `fas_aggexclude` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_aggexclude` ENABLE KEYS */;


--
-- Definition of table `fas_agglvl`
--

DROP TABLE IF EXISTS `fas_agglvl`;
CREATE TABLE `fas_agglvl` (
  `LVL_ID` int(11) DEFAULT NULL,
  `COL_ID` int(11) DEFAULT NULL,
  `AGT_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_agglvl`
--

/*!40000 ALTER TABLE `fas_agglvl` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_agglvl` ENABLE KEYS */;


--
-- Definition of table `fas_aggtable`
--

DROP TABLE IF EXISTS `fas_aggtable`;
CREATE TABLE `fas_aggtable` (
  `AGT_ID` int(11) DEFAULT NULL,
  `TAB_ID` int(11) DEFAULT NULL,
  `AGT_FACTCOUNT` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_aggtable`
--

/*!40000 ALTER TABLE `fas_aggtable` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_aggtable` ENABLE KEYS */;


--
-- Definition of table `fas_connection`
--

DROP TABLE IF EXISTS `fas_connection`;
CREATE TABLE `fas_connection` (
  `CON_ID` int(11) DEFAULT NULL,
  `SRV_ID` int(11) DEFAULT NULL,
  `CON_TYPE` text,
  `CON_DSRLOCATION` text,
  `CON_DRIVER` text,
  `CON_URL` text,
  `CON_PASSWORD` text,
  `CON_LOGIN` text,
  `CON_FILELOC` text,
  `CON_TRURL` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_connection`
--

/*!40000 ALTER TABLE `fas_connection` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_connection` ENABLE KEYS */;


--
-- Definition of table `fas_cub_agg`
--

DROP TABLE IF EXISTS `fas_cub_agg`;
CREATE TABLE `fas_cub_agg` (
  `CUB_ID` int(11) DEFAULT NULL,
  `AGT_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_cub_agg`
--

/*!40000 ALTER TABLE `fas_cub_agg` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_cub_agg` ENABLE KEYS */;


--
-- Definition of table `fas_cub_aggpattern`
--

DROP TABLE IF EXISTS `fas_cub_aggpattern`;
CREATE TABLE `fas_cub_aggpattern` (
  `AEX_ID` int(11) DEFAULT NULL,
  `CUB_ID` int(11) DEFAULT NULL,
  `AGG_PATTERN` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_cub_aggpattern`
--

/*!40000 ALTER TABLE `fas_cub_aggpattern` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_cub_aggpattern` ENABLE KEYS */;


--
-- Definition of table `fas_cub_dgp`
--

DROP TABLE IF EXISTS `fas_cub_dgp`;
CREATE TABLE `fas_cub_dgp` (
  `CUB_ID` int(11) DEFAULT NULL,
  `DGP_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_cub_dgp`
--

/*!40000 ALTER TABLE `fas_cub_dgp` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_cub_dgp` ENABLE KEYS */;


--
-- Definition of table `fas_cub_mes`
--

DROP TABLE IF EXISTS `fas_cub_mes`;
CREATE TABLE `fas_cub_mes` (
  `CUB_ID` int(11) DEFAULT NULL,
  `MES_ID` int(11) DEFAULT NULL,
  `OWNER_CUB_MES_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_cub_mes`
--

/*!40000 ALTER TABLE `fas_cub_mes` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_cub_mes` ENABLE KEYS */;


--
-- Definition of table `fas_cub_mgp`
--

DROP TABLE IF EXISTS `fas_cub_mgp`;
CREATE TABLE `fas_cub_mgp` (
  `MGP_ID` int(11) DEFAULT NULL,
  `CUB_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_cub_mgp`
--

/*!40000 ALTER TABLE `fas_cub_mgp` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_cub_mgp` ENABLE KEYS */;


--
-- Definition of table `fas_cub_nas`
--

DROP TABLE IF EXISTS `fas_cub_nas`;
CREATE TABLE `fas_cub_nas` (
  `NAS_ID` int(11) DEFAULT NULL,
  `CUB_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_cub_nas`
--

/*!40000 ALTER TABLE `fas_cub_nas` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_cub_nas` ENABLE KEYS */;


--
-- Definition of table `fas_cub_sgp`
--

DROP TABLE IF EXISTS `fas_cub_sgp`;
CREATE TABLE `fas_cub_sgp` (
  `SGP_ID` int(11) DEFAULT NULL,
  `CUB_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_cub_sgp`
--

/*!40000 ALTER TABLE `fas_cub_sgp` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_cub_sgp` ENABLE KEYS */;


--
-- Definition of table `fas_cube`
--

DROP TABLE IF EXISTS `fas_cube`;
CREATE TABLE `fas_cube` (
  `CUB_ID` int(11) DEFAULT NULL,
  `TAB_ID` int(11) DEFAULT NULL,
  `CUB_DESC` text,
  `CUB_TYPE` text,
  `CUB_PHYSNAME` text,
  `CUB_LOCATION` text,
  `CUB_ENABLED` varchar(1) DEFAULT NULL,
  `CUB_CACHED` varchar(1) DEFAULT NULL,
  `CUB_CAPTION` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_cube`
--

/*!40000 ALTER TABLE `fas_cube` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_cube` ENABLE KEYS */;


--
-- Definition of table `fas_dataobject`
--

DROP TABLE IF EXISTS `fas_dataobject`;
CREATE TABLE `fas_dataobject` (
  `TAB_ID` int(11) DEFAULT NULL,
  `CHILD_COL_ID` int(11) DEFAULT NULL,
  `PARENT_COL_ID` int(11) DEFAULT NULL,
  `DSR_ID` int(11) DEFAULT NULL,
  `TAB_DESC` text,
  `TAB_TYPE` text,
  `TAB_SELECT` text,
  `TAB_TRNAME` text,
  `TAB_FILENAME` text,
  `TAB_CLOSURE` varchar(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_dataobject`
--

/*!40000 ALTER TABLE `fas_dataobject` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_dataobject` ENABLE KEYS */;


--
-- Definition of table `fas_dataobjectitem`
--

DROP TABLE IF EXISTS `fas_dataobjectitem`;
CREATE TABLE `fas_dataobjectitem` (
  `COL_ID` int(11) DEFAULT NULL,
  `TAB_ID` int(11) DEFAULT NULL,
  `COL_DESC` text,
  `COL_ORIGIN` text,
  `COL_TYPE` text,
  `COL_CLASSE` text,
  `COL_ATTRIB` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_dataobjectitem`
--

/*!40000 ALTER TABLE `fas_dataobjectitem` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_dataobjectitem` ENABLE KEYS */;


--
-- Definition of table `fas_datasource`
--

DROP TABLE IF EXISTS `fas_datasource`;
CREATE TABLE `fas_datasource` (
  `DSR_ID` int(11) DEFAULT NULL,
  `CON_ID` int(11) DEFAULT NULL,
  `DSR_NAME` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_datasource`
--

/*!40000 ALTER TABLE `fas_datasource` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_datasource` ENABLE KEYS */;


--
-- Definition of table `fas_dim_cube_rel`
--

DROP TABLE IF EXISTS `fas_dim_cube_rel`;
CREATE TABLE `fas_dim_cube_rel` (
  `DIM_ID` int(11) DEFAULT NULL,
  `CUB_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_dim_cube_rel`
--

/*!40000 ALTER TABLE `fas_dim_cube_rel` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_dim_cube_rel` ENABLE KEYS */;


--
-- Definition of table `fas_dimension`
--

DROP TABLE IF EXISTS `fas_dimension`;
CREATE TABLE `fas_dimension` (
  `DIM_ID` int(11) DEFAULT NULL,
  `DGP_ID` int(11) DEFAULT NULL,
  `DVW_ID` int(11) DEFAULT NULL,
  `DIM_DESC` text,
  `DIM_ISDATE` text,
  `DIM_LOAD` text,
  `DIM_ORDER` int(11) DEFAULT NULL,
  `DIM_WIDGET` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_dimension`
--

/*!40000 ALTER TABLE `fas_dimension` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_dimension` ENABLE KEYS */;


--
-- Definition of table `fas_dimgroup`
--

DROP TABLE IF EXISTS `fas_dimgroup`;
CREATE TABLE `fas_dimgroup` (
  `DGP_ID` int(11) DEFAULT NULL,
  `PARENT_DGP_ID` int(11) DEFAULT NULL,
  `SCH_ID` int(11) DEFAULT NULL,
  `DGP_DESC` text,
  `DGP_LVL` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_dimgroup`
--

/*!40000 ALTER TABLE `fas_dimgroup` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_dimgroup` ENABLE KEYS */;


--
-- Definition of table `fas_dimview`
--

DROP TABLE IF EXISTS `fas_dimview`;
CREATE TABLE `fas_dimview` (
  `DVW_ID` int(11) DEFAULT NULL,
  `DIM_ID` int(11) DEFAULT NULL,
  `DVW_NAME` text,
  `DVW_DESC` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_dimview`
--

/*!40000 ALTER TABLE `fas_dimview` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_dimview` ENABLE KEYS */;


--
-- Definition of table `fas_grants`
--

DROP TABLE IF EXISTS `fas_grants`;
CREATE TABLE `fas_grants` (
  `GRA_ID` int(11) DEFAULT NULL,
  `SGP_ID` int(11) DEFAULT NULL,
  `DVW_ID` int(11) DEFAULT NULL,
  `GRA_NAME` text,
  `GRA_DESC` text,
  `GRA_ALLOW` varchar(1) DEFAULT NULL,
  `GRA_ALLOWFULL` varchar(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_grants`
--

/*!40000 ALTER TABLE `fas_grants` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_grants` ENABLE KEYS */;


--
-- Definition of table `fas_hierarchy`
--

DROP TABLE IF EXISTS `fas_hierarchy`;
CREATE TABLE `fas_hierarchy` (
  `HIE_ID` int(11) DEFAULT NULL,
  `DIM_ID` int(11) DEFAULT NULL,
  `HIE_DESC` text,
  `HIE_HASALL` varchar(1) DEFAULT NULL,
  `HIE_ALLNAME` text,
  `HIE_CAPTION` text,
  `HIE_READER` text,
  `HIE_ALLCAPTION` text,
  `HIE_DEFAULTMEMBER` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_hierarchy`
--

/*!40000 ALTER TABLE `fas_hierarchy` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_hierarchy` ENABLE KEYS */;


--
-- Definition of table `fas_inlined`
--

DROP TABLE IF EXISTS `fas_inlined`;
CREATE TABLE `fas_inlined` (
  `TAB_ID` int(11) DEFAULT NULL,
  `COL_ID` int(11) DEFAULT NULL,
  `INL_VALUE` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_inlined`
--

/*!40000 ALTER TABLE `fas_inlined` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_inlined` ENABLE KEYS */;


--
-- Definition of table `fas_level`
--

DROP TABLE IF EXISTS `fas_level`;
CREATE TABLE `fas_level` (
  `LVL_ID` int(11) DEFAULT NULL,
  `CAPTION_COL_ID` int(11) DEFAULT NULL,
  `LVL_COL_ID` int(11) DEFAULT NULL,
  `LABEL_COL_ID2` int(11) DEFAULT NULL,
  `DESC_COL_ID` int(11) DEFAULT NULL,
  `ORDINAL_COL_ID` int(11) DEFAULT NULL,
  `HIE_ID` int(11) DEFAULT NULL,
  `LVL_NUM` int(11) DEFAULT NULL,
  `LVL_DESC` text,
  `LVL_CAPTION` text,
  `LVL_FORMATTER` text,
  `LVL_TYPE` text,
  `LVL_HIDEIF` text,
  `LVL_ROWCOUNT` int(11) DEFAULT NULL,
  `LVL_UNIQUE` varchar(1) DEFAULT NULL,
  `LVL_ISREAL` varchar(1) DEFAULT NULL,
  `LVL_NULLPARVALUE` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_level`
--

/*!40000 ALTER TABLE `fas_level` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_level` ENABLE KEYS */;


--
-- Definition of table `fas_lvl_clos`
--

DROP TABLE IF EXISTS `fas_lvl_clos`;
CREATE TABLE `fas_lvl_clos` (
  `LVL_ID` int(11) DEFAULT NULL,
  `TAB_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_lvl_clos`
--

/*!40000 ALTER TABLE `fas_lvl_clos` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_lvl_clos` ENABLE KEYS */;


--
-- Definition of table `fas_measure`
--

DROP TABLE IF EXISTS `fas_measure`;
CREATE TABLE `fas_measure` (
  `MES_ID` int(11) DEFAULT NULL,
  `LABEL_COL_ID` int(11) DEFAULT NULL,
  `MES_COL_ID` int(11) DEFAULT NULL,
  `MGP_ID` int(11) DEFAULT NULL,
  `MES_DESC` text,
  `MES_TYPE` text,
  `MES_ORDER` int(11) DEFAULT NULL,
  `MES_FORMULA` text,
  `MES_AGG` text,
  `MES_FORMATSTR` text,
  `MES_CAPTION` text,
  `MES_VISIBLE` varchar(1) DEFAULT NULL,
  `MES_DIMNAME` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_measure`
--

/*!40000 ALTER TABLE `fas_measure` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_measure` ENABLE KEYS */;


--
-- Definition of table `fas_memberrestriction`
--

DROP TABLE IF EXISTS `fas_memberrestriction`;
CREATE TABLE `fas_memberrestriction` (
  `RES_ID` int(11) DEFAULT NULL,
  `GRA_ID` int(11) DEFAULT NULL,
  `RES_NAME` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_memberrestriction`
--

/*!40000 ALTER TABLE `fas_memberrestriction` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_memberrestriction` ENABLE KEYS */;


--
-- Definition of table `fas_mgp`
--

DROP TABLE IF EXISTS `fas_mgp`;
CREATE TABLE `fas_mgp` (
  `MGP_ID` int(11) DEFAULT NULL,
  `SCH_ID` int(11) DEFAULT NULL,
  `PARENT_MGP_ID` int(11) DEFAULT NULL,
  `MGP_DESC` text,
  `MGP_LVL` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_mgp`
--

/*!40000 ALTER TABLE `fas_mgp` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_mgp` ENABLE KEYS */;


--
-- Definition of table `fas_model`
--

DROP TABLE IF EXISTS `fas_model`;
CREATE TABLE `fas_model` (
  `MODEL_ID` int(11) DEFAULT NULL,
  `MODEL_AUTHOR` text,
  `MODEL_DESC` text,
  `MODEL_CREATION` datetime DEFAULT NULL,
  `MODEL_MODIF` datetime DEFAULT NULL,
  `MODEL_ICON` text,
  `MODEL_FLYOVER` text,
  `MODEL_NAME` text,
  `MODEL_XML` longtext,
  `SCH_ID` int(11) DEFAULT NULL,
  `MODEL_VERSION` varchar(25) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_model`
--

/*!40000 ALTER TABLE `fas_model` DISABLE KEYS */;
INSERT INTO `fas_model` (`MODEL_ID`,`MODEL_AUTHOR`,`MODEL_DESC`,`MODEL_CREATION`,`MODEL_MODIF`,`MODEL_ICON`,`MODEL_FLYOVER`,`MODEL_NAME`,`MODEL_XML`,`SCH_ID`,`MODEL_VERSION`) VALUES 
 (5,'','','2008-04-04 00:00:00','2008-04-04 00:00:00','','','','<freeanalysis-schema>\n    <version>2.0</version>\n    <id>5</id>\n    <isSynchronized>false</isSynchronized>\n    <document-properties>\n        <name/>\n        <author/>\n        <description/>\n        <creation-date>2008-04-04</creation-date>\n        <modification-date>2008-04-04</modification-date>\n        <version/>\n        <icon/>\n        <flyover-icon/>\n    </document-properties>\n\n    <datasources>\n        <datasource-item>\n            <name>freeolap_mondrian</name>\n            <id>t2</id>\n            <connection>\n                <name/>\n                <id>a5</id>\n                <type>DataBase</type>\n                <data-source-location/>\n                <server-id/>\n                <driver>com.mysql.jdbc.Driver</driver>\n                <schema-name/>\n                <url>jdbc:mysql://localhost/freeolap_mondrian</url>\n                <transformation-url/>\n                <file-location/>\n                <user>root</user>\n                <password>root</password>\n                <description/>\n            </connection>\n            <dataobject-item>\n            	<id>c53</id>\n                <name>sales_fact_1998</name>\n                <data-source-id>t2</data-source-id>\n                <server-id/>\n                <data-object-type>fact</data-object-type>\n                <select-statment-definition>SELECT * FROM sales_fact_1998</select-statment-definition>\n                <transformation-name/>\n                <file-name/>\n                <description/>\n                <isInline>false</isInline>\n                <item>\n                    <id>l376</id>\n                    <name>product_id</name>\n                    <origin>product_id</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l377</id>\n                    <name>time_id</name>\n                    <origin>time_id</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l378</id>\n                    <name>customer_id</name>\n                    <origin>customer_id</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l379</id>\n                    <name>promotion_id</name>\n                    <origin>promotion_id</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l380</id>\n                    <name>store_id</name>\n                    <origin>store_id</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l381</id>\n                    <name>store_sales</name>\n                    <origin>store_sales</origin>\n                    <type>physical</type>\n                    <classe>java.math.BigDecimal</classe>\n                    <sql-type>DECIMAL</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l382</id>\n                    <name>store_cost</name>\n                    <origin>store_cost</origin>\n                    <type>physical</type>\n                    <classe>java.math.BigDecimal</classe>\n                    <sql-type>DECIMAL</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l383</id>\n                    <name>unit_sales</name>\n                    <origin>unit_sales</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Double</classe>\n                    <sql-type>DOUBLE</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n            </dataobject-item>\n            <dataobject-item>\n            	<id>c54</id>\n                <name>store</name>\n                <data-source-id>t2</data-source-id>\n                <server-id/>\n                <data-object-type>dimension</data-object-type>\n                <select-statment-definition>SELECT * FROM store</select-statment-definition>\n                <transformation-name/>\n                <file-name/>\n                <description/>\n                <isInline>false</isInline>\n                <item>\n                    <id>l392</id>\n                    <name>store_id</name>\n                    <origin>store_id</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l393</id>\n                    <name>store_type</name>\n                    <origin>store_type</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l394</id>\n                    <name>region_id</name>\n                    <origin>region_id</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l395</id>\n                    <name>store_name</name>\n                    <origin>store_name</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l396</id>\n                    <name>store_number</name>\n                    <origin>store_number</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Double</classe>\n                    <sql-type>DOUBLE</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l397</id>\n                    <name>store_street_address</name>\n                    <origin>store_street_address</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l398</id>\n                    <name>store_city</name>\n                    <origin>store_city</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l399</id>\n                    <name>store_state</name>\n                    <origin>store_state</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l400</id>\n                    <name>store_postal_code</name>\n                    <origin>store_postal_code</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l401</id>\n                    <name>store_country</name>\n                    <origin>store_country</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l402</id>\n                    <name>store_manager</name>\n                    <origin>store_manager</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l403</id>\n                    <name>store_phone</name>\n                    <origin>store_phone</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l404</id>\n                    <name>store_fax</name>\n                    <origin>store_fax</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l405</id>\n                    <name>first_opened_date</name>\n                    <origin>first_opened_date</origin>\n                    <type>physical</type>\n                    <classe>java.sql.Timestamp</classe>\n                    <sql-type>DATETIME</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l406</id>\n                    <name>last_remodel_date</name>\n                    <origin>last_remodel_date</origin>\n                    <type>physical</type>\n                    <classe>java.sql.Timestamp</classe>\n                    <sql-type>DATETIME</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l407</id>\n                    <name>lease_sqft</name>\n                    <origin>lease_sqft</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Double</classe>\n                    <sql-type>DOUBLE</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l408</id>\n                    <name>store_sqft</name>\n                    <origin>store_sqft</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Double</classe>\n                    <sql-type>DOUBLE</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l409</id>\n                    <name>grocery_sqft</name>\n                    <origin>grocery_sqft</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Double</classe>\n                    <sql-type>DOUBLE</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l410</id>\n                    <name>frozen_sqft</name>\n                    <origin>frozen_sqft</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Double</classe>\n                    <sql-type>DOUBLE</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l411</id>\n                    <name>meat_sqft</name>\n                    <origin>meat_sqft</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Double</classe>\n                    <sql-type>DOUBLE</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l412</id>\n                    <name>coffee_bar</name>\n                    <origin>coffee_bar</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Boolean</classe>\n                    <sql-type>TINYINT</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l413</id>\n                    <name>video_store</name>\n                    <origin>video_store</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Boolean</classe>\n                    <sql-type>TINYINT</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l414</id>\n                    <name>salad_bar</name>\n                    <origin>salad_bar</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Boolean</classe>\n                    <sql-type>TINYINT</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l415</id>\n                    <name>prepared_food</name>\n                    <origin>prepared_food</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Boolean</classe>\n                    <sql-type>TINYINT</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l416</id>\n                    <name>florist</name>\n                    <origin>florist</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Boolean</classe>\n                    <sql-type>TINYINT</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n            </dataobject-item>\n            <dataobject-item>\n            	<id>c55</id>\n                <name>time_by_day</name>\n                <data-source-id>t2</data-source-id>\n                <server-id/>\n                <data-object-type>dimension</data-object-type>\n                <select-statment-definition>SELECT * FROM time_by_day</select-statment-definition>\n                <transformation-name/>\n                <file-name/>\n                <description/>\n                <isInline>false</isInline>\n                <item>\n                    <id>l442</id>\n                    <name>time_id</name>\n                    <origin>time_id</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l443</id>\n                    <name>the_date</name>\n                    <origin>the_date</origin>\n                    <type>physical</type>\n                    <classe>java.sql.Timestamp</classe>\n                    <sql-type>DATETIME</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l444</id>\n                    <name>the_day</name>\n                    <origin>the_day</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l445</id>\n                    <name>the_month</name>\n                    <origin>the_month</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l446</id>\n                    <name>the_year</name>\n                    <origin>the_year</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>SMALLINT</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l447</id>\n                    <name>day_of_month</name>\n                    <origin>day_of_month</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>SMALLINT</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l448</id>\n                    <name>week_of_year</name>\n                    <origin>week_of_year</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Double</classe>\n                    <sql-type>DOUBLE</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l449</id>\n                    <name>month_of_year</name>\n                    <origin>month_of_year</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>SMALLINT</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l450</id>\n                    <name>quarter</name>\n                    <origin>quarter</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l451</id>\n                    <name>fiscal_period</name>\n                    <origin>fiscal_period</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n            </dataobject-item>\n        </datasource-item>\n    </datasources>\n    <object-relation>\n        <object-relation-item>\n             <id>l1</id>\n             <name>[sales_fact_1998.time_id] = [time_by_day.time_id]</name>\n             <left-object-id>c53</left-object-id>\n             <right-object-id>c55</right-object-id>\n             <relation-formula>\n                 <left-object-column-id>l377</left-object-column-id>\n                 <right-object-column-id>l442</right-object-column-id>\n                 <object-columns-relation>=</object-columns-relation>\n             </relation-formula>\n        </object-relation-item>\n        <object-relation-item>\n             <id>l2</id>\n             <name>[sales_fact_1998.store_id] = [store.store_id]</name>\n             <left-object-id>c53</left-object-id>\n             <right-object-id>c54</right-object-id>\n             <relation-formula>\n                 <left-object-column-id>l380</left-object-column-id>\n                 <right-object-column-id>l392</right-object-column-id>\n                 <object-columns-relation>=</object-columns-relation>\n             </relation-formula>\n        </object-relation-item>\n    </object-relation>\n<security>\n    <server-connection>\n        <server-connection-item>\n            <name>new ServerConnection</name>\n            <id>m1</id>\n            <type/>\n            <host>http://localhost:8080/FA/SecurityProvider</host>\n            <port/>\n            <user/>\n            <password/>\n            <description/>\n        </server-connection-item>\n    </server-connection>\n    <security-provider>\n    </security-provider>\n</security>\n<olap>\n\n    <defaultRoleName/>\n    <measureCaption/>\n    <UserDefinedFunctions>\n    </UserDefinedFunctions>\n    <Dimension-group>\n    </Dimension-group>\n    <Measure-group>\n    </Measure-group>\n    <Security-group>\n    </Security-group>\n    <Aggregate>\n    </Aggregate>\n    <Dimension>\n    <Dimension-item>\n        <id>g1</id>\n        <name>times</name>\n        <caption/>\n        <description/>\n        <dimension-group-id/>\n        <IsDate>true</IsDate>\n        <LoadMethod>cube_startup</LoadMethod>\n        <order/>\n        <Widget/>\n        <properties/>\n        <Hierarchy>\n            <id>n1</id>\n            <name>times</name>\n            <caption/>\n            <memberReaderClass/>\n            <allMemberCaption/>\n            <desc/>\n            <dimension-id>g1</dimension-id>\n            <hasAll>true</hasAll>\n            <allMember>All times</allMember>\n            <defaultMember/>\n            <Level>\n                <id>o1</id>\n                <name>the_year</name>\n                <caption/>\n                <captionColumn/>\n                <formatter/>\n                <type/>\n                <levelType/>\n                <hideMemberIf/>\n                <ordinalColumn/>\n                <level-nb>2</level-nb>\n                <hierarchy-parent-id>n1</hierarchy-parent-id>\n                <description/>\n                <uniqueMembers>false</uniqueMembers>\n                <dataobjectitem-code-id>l446</dataobjectitem-code-id>\n                <parent-dataobjectitem-id/>\n                <closure-dataobject-id/>\n                <closure-parent-dataobjectitem-id/>\n                <closure-child-dataobjectitem-id/>\n                <null-parent-value/>\n            </Level>\n            <Level>\n                <id>o2</id>\n                <name>the_month</name>\n                <caption/>\n                <captionColumn/>\n                <formatter/>\n                <type/>\n                <levelType/>\n                <hideMemberIf/>\n                <ordinalColumn/>\n                <level-nb>1</level-nb>\n                <hierarchy-parent-id>n1</hierarchy-parent-id>\n                <description/>\n                <uniqueMembers>false</uniqueMembers>\n                <dataobjectitem-code-id>l445</dataobjectitem-code-id>\n                <parent-dataobjectitem-id/>\n                <closure-dataobject-id/>\n                <closure-parent-dataobjectitem-id/>\n                <closure-child-dataobjectitem-id/>\n                <null-parent-value/>\n            </Level>\n            <Level>\n                <id>o3</id>\n                <name>the_day</name>\n                <caption/>\n                <captionColumn/>\n                <formatter/>\n                <type/>\n                <levelType/>\n                <hideMemberIf/>\n                <ordinalColumn/>\n                <level-nb>2</level-nb>\n                <hierarchy-parent-id>n1</hierarchy-parent-id>\n                <description/>\n                <uniqueMembers>false</uniqueMembers>\n                <dataobjectitem-code-id>l444</dataobjectitem-code-id>\n                <parent-dataobjectitem-id/>\n                <closure-dataobject-id/>\n                <closure-parent-dataobjectitem-id/>\n                <closure-child-dataobjectitem-id/>\n                <null-parent-value/>\n            </Level>\n        </Hierarchy>\n    </Dimension-item>\n    <Dimension-item>\n        <id>g2</id>\n        <name>stores</name>\n        <caption/>\n        <description/>\n        <dimension-group-id/>\n        <IsDate>false</IsDate>\n        <LoadMethod>cube_startup</LoadMethod>\n        <order/>\n        <Widget/>\n        <properties/>\n        <Hierarchy>\n            <id>n2</id>\n            <name>stores</name>\n            <caption/>\n            <memberReaderClass/>\n            <allMemberCaption/>\n            <desc/>\n            <dimension-id>g2</dimension-id>\n            <hasAll>true</hasAll>\n            <allMember>All stores</allMember>\n            <defaultMember/>\n            <Level>\n                <id>o4</id>\n                <name>store_country</name>\n                <caption/>\n                <captionColumn/>\n                <formatter/>\n                <type/>\n                <levelType/>\n                <hideMemberIf/>\n                <ordinalColumn/>\n                <level-nb>1</level-nb>\n                <hierarchy-parent-id>n2</hierarchy-parent-id>\n                <description/>\n                <uniqueMembers>false</uniqueMembers>\n                <dataobjectitem-code-id>l401</dataobjectitem-code-id>\n                <parent-dataobjectitem-id/>\n                <closure-dataobject-id/>\n                <closure-parent-dataobjectitem-id/>\n                <closure-child-dataobjectitem-id/>\n                <null-parent-value/>\n            </Level>\n            <Level>\n                <id>o5</id>\n                <name>store_name</name>\n                <caption/>\n                <captionColumn/>\n                <formatter/>\n                <type/>\n                <levelType/>\n                <hideMemberIf/>\n                <ordinalColumn/>\n                <level-nb>1</level-nb>\n                <hierarchy-parent-id>n2</hierarchy-parent-id>\n                <description/>\n                <uniqueMembers>false</uniqueMembers>\n                <dataobjectitem-code-id>l395</dataobjectitem-code-id>\n                <parent-dataobjectitem-id/>\n                <closure-dataobject-id/>\n                <closure-parent-dataobjectitem-id/>\n                <closure-child-dataobjectitem-id/>\n                <null-parent-value/>\n            </Level>\n        </Hierarchy>\n    </Dimension-item>\n    </Dimension>\n    <Measure>\n    <Measure-item>\n        <id>h1</id>\n        <name>store_sales</name>\n        <caption/>\n        <description/>\n        <measure-group-id/>\n        <type>physical</type>\n        <order>0</order>\n        <origin-id>l381</origin-id>\n        <formula/>\n        <label/>\n        <visible>true</visible>\n        <aggregator>sum</aggregator>\n        <formatString>Standard</formatString>\n    </Measure-item>\n    <Measure-item>\n        <id>h2</id>\n        <name>store_cost</name>\n        <caption/>\n        <description/>\n        <measure-group-id/>\n        <type>physical</type>\n        <order>0</order>\n        <origin-id>l382</origin-id>\n        <formula/>\n        <label/>\n        <visible>true</visible>\n        <aggregator>sum</aggregator>\n        <formatString>Standard</formatString>\n    </Measure-item>\n    <Measure-item>\n        <id>h3</id>\n        <name>unit_sales</name>\n        <caption/>\n        <description/>\n        <measure-group-id/>\n        <type>physical</type>\n        <order>0</order>\n        <origin-id>l383</origin-id>\n        <formula/>\n        <label/>\n        <visible>true</visible>\n        <aggregator>sum</aggregator>\n        <formatString>Standard</formatString>\n    </Measure-item>\n    </Measure>\n    <Cube>\n    <Cube-item>\n        <id>i1</id>\n        <name>sample</name>\n        <defaultMeasure/>\n        <enabled>true</enabled>\n        <cached>true</cached>\n        <description/>\n        <type>Rolap</type>\n        <physical-name/>\n        <cube-location/>\n        <fact-dataobject-id>c53</fact-dataobject-id>\n        <datasource-id>t2</datasource-id>\n        <dimension-item-id>g1</dimension-item-id>\n        <dimension-item-id>g2</dimension-item-id>\n        <measure-item-id>h1</measure-item-id>\n        <measure-item-id>h2</measure-item-id>\n        <measure-item-id>h3</measure-item-id>\n    </Cube-item>\n    </Cube>\n    <VirtualCube>\n    </VirtualCube>\n    <NamedSets>\n    </NamedSets>\n    <DimensionViews>\n    <DimensionView-item>\n        <id>j55</id>\n        <name>times view</name>\n        <description/>\n        <dimension-id>g1</dimension-id>\n    </DimensionView-item>\n    <DimensionView-item>\n        <id>j56</id>\n        <name>stores view</name>\n        <description/>\n        <dimension-id>g2</dimension-id>\n    </DimensionView-item>\n    </DimensionViews>\n</olap>\n\n</freeanalysis-schema>',0,''),
 (6,'','','2008-04-08 00:00:00','2008-05-16 00:00:00','','','','<freeanalysis-schema>\n    <version>2.0</version>\n    <id>6</id>\n    <isSynchronized>false</isSynchronized>\n    <document-properties>\n        <name/>\n        <author/>\n        <description/>\n        <creation-date>2008-04-08</creation-date>\n        <modification-date>2008-05-16</modification-date>\n        <version/>\n        <icon/>\n        <flyover-icon/>\n    </document-properties>\n\n    <datasources>\n        <datasource-item>\n            <name/>\n            <id>t2</id>\n            <connection>\n                <name/>\n                <id>a3</id>\n                <type>DataBase</type>\n                <data-source-location/>\n                <server-id/>\n                <driver>com.mysql.jdbc.Driver</driver>\n                <schema-name/>\n                <url>jdbc:mysql://localhost/sampledata</url>\n                <transformation-url/>\n                <file-location/>\n                <user>root</user>\n                <password>root</password>\n                <description/>\n            </connection>\n            <dataobject-item>\n            	<id>c17</id>\n                <name>orderfact</name>\n                <data-source-id>t2</data-source-id>\n                <server-id/>\n                <data-object-type>fact</data-object-type>\n                <select-statment-definition>SELECT * FROM orderfact</select-statment-definition>\n                <transformation-name/>\n                <file-name/>\n                <description/>\n                <isInline>false</isInline>\n                <item>\n                    <id>l60</id>\n                    <name>ORDERNUMBER</name>\n                    <origin>ORDERNUMBER</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l61</id>\n                    <name>PRODUCTCODE</name>\n                    <origin>PRODUCTCODE</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l62</id>\n                    <name>QUANTITYORDERED</name>\n                    <origin>QUANTITYORDERED</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l63</id>\n                    <name>PRICEEACH</name>\n                    <origin>PRICEEACH</origin>\n                    <type>physical</type>\n                    <classe>java.math.BigDecimal</classe>\n                    <sql-type>DECIMAL</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l64</id>\n                    <name>ORDERLINENUMBER</name>\n                    <origin>ORDERLINENUMBER</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l65</id>\n                    <name>TOTALPRICE</name>\n                    <origin>TOTALPRICE</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Double</classe>\n                    <sql-type>DOUBLE</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l66</id>\n                    <name>ORDERDATE</name>\n                    <origin>ORDERDATE</origin>\n                    <type>physical</type>\n                    <classe>java.sql.Timestamp</classe>\n                    <sql-type>TIMESTAMP</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l67</id>\n                    <name>REQUIREDDATE</name>\n                    <origin>REQUIREDDATE</origin>\n                    <type>physical</type>\n                    <classe>java.sql.Timestamp</classe>\n                    <sql-type>TIMESTAMP</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l68</id>\n                    <name>SHIPPEDDATE</name>\n                    <origin>SHIPPEDDATE</origin>\n                    <type>physical</type>\n                    <classe>java.sql.Timestamp</classe>\n                    <sql-type>TIMESTAMP</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l69</id>\n                    <name>STATUS</name>\n                    <origin>STATUS</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l70</id>\n                    <name>COMMENTS</name>\n                    <origin>COMMENTS</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l71</id>\n                    <name>CUSTOMERNUMBER</name>\n                    <origin>CUSTOMERNUMBER</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l72</id>\n                    <name>TIME_ID</name>\n                    <origin>TIME_ID</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l73</id>\n                    <name>QTR_ID</name>\n                    <origin>QTR_ID</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Long</classe>\n                    <sql-type>BIGINT</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l74</id>\n                    <name>MONTH_ID</name>\n                    <origin>MONTH_ID</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Long</classe>\n                    <sql-type>BIGINT</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l75</id>\n                    <name>YEAR_ID</name>\n                    <origin>YEAR_ID</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Long</classe>\n                    <sql-type>BIGINT</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n            </dataobject-item>\n            <dataobject-item>\n            	<id>c18</id>\n                <name>products</name>\n                <data-source-id>t2</data-source-id>\n                <server-id/>\n                <data-object-type>dimension</data-object-type>\n                <select-statment-definition>SELECT * FROM products</select-statment-definition>\n                <transformation-name/>\n                <file-name/>\n                <description/>\n                <isInline>false</isInline>\n                <item>\n                    <id>l87</id>\n                    <name>PRODUCTCODE</name>\n                    <origin>PRODUCTCODE</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l88</id>\n                    <name>PRODUCTNAME</name>\n                    <origin>PRODUCTNAME</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l89</id>\n                    <name>PRODUCTLINE</name>\n                    <origin>PRODUCTLINE</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l90</id>\n                    <name>PRODUCTSCALE</name>\n                    <origin>PRODUCTSCALE</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l91</id>\n                    <name>PRODUCTVENDOR</name>\n                    <origin>PRODUCTVENDOR</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l92</id>\n                    <name>PRODUCTDESCRIPTION</name>\n                    <origin>PRODUCTDESCRIPTION</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l93</id>\n                    <name>QUANTITYINSTOCK</name>\n                    <origin>QUANTITYINSTOCK</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>SMALLINT</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l94</id>\n                    <name>BUYPRICE</name>\n                    <origin>BUYPRICE</origin>\n                    <type>physical</type>\n                    <classe>java.math.BigDecimal</classe>\n                    <sql-type>DECIMAL</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l95</id>\n                    <name>MSRP</name>\n                    <origin>MSRP</origin>\n                    <type>physical</type>\n                    <classe>java.math.BigDecimal</classe>\n                    <sql-type>DECIMAL</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n            </dataobject-item>\n            <dataobject-item>\n            	<id>c19</id>\n                <name>time</name>\n                <data-source-id>t2</data-source-id>\n                <server-id/>\n                <data-object-type>dimension</data-object-type>\n                <select-statment-definition>SELECT * FROM time</select-statment-definition>\n                <transformation-name/>\n                <file-name/>\n                <description/>\n                <isInline>false</isInline>\n                <item>\n                    <id>l102</id>\n                    <name>TIME_ID</name>\n                    <origin>TIME_ID</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l103</id>\n                    <name>MONTH_ID</name>\n                    <origin>MONTH_ID</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l104</id>\n                    <name>QTR_ID</name>\n                    <origin>QTR_ID</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l105</id>\n                    <name>YEAR_ID</name>\n                    <origin>YEAR_ID</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l106</id>\n                    <name>MONTH_NAME</name>\n                    <origin>MONTH_NAME</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>CHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l107</id>\n                    <name>MONTH_DESC</name>\n                    <origin>MONTH_DESC</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l108</id>\n                    <name>QTR_NAME</name>\n                    <origin>QTR_NAME</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l109</id>\n                    <name>QTR_DESC</name>\n                    <origin>QTR_DESC</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n            </dataobject-item>\n            <dataobject-item>\n            	<id>c20</id>\n                <name>customers</name>\n                <data-source-id>t2</data-source-id>\n                <server-id/>\n                <data-object-type>dimension</data-object-type>\n                <select-statment-definition>SELECT * FROM customers</select-statment-definition>\n                <transformation-name/>\n                <file-name/>\n                <description/>\n                <isInline>false</isInline>\n                <item>\n                    <id>l15</id>\n                    <name>CUSTOMERNUMBER</name>\n                    <origin>CUSTOMERNUMBER</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l16</id>\n                    <name>CUSTOMERNAME</name>\n                    <origin>CUSTOMERNAME</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l17</id>\n                    <name>CONTACTLASTNAME</name>\n                    <origin>CONTACTLASTNAME</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l18</id>\n                    <name>CONTACTFIRSTNAME</name>\n                    <origin>CONTACTFIRSTNAME</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l19</id>\n                    <name>PHONE</name>\n                    <origin>PHONE</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l20</id>\n                    <name>ADDRESSLINE1</name>\n                    <origin>ADDRESSLINE1</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l21</id>\n                    <name>ADDRESSLINE2</name>\n                    <origin>ADDRESSLINE2</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l22</id>\n                    <name>CITY</name>\n                    <origin>CITY</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l23</id>\n                    <name>STATE</name>\n                    <origin>STATE</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l24</id>\n                    <name>POSTALCODE</name>\n                    <origin>POSTALCODE</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l25</id>\n                    <name>COUNTRY</name>\n                    <origin>COUNTRY</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l26</id>\n                    <name>SALESREPEMPLOYEENUMBER</name>\n                    <origin>SALESREPEMPLOYEENUMBER</origin>\n                    <type>physical</type>\n                    <classe>java.lang.Integer</classe>\n                    <sql-type>INTEGER</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l27</id>\n                    <name>CREDITLIMIT</name>\n                    <origin>CREDITLIMIT</origin>\n                    <type>physical</type>\n                    <classe>java.math.BigDecimal</classe>\n                    <sql-type>DECIMAL</sql-type>\n                    <attribut>D</attribut>\n                    <description/>\n                </item>\n            </dataobject-item>\n        </datasource-item>\n    </datasources>\n    <object-relation>\n        <object-relation-item>\n             <id>l1</id>\n             <name>[orderfact.TIME_ID] = [time.TIME_ID]</name>\n             <left-object-id>c17</left-object-id>\n             <right-object-id>c19</right-object-id>\n             <relation-formula>\n                 <left-object-column-id>l72</left-object-column-id>\n                 <right-object-column-id>l102</right-object-column-id>\n                 <object-columns-relation>=</object-columns-relation>\n             </relation-formula>\n        </object-relation-item>\n        <object-relation-item>\n             <id>l2</id>\n             <name>[orderfact.CUSTOMERNUMBER] = [customers.CUSTOMERNUMBER]</name>\n             <left-object-id>c17</left-object-id>\n             <right-object-id>c20</right-object-id>\n             <relation-formula>\n                 <left-object-column-id>l71</left-object-column-id>\n                 <right-object-column-id>l15</right-object-column-id>\n                 <object-columns-relation>=</object-columns-relation>\n             </relation-formula>\n        </object-relation-item>\n        <object-relation-item>\n             <id>l3</id>\n             <name>[orderfact.PRODUCTCODE] = [products.PRODUCTCODE]</name>\n             <left-object-id>c17</left-object-id>\n             <right-object-id>c18</right-object-id>\n             <relation-formula>\n                 <left-object-column-id>l61</left-object-column-id>\n                 <right-object-column-id>l87</right-object-column-id>\n                 <object-columns-relation>=</object-columns-relation>\n             </relation-formula>\n        </object-relation-item>\n    </object-relation>\n<security>\n    <server-connection>\n        <server-connection-item>\n            <name>new ServerConnection</name>\n            <id>m1</id>\n            <type/>\n            <host>http://localhost:8080/FA/SecurityProvider</host>\n            <port/>\n            <user/>\n            <password/>\n            <description/>\n        </server-connection-item>\n    </server-connection>\n    <security-provider>\n    </security-provider>\n</security>\n<olap>\n\n    <defaultRoleName/>\n    <measureCaption/>\n    <UserDefinedFunctions>\n    </UserDefinedFunctions>\n    <Dimension-group>\n    </Dimension-group>\n    <Measure-group>\n    </Measure-group>\n    <Security-group>\n    </Security-group>\n    <Aggregate>\n    </Aggregate>\n    <Dimension>\n    <Dimension-item>\n        <id>g1</id>\n        <name>product</name>\n        <caption/>\n        <description/>\n        <dimension-group-id/>\n        <IsDate>false</IsDate>\n        <LoadMethod>cube_startup</LoadMethod>\n        <order/>\n        <Widget/>\n        <properties/>\n        <Hierarchy>\n            <id>n1</id>\n            <name>product</name>\n            <caption/>\n            <memberReaderClass/>\n            <allMemberCaption/>\n            <desc/>\n            <dimension-id>g1</dimension-id>\n            <hasAll>true</hasAll>\n            <allMember>All Product</allMember>\n            <defaultMember/>\n            <Level>\n                <id>o1</id>\n                <name>PRODUCTLINE</name>\n                <caption/>\n                <captionColumn/>\n                <formatter/>\n                <type/>\n                <levelType/>\n                <hideMemberIf/>\n                <ordinalItemId>l89</ordinalItemId>\n                <ordinalColumn/>\n                <level-nb>0</level-nb>\n                <hierarchy-parent-id>n1</hierarchy-parent-id>\n                <description/>\n                <uniqueMembers>false</uniqueMembers>\n                <dataobjectitem-code-id>l89</dataobjectitem-code-id>\n                <parent-dataobjectitem-id/>\n                <closure-dataobject-id/>\n                <closure-parent-dataobjectitem-id/>\n                <closure-child-dataobjectitem-id/>\n                <null-parent-value/>\n            </Level>\n            <Level>\n                <id>o2</id>\n                <name>PRODUCTNAME</name>\n                <caption/>\n                <captionColumn/>\n                <formatter/>\n                <type/>\n                <levelType/>\n                <hideMemberIf/>\n                <ordinalColumn/>\n                <level-nb>1</level-nb>\n                <hierarchy-parent-id>n1</hierarchy-parent-id>\n                <description/>\n                <uniqueMembers>false</uniqueMembers>\n                <dataobjectitem-code-id>l88</dataobjectitem-code-id>\n                <parent-dataobjectitem-id/>\n                <closure-dataobject-id/>\n                <closure-parent-dataobjectitem-id/>\n                <closure-child-dataobjectitem-id/>\n                <null-parent-value/>\n            </Level>\n        </Hierarchy>\n    </Dimension-item>\n    <Dimension-item>\n        <id>g2</id>\n        <name>time</name>\n        <caption/>\n        <description/>\n        <dimension-group-id/>\n        <IsDate>false</IsDate>\n        <LoadMethod>cube_startup</LoadMethod>\n        <order/>\n        <Widget/>\n        <properties/>\n        <Hierarchy>\n            <id>n2</id>\n            <name>time</name>\n            <caption/>\n            <memberReaderClass/>\n            <allMemberCaption/>\n            <desc/>\n            <dimension-id>g2</dimension-id>\n            <hasAll>true</hasAll>\n            <allMember>All  time</allMember>\n            <defaultMember/>\n            <Level>\n                <id>o3</id>\n                <name>YEAR_ID</name>\n                <caption/>\n                <captionColumn/>\n                <formatter/>\n                <type/>\n                <levelType/>\n                <hideMemberIf/>\n                <ordinalColumn/>\n                <level-nb>0</level-nb>\n                <hierarchy-parent-id>n2</hierarchy-parent-id>\n                <description/>\n                <uniqueMembers>false</uniqueMembers>\n                <dataobjectitem-code-id>l105</dataobjectitem-code-id>\n                <parent-dataobjectitem-id/>\n                <closure-dataobject-id/>\n                <closure-parent-dataobjectitem-id/>\n                <closure-child-dataobjectitem-id/>\n                <null-parent-value/>\n            </Level>\n            <Level>\n                <id>o4</id>\n                <name>MONTH_NAME</name>\n                <caption/>\n                <captionColumn/>\n                <formatter/>\n                <type/>\n                <levelType/>\n                <hideMemberIf/>\n                <ordinalColumn/>\n                <level-nb>1</level-nb>\n                <hierarchy-parent-id>n2</hierarchy-parent-id>\n                <description/>\n                <uniqueMembers>false</uniqueMembers>\n                <dataobjectitem-code-id>l106</dataobjectitem-code-id>\n                <parent-dataobjectitem-id/>\n                <closure-dataobject-id/>\n                <closure-parent-dataobjectitem-id/>\n                <closure-child-dataobjectitem-id/>\n                <null-parent-value/>\n            </Level>\n        </Hierarchy>\n    </Dimension-item>\n    <Dimension-item>\n        <id>g3</id>\n        <name>customers</name>\n        <caption/>\n        <description/>\n        <dimension-group-id/>\n        <IsDate>false</IsDate>\n        <LoadMethod>cube_startup</LoadMethod>\n        <order/>\n        <Widget/>\n        <properties/>\n        <Hierarchy>\n            <id>n3</id>\n            <name>c</name>\n            <caption/>\n            <memberReaderClass/>\n            <allMemberCaption/>\n            <desc/>\n            <dimension-id>g3</dimension-id>\n            <hasAll>true</hasAll>\n            <allMember>All customers</allMember>\n            <defaultMember/>\n            <Level>\n                <id>o5</id>\n                <name>COUNTRY</name>\n                <caption/>\n                <captionColumn/>\n                <formatter/>\n                <type/>\n                <levelType/>\n                <hideMemberIf/>\n                <ordinalColumn/>\n                <level-nb>1</level-nb>\n                <hierarchy-parent-id>n3</hierarchy-parent-id>\n                <description/>\n                <uniqueMembers>false</uniqueMembers>\n                <dataobjectitem-code-id>l25</dataobjectitem-code-id>\n                <parent-dataobjectitem-id/>\n                <closure-dataobject-id/>\n                <closure-parent-dataobjectitem-id/>\n                <closure-child-dataobjectitem-id/>\n                <null-parent-value/>\n            </Level>\n            <Level>\n                <id>o6</id>\n                <name>CUSTOMERNAME</name>\n                <caption/>\n                <captionColumn/>\n                <formatter/>\n                <type/>\n                <levelType/>\n                <hideMemberIf/>\n                <ordinalColumn/>\n                <level-nb>1</level-nb>\n                <hierarchy-parent-id>n3</hierarchy-parent-id>\n                <description/>\n                <uniqueMembers>false</uniqueMembers>\n                <dataobjectitem-code-id>l16</dataobjectitem-code-id>\n                <parent-dataobjectitem-id/>\n                <closure-dataobject-id/>\n                <closure-parent-dataobjectitem-id/>\n                <closure-child-dataobjectitem-id/>\n                <null-parent-value/>\n            </Level>\n        </Hierarchy>\n    </Dimension-item>\n    </Dimension>\n    <Measure>\n    <Measure-item>\n        <id>h1</id>\n        <name>QUANTITYORDERED</name>\n        <caption/>\n        <description/>\n        <measure-group-id/>\n        <type>physical</type>\n        <order>0</order>\n        <origin-id>l62</origin-id>\n        <formula/>\n        <label/>\n        <visible>true</visible>\n        <aggregator>sum</aggregator>\n        <formatString>Standard</formatString>\n    </Measure-item>\n    <Measure-item>\n        <id>h2</id>\n        <name>TOTALPRICE</name>\n        <caption/>\n        <description/>\n        <measure-group-id/>\n        <type>physical</type>\n        <order>0</order>\n        <origin-id>l65</origin-id>\n        <formula/>\n        <label/>\n        <visible>true</visible>\n        <aggregator>sum</aggregator>\n        <formatString>Standard</formatString>\n    </Measure-item>\n    <Measure-item>\n        <id>h3</id>\n        <name>margin</name>\n        <caption/>\n        <description/>\n        <measure-group-id/>\n        <type>calculated</type>\n        <order>0</order>\n        <origin-id/>\n        <formula>[Measures].[QUANTITYORDERED]*[Measures].[TOTALPRICE]</formula>\n        <label/>\n        <visible>false</visible>\n        <aggregator>sum</aggregator>\n        <formatString>Standard</formatString>\n        <dimensionName>Measures</dimensionName>\n    </Measure-item>\n    </Measure>\n    <Cube>\n    <Cube-item>\n        <id>i1</id>\n        <name>sales</name>\n        <defaultMeasure/>\n        <enabled>true</enabled>\n        <cached>true</cached>\n        <description/>\n        <type>Rolap</type>\n        <physical-name/>\n        <cube-location/>\n        <fact-dataobject-id>c17</fact-dataobject-id>\n        <datasource-id>t2</datasource-id>\n        <dimension-item-id>g1</dimension-item-id>\n        <dimension-item-id>g2</dimension-item-id>\n        <dimension-item-id>g3</dimension-item-id>\n        <measure-item-id>h1</measure-item-id>\n        <measure-item-id>h2</measure-item-id>\n        <measure-item-id>h3</measure-item-id>\n    </Cube-item>\n    </Cube>\n    <VirtualCube>\n    </VirtualCube>\n    <NamedSets>\n    </NamedSets>\n    <DimensionViews>\n    <DimensionView-item>\n        <id>j57</id>\n        <name>PRODUCTLINE view</name>\n        <description/>\n        <dimension-id>g1</dimension-id>\n    </DimensionView-item>\n    <DimensionView-item>\n        <id>j58</id>\n        <name>YEAR_ID view</name>\n        <description/>\n        <dimension-id>g2</dimension-id>\n    </DimensionView-item>\n    <DimensionView-item>\n        <id>j59</id>\n        <name>c view</name>\n        <description/>\n        <dimension-id>g3</dimension-id>\n    </DimensionView-item>\n    </DimensionViews>\n</olap>\n\n</freeanalysis-schema>',0,''),
 (7,'','','2008-05-22 00:00:00','2008-05-22 00:00:00','','','','<freeanalysis-schema>\n    <version>2.0</version>\n    <id>7</id>\n    <isSynchronized>false</isSynchronized>\n    <document-properties>\n        <name/>\n        <author/>\n        <description/>\n        <creation-date>2008-05-22</creation-date>\n        <modification-date>2008-05-22</modification-date>\n        <version/>\n        <icon/>\n        <flyover-icon/>\n    </document-properties>\n\n    <datasources>\n        <datasource-item>\n            <name/>\n            <id>t2</id>\n            <connection>\n                <name/>\n                <id>a3</id>\n                <type>DataBase</type>\n                <data-source-location/>\n                <server-id/>\n                <driver>com.mysql.jdbc.Driver</driver>\n                <schema-name/>\n                <url>jdbc:mysql://localhost/sampledata</url>\n                <transformation-url/>\n                <file-location/>\n                <user>root</user>\n                <password>root</password>\n                <description/>\n            </connection>\n            <dataobject-item>\n            	<id>c25</id>\n                <name>quadrant_actuals</name>\n                <data-source-id>t2</data-source-id>\n                <server-id/>\n                <data-object-type>fact</data-object-type>\n                <select-statment-definition>SELECT * FROM quadrant_actuals</select-statment-definition>\n                <transformation-name/>\n                <file-name/>\n                <description/>\n                <isInline>false</isInline>\n                <item>\n                    <id>l131</id>\n                    <name>REGION</name>\n                    <origin>REGION</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l132</id>\n                    <name>DEPARTMENT</name>\n                    <origin>DEPARTMENT</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l133</id>\n                    <name>POSITIONTITLE</name>\n                    <origin>POSITIONTITLE</origin>\n                    <type>physical</type>\n                    <classe>java.lang.String</classe>\n                    <sql-type>VARCHAR</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l134</id>\n                    <name>ACTUAL</name>\n                    <origin>ACTUAL</origin>\n                    <type>physical</type>\n                    <classe>java.math.BigDecimal</classe>\n                    <sql-type>DECIMAL</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l135</id>\n                    <name>BUDGET</name>\n                    <origin>BUDGET</origin>\n                    <type>physical</type>\n                    <classe>java.math.BigDecimal</classe>\n                    <sql-type>DECIMAL</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n                <item>\n                    <id>l136</id>\n                    <name>VARIANCE</name>\n                    <origin>VARIANCE</origin>\n                    <type>physical</type>\n                    <classe>java.math.BigDecimal</classe>\n                    <sql-type>DECIMAL</sql-type>\n                    <attribut>U</attribut>\n                    <description/>\n                </item>\n            </dataobject-item>\n        </datasource-item>\n    </datasources>\n    <object-relation>\n    </object-relation>\n<security>\n    <server-connection>\n        <server-connection-item>\n            <name>new ServerConnection</name>\n            <id>m1</id>\n            <type/>\n            <host>http://localhost:8080/FA/SecurityProvider</host>\n            <port/>\n            <user/>\n            <password/>\n            <description/>\n        </server-connection-item>\n    </server-connection>\n    <security-provider>\n    </security-provider>\n</security>\n<olap>\n\n    <defaultRoleName/>\n    <measureCaption/>\n    <UserDefinedFunctions>\n    </UserDefinedFunctions>\n    <Dimension-group>\n    </Dimension-group>\n    <Measure-group>\n    </Measure-group>\n    <Security-group>\n    </Security-group>\n    <Aggregate>\n    </Aggregate>\n    <Dimension>\n    <Dimension-item>\n        <id>g1</id>\n        <name>location</name>\n        <caption/>\n        <description/>\n        <dimension-group-id/>\n        <IsDate>false</IsDate>\n        <LoadMethod>cube_startup</LoadMethod>\n        <order/>\n        <Widget/>\n        <properties/>\n        <Hierarchy>\n            <id>n1</id>\n            <name/>\n            <caption/>\n            <memberReaderClass/>\n            <allMemberCaption/>\n            <desc/>\n            <dimension-id>g1</dimension-id>\n            <hasAll>true</hasAll>\n            <allMember>All location</allMember>\n            <defaultMember/>\n            <Level>\n                <id>o1</id>\n                <name>REGION</name>\n                <caption/>\n                <captionColumn/>\n                <formatter/>\n                <type/>\n                <levelType/>\n                <hideMemberIf/>\n                <ordinalColumn/>\n                <level-nb>0</level-nb>\n                <hierarchy-parent-id>n1</hierarchy-parent-id>\n                <description/>\n                <uniqueMembers>false</uniqueMembers>\n                <dataobjectitem-code-id>l131</dataobjectitem-code-id>\n                <parent-dataobjectitem-id/>\n                <closure-dataobject-id/>\n                <closure-parent-dataobjectitem-id/>\n                <closure-child-dataobjectitem-id/>\n                <null-parent-value/>\n            </Level>\n            <Level>\n                <id>o2</id>\n                <name>DEPARTMENT</name>\n                <caption/>\n                <captionColumn/>\n                <formatter/>\n                <type/>\n                <levelType/>\n                <hideMemberIf/>\n                <ordinalColumn/>\n                <level-nb>1</level-nb>\n                <hierarchy-parent-id>n1</hierarchy-parent-id>\n                <description/>\n                <uniqueMembers>false</uniqueMembers>\n                <dataobjectitem-code-id>l132</dataobjectitem-code-id>\n                <parent-dataobjectitem-id/>\n                <closure-dataobject-id/>\n                <closure-parent-dataobjectitem-id/>\n                <closure-child-dataobjectitem-id/>\n                <null-parent-value/>\n            </Level>\n        </Hierarchy>\n    </Dimension-item>\n    <Dimension-item>\n        <id>g3</id>\n        <name>position</name>\n        <caption/>\n        <description/>\n        <dimension-group-id/>\n        <IsDate>false</IsDate>\n        <LoadMethod>cube_startup</LoadMethod>\n        <order/>\n        <Widget/>\n        <properties/>\n        <Hierarchy>\n            <id>n2</id>\n            <name/>\n            <caption/>\n            <memberReaderClass/>\n            <allMemberCaption/>\n            <desc/>\n            <dimension-id>g3</dimension-id>\n            <hasAll>true</hasAll>\n            <allMember>All position</allMember>\n            <defaultMember/>\n            <Level>\n                <id>o3</id>\n                <name>POSITIONTITLE</name>\n                <caption/>\n                <captionColumn/>\n                <formatter/>\n                <type/>\n                <levelType/>\n                <hideMemberIf/>\n                <ordinalColumn/>\n                <level-nb>0</level-nb>\n                <hierarchy-parent-id>n2</hierarchy-parent-id>\n                <description/>\n                <uniqueMembers>false</uniqueMembers>\n                <dataobjectitem-code-id>l133</dataobjectitem-code-id>\n                <parent-dataobjectitem-id/>\n                <closure-dataobject-id/>\n                <closure-parent-dataobjectitem-id/>\n                <closure-child-dataobjectitem-id/>\n                <null-parent-value/>\n            </Level>\n        </Hierarchy>\n    </Dimension-item>\n    </Dimension>\n    <Measure>\n    <Measure-item>\n        <id>h1</id>\n        <name>ACTUAL</name>\n        <caption/>\n        <description/>\n        <measure-group-id/>\n        <type>physical</type>\n        <order>0</order>\n        <origin-id>l134</origin-id>\n        <formula/>\n        <label/>\n        <visible>true</visible>\n        <aggregator>sum</aggregator>\n        <formatString>Standard</formatString>\n    </Measure-item>\n    <Measure-item>\n        <id>h2</id>\n        <name>BUDGET</name>\n        <caption/>\n        <description/>\n        <measure-group-id/>\n        <type>physical</type>\n        <order>0</order>\n        <origin-id>l135</origin-id>\n        <formula/>\n        <label/>\n        <visible>true</visible>\n        <aggregator>sum</aggregator>\n        <formatString>Standard</formatString>\n    </Measure-item>\n    <Measure-item>\n        <id>h3</id>\n        <name>margin</name>\n        <caption/>\n        <description/>\n        <measure-group-id/>\n        <type>calculated</type>\n        <order>0</order>\n        <origin-id/>\n        <formula>[Measures].[BUDGET]-[Measures].[ACTUAL]</formula>\n        <label/>\n        <visible>false</visible>\n        <aggregator/>\n        <formatString>Standard</formatString>\n        <property>\n            <name>FORMAT_STRING</name>\n            <expression>Iif([Measures].[margin]&lt;0, \'|($#,##0.00)|style=red\', \'|$#,##0.00|style=green\')</expression>\n        </property>\n        <dimensionName>Measures</dimensionName>\n    </Measure-item>\n    </Measure>\n    <Cube>\n    <Cube-item>\n        <id>i1</id>\n        <name>cube</name>\n        <defaultMeasure/>\n        <enabled>true</enabled>\n        <cached>true</cached>\n        <description/>\n        <type>Rolap</type>\n        <physical-name/>\n        <cube-location/>\n        <fact-dataobject-id>c25</fact-dataobject-id>\n        <datasource-id>t2</datasource-id>\n        <dimension-item-id>g1</dimension-item-id>\n        <dimension-item-id>g3</dimension-item-id>\n        <measure-item-id>h1</measure-item-id>\n        <measure-item-id>h2</measure-item-id>\n        <measure-item-id>h3</measure-item-id>\n    </Cube-item>\n    </Cube>\n    <VirtualCube>\n    </VirtualCube>\n    <NamedSets>\n    </NamedSets>\n    <DimensionViews>\n    <DimensionView-item>\n        <id>j1</id>\n        <name>location view</name>\n        <description/>\n        <dimension-id>g1</dimension-id>\n    </DimensionView-item>\n    <DimensionView-item>\n        <id>j2</id>\n        <name>position view</name>\n        <description/>\n        <dimension-id>g3</dimension-id>\n    </DimensionView-item>\n    </DimensionViews>\n</olap>\n\n</freeanalysis-schema>',0,'');
/*!40000 ALTER TABLE `fas_model` ENABLE KEYS */;


--
-- Definition of table `fas_namedset`
--

DROP TABLE IF EXISTS `fas_namedset`;
CREATE TABLE `fas_namedset` (
  `NAS_ID` int(11) DEFAULT NULL,
  `SCH_ID` int(11) DEFAULT NULL,
  `NAS_GLOBAL` text,
  `NAS_FORMULA` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_namedset`
--

/*!40000 ALTER TABLE `fas_namedset` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_namedset` ENABLE KEYS */;


--
-- Definition of table `fas_olapschema`
--

DROP TABLE IF EXISTS `fas_olapschema`;
CREATE TABLE `fas_olapschema` (
  `SCH_ID` int(11) DEFAULT NULL,
  `SCT_ID` int(11) DEFAULT NULL,
  `MODEL_ID` int(11) DEFAULT NULL,
  `SCHEMA_MESCAPTION` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_olapschema`
--

/*!40000 ALTER TABLE `fas_olapschema` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_olapschema` ENABLE KEYS */;


--
-- Definition of table `fas_parameter`
--

DROP TABLE IF EXISTS `fas_parameter`;
CREATE TABLE `fas_parameter` (
  `PAR_ID` int(11) DEFAULT NULL,
  `LVL_ID` int(11) DEFAULT NULL,
  `PAR_DESC` text,
  `PAR_TYPE` text,
  `PAR_MODIFIABLE` varchar(1) DEFAULT NULL,
  `PAR_DFAULTVALUE` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_parameter`
--

/*!40000 ALTER TABLE `fas_parameter` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_parameter` ENABLE KEYS */;


--
-- Definition of table `fas_property`
--

DROP TABLE IF EXISTS `fas_property`;
CREATE TABLE `fas_property` (
  `PROP_ID` int(11) DEFAULT NULL,
  `COL_ID` int(11) DEFAULT NULL,
  `LVL_ID` int(11) DEFAULT NULL,
  `PROP_CAPTION` text,
  `PROP_TYPE` text,
  `PROP_FORMATTER` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_property`
--

/*!40000 ALTER TABLE `fas_property` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_property` ENABLE KEYS */;


--
-- Definition of table `fas_rel_col`
--

DROP TABLE IF EXISTS `fas_rel_col`;
CREATE TABLE `fas_rel_col` (
  `RIGHT_COL_ID` int(11) DEFAULT NULL,
  `LEFT_COL_ID` int(11) DEFAULT NULL,
  `MODEL_ID` int(11) DEFAULT NULL,
  `REL_OPERATOR` varchar(2) DEFAULT NULL,
  `REL_NAME` text,
  `REL_PARENT` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_rel_col`
--

/*!40000 ALTER TABLE `fas_rel_col` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_rel_col` ENABLE KEYS */;


--
-- Definition of table `fas_sch_agg`
--

DROP TABLE IF EXISTS `fas_sch_agg`;
CREATE TABLE `fas_sch_agg` (
  `AGT_ID` int(11) DEFAULT NULL,
  `SCH_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_sch_agg`
--

/*!40000 ALTER TABLE `fas_sch_agg` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_sch_agg` ENABLE KEYS */;


--
-- Definition of table `fas_sch_cub`
--

DROP TABLE IF EXISTS `fas_sch_cub`;
CREATE TABLE `fas_sch_cub` (
  `SCH_ID` int(11) DEFAULT NULL,
  `CUB_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_sch_cub`
--

/*!40000 ALTER TABLE `fas_sch_cub` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_sch_cub` ENABLE KEYS */;


--
-- Definition of table `fas_sch_dim`
--

DROP TABLE IF EXISTS `fas_sch_dim`;
CREATE TABLE `fas_sch_dim` (
  `DIM_ID` int(11) DEFAULT NULL,
  `SCH_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_sch_dim`
--

/*!40000 ALTER TABLE `fas_sch_dim` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_sch_dim` ENABLE KEYS */;


--
-- Definition of table `fas_sch_dsr`
--

DROP TABLE IF EXISTS `fas_sch_dsr`;
CREATE TABLE `fas_sch_dsr` (
  `SCH_ID` int(11) DEFAULT NULL,
  `DSR_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_sch_dsr`
--

/*!40000 ALTER TABLE `fas_sch_dsr` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_sch_dsr` ENABLE KEYS */;


--
-- Definition of table `fas_sch_mes`
--

DROP TABLE IF EXISTS `fas_sch_mes`;
CREATE TABLE `fas_sch_mes` (
  `SCH_ID` int(11) DEFAULT NULL,
  `MES_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_sch_mes`
--

/*!40000 ALTER TABLE `fas_sch_mes` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_sch_mes` ENABLE KEYS */;


--
-- Definition of table `fas_sch_sgp`
--

DROP TABLE IF EXISTS `fas_sch_sgp`;
CREATE TABLE `fas_sch_sgp` (
  `SGP_ID` int(11) DEFAULT NULL,
  `SCH_ID` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_sch_sgp`
--

/*!40000 ALTER TABLE `fas_sch_sgp` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_sch_sgp` ENABLE KEYS */;


--
-- Definition of table `fas_schematype`
--

DROP TABLE IF EXISTS `fas_schematype`;
CREATE TABLE `fas_schematype` (
  `SCT_ID` int(11) DEFAULT NULL,
  `SCT_NAME` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_schematype`
--

/*!40000 ALTER TABLE `fas_schematype` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_schematype` ENABLE KEYS */;


--
-- Definition of table `fas_secugroup`
--

DROP TABLE IF EXISTS `fas_secugroup`;
CREATE TABLE `fas_secugroup` (
  `SGP_ID` int(11) DEFAULT NULL,
  `PARENT_SGP_ID` int(11) DEFAULT NULL,
  `SGP_DESC` text,
  `SGP_LVL` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_secugroup`
--

/*!40000 ALTER TABLE `fas_secugroup` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_secugroup` ENABLE KEYS */;


--
-- Definition of table `fas_server`
--

DROP TABLE IF EXISTS `fas_server`;
CREATE TABLE `fas_server` (
  `SRV_ID` int(11) DEFAULT NULL,
  `SRV_NAME` text,
  `SRV_HOST` text,
  `SRV_PORT` text,
  `SRV_LOGIN` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_server`
--

/*!40000 ALTER TABLE `fas_server` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_server` ENABLE KEYS */;


--
-- Definition of table `fas_userdeffunction`
--

DROP TABLE IF EXISTS `fas_userdeffunction`;
CREATE TABLE `fas_userdeffunction` (
  `UDF_NAME` text,
  `UDF_ID` int(11) DEFAULT NULL,
  `SCH_ID` int(11) DEFAULT NULL,
  `UDF_CLASSNAME` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fas_userdeffunction`
--

/*!40000 ALTER TABLE `fas_userdeffunction` DISABLE KEYS */;
/*!40000 ALTER TABLE `fas_userdeffunction` ENABLE KEYS */;


--
-- Definition of table `fd_model`
--

DROP TABLE IF EXISTS `fd_model`;
CREATE TABLE `fd_model` (
  `FD_ID` int(11) DEFAULT NULL,
  `FD_AUTHOR` varchar(45) DEFAULT NULL,
  `FD_DESC` varchar(45) DEFAULT NULL,
  `FD_CREATION` datetime DEFAULT NULL,
  `FD_MODIF` datetime DEFAULT NULL,
  `FD_ICON` varchar(45) DEFAULT NULL,
  `FD_FLYOVER` varchar(45) DEFAULT NULL,
  `FD_NAME` varchar(45) DEFAULT NULL,
  `FD_VERSION` varchar(45) DEFAULT NULL,
  `FD_XML` mediumtext
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fd_model`
--

/*!40000 ALTER TABLE `fd_model` DISABLE KEYS */;
/*!40000 ALTER TABLE `fd_model` ENABLE KEYS */;


--
-- Definition of table `fmdt_model`
--

DROP TABLE IF EXISTS `fmdt_model`;
CREATE TABLE `fmdt_model` (
  `FMDT_ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `FMDT_DESC` varchar(45) DEFAULT NULL,
  `FMDT_CREATION_DATE` datetime DEFAULT NULL,
  `FMDT_MODIFICATION_DATE` datetime DEFAULT NULL,
  `FMDT_VERSION` varchar(45) DEFAULT NULL,
  `FMDT_ICON` varchar(45) DEFAULT NULL,
  `FMDT_FLYOVER` varchar(45) DEFAULT NULL,
  `FMDT_NAME` varchar(45) DEFAULT NULL,
  `FMDT_XML` mediumtext,
  `FMDT_AUTHOR` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`FMDT_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fmdt_model`
--

/*!40000 ALTER TABLE `fmdt_model` DISABLE KEYS */;
INSERT INTO `fmdt_model` (`FMDT_ID`,`FMDT_DESC`,`FMDT_CREATION_DATE`,`FMDT_MODIFICATION_DATE`,`FMDT_VERSION`,`FMDT_ICON`,`FMDT_FLYOVER`,`FMDT_NAME`,`FMDT_XML`,`FMDT_AUTHOR`) VALUES 
 (1,'','2008-05-19 00:00:00','2008-05-19 00:00:00','','','','','<freeMetaData>\n    <document-properties>\n        <name/>\n        <author/>\n        <description/>\n        <creation>2008-05-19</creation>\n        <modification>2008-05-19</modification>\n        <version/>\n        <icon/>\n        <flyover/>\n    </document-properties>\n\n    <sqlDataSource>\n        <name>sampledata</name>\n        <sqlConnection>\n            <driverName>Hypersonic</driverName>\n            <methodName>Jdbc</methodName>\n            <host>localhost</host>\n            <dataBaseName>sampledata</dataBaseName>\n            <portNumber>9001</portNumber>\n            <username>sa</username>\n            <password/>\n        </sqlConnection>\n        <dataStream>\n            <name>time</name>\n            <description/>\n            <outputLength>100</outputLength>\n            <weight>0</weight>\n            <type>0</type>\n            <origin>TIME</origin>\n                <dataStreamElement>\n                     <name>QTR_ID</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>TIME.QTR_ID</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>QTR_DESC</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>TIME.QTR_DESC</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>TIME_ID</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>TIME.TIME_ID</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>MONTH_DESC</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>TIME.MONTH_DESC</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>QTR_NAME</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>TIME.QTR_NAME</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>MONTH_NAME</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>TIME.MONTH_NAME</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>YEAR_ID</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>TIME.YEAR_ID</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>MONTH_ID</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>TIME.MONTH_ID</origin>\n                </dataStreamElement>\n        </dataStream>\n        <dataStream>\n            <name>orderfact</name>\n            <description/>\n            <outputLength>100</outputLength>\n            <weight>0</weight>\n            <type>0</type>\n            <origin>ORDERFACT</origin>\n                <dataStreamElement>\n                     <name>ORDERNUMBER</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.ORDERNUMBER</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>TOTALPRICE</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.TOTALPRICE</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>PRODUCTCODE</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.PRODUCTCODE</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>COMMENTS</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.COMMENTS</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>ORDERLINENUMBER</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.ORDERLINENUMBER</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>REQUIREDDATE</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.REQUIREDDATE</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>PRICEEACH</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.PRICEEACH</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>STATUS</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.STATUS</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>QTR_ID</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.QTR_ID</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>TIME_ID</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.TIME_ID</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>QUANTITYORDERED</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.QUANTITYORDERED</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>SHIPPEDDATE</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.SHIPPEDDATE</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>CUSTOMERNUMBER</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.CUSTOMERNUMBER</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>ORDERDATE</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.ORDERDATE</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>YEAR_ID</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.YEAR_ID</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>MONTH_ID</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>ORDERFACT.MONTH_ID</origin>\n                </dataStreamElement>\n        </dataStream>\n        <dataStream>\n            <name>payments</name>\n            <description/>\n            <outputLength>100</outputLength>\n            <weight>0</weight>\n            <type>0</type>\n            <origin>PAYMENTS</origin>\n                <dataStreamElement>\n                     <name>CHECKNUMBER</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>PAYMENTS.CHECKNUMBER</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>CUSTOMERNUMBER</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>PAYMENTS.CUSTOMERNUMBER</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>AMOUNT</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>PAYMENTS.AMOUNT</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>PAYMENTDATE</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>PAYMENTS.PAYMENTDATE</origin>\n                </dataStreamElement>\n        </dataStream>\n        <dataStream>\n            <name>customers</name>\n            <description/>\n            <outputLength>100</outputLength>\n            <weight>0</weight>\n            <type>0</type>\n            <origin>CUSTOMERS</origin>\n                <dataStreamElement>\n                     <name>STATE</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>CUSTOMERS.STATE</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>ADDRESSLINE1</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>CUSTOMERS.ADDRESSLINE1</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>ADDRESSLINE2</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>CUSTOMERS.ADDRESSLINE2</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>COUNTRY</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>CUSTOMERS.COUNTRY</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>CONTACTFIRSTNAME</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>CUSTOMERS.CONTACTFIRSTNAME</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>CUSTOMERNAME</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>CUSTOMERS.CUSTOMERNAME</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>CONTACTLASTNAME</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>CUSTOMERS.CONTACTLASTNAME</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>PHONE</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>CUSTOMERS.PHONE</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>SALESREPEMPLOYEENUMBER</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>CUSTOMERS.SALESREPEMPLOYEENUMBER</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>POSTALCODE</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>CUSTOMERS.POSTALCODE</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>CREDITLIMIT</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>CUSTOMERS.CREDITLIMIT</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>CUSTOMERNUMBER</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>CUSTOMERS.CUSTOMERNUMBER</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>CITY</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>CUSTOMERS.CITY</origin>\n                </dataStreamElement>\n        </dataStream>\n        <dataStream>\n            <name>products</name>\n            <description/>\n            <outputLength>100</outputLength>\n            <weight>0</weight>\n            <type>0</type>\n            <origin>PRODUCTS</origin>\n                <dataStreamElement>\n                     <name>MSRP</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>PRODUCTS.MSRP</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>PRODUCTNAME</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>PRODUCTS.PRODUCTNAME</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>PRODUCTDESCRIPTION</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>PRODUCTS.PRODUCTDESCRIPTION</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>PRODUCTVENDOR</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>PRODUCTS.PRODUCTVENDOR</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>PRODUCTSCALE</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>PRODUCTS.PRODUCTSCALE</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>PRODUCTCODE</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>PRODUCTS.PRODUCTCODE</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>BUYPRICE</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>PRODUCTS.BUYPRICE</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>QUANTITYINSTOCK</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>PRODUCTS.QUANTITYINSTOCK</origin>\n                </dataStreamElement>\n                <dataStreamElement>\n                     <name>PRODUCTLINE</name>\n                     <description/>\n                     <fontName>Arial</fontName>\n                     <textColor>000000</textColor>\n                     <backgroundColor>FFFFFF</backgroundColor>\n                     <origin>PRODUCTS.PRODUCTLINE</origin>\n                </dataStreamElement>\n        </dataStream>\n            <relation>\n                <leftDataStream>time</leftDataStream>\n                <rightDataStream>orderfact</rightDataStream>\n                <join>\n                    <left>TIME_ID</left>\n                    <right>TIME_ID</right>\n                </join>\n            </relation>\n            <relation>\n                <leftDataStream>payments</leftDataStream>\n                <rightDataStream>customers</rightDataStream>\n                <join>\n                    <left>CUSTOMERNUMBER</left>\n                    <right>CUSTOMERNUMBER</right>\n                </join>\n            </relation>\n            <relation>\n                <leftDataStream>products</leftDataStream>\n                <rightDataStream>orderfact</rightDataStream>\n                <join>\n                    <left>PRODUCTCODE</left>\n                    <right>PRODUCTCODE</right>\n                </join>\n            </relation>\n    </sqlDataSource>\n    <businessModel>\n        <name>Accounts</name>\n        <description/>\n        <businessTable>\n            <name>Customers</name>\n            <description/>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>STATE</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>ADDRESSLINE1</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>ADDRESSLINE2</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>COUNTRY</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>CONTACTFIRSTNAME</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>CUSTOMERNAME</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>CONTACTLASTNAME</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>PHONE</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>SALESREPEMPLOYEENUMBER</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>POSTALCODE</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>CREDITLIMIT</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>CUSTOMERNUMBER</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>CITY</dataStreamElementName>\n            </column>\n            <outputname>\n                <country>FR</country>\n                <language>fr</language>\n                <value>Customers</value>\n            </outputname>\n        </businessTable>\n        <businessTable>\n            <name>Products</name>\n            <description/>\n            <column>\n                <dataStreamName>products</dataStreamName>\n                <dataStreamElementName>PRODUCTNAME</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>products</dataStreamName>\n                <dataStreamElementName>MSRP</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>products</dataStreamName>\n                <dataStreamElementName>PRODUCTVENDOR</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>products</dataStreamName>\n                <dataStreamElementName>PRODUCTDESCRIPTION</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>products</dataStreamName>\n                <dataStreamElementName>PRODUCTSCALE</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>products</dataStreamName>\n                <dataStreamElementName>PRODUCTCODE</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>products</dataStreamName>\n                <dataStreamElementName>QUANTITYINSTOCK</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>products</dataStreamName>\n                <dataStreamElementName>BUYPRICE</dataStreamElementName>\n            </column>\n            <outputname>\n                <country>FR</country>\n                <language>fr</language>\n                <value>Products</value>\n            </outputname>\n        </businessTable>\n        <businessTable>\n            <name>OrderFact</name>\n            <description/>\n            <column>\n                <dataStreamName>orderfact</dataStreamName>\n                <dataStreamElementName>ORDERNUMBER</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>orderfact</dataStreamName>\n                <dataStreamElementName>TOTALPRICE</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>orderfact</dataStreamName>\n                <dataStreamElementName>PRODUCTCODE</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>orderfact</dataStreamName>\n                <dataStreamElementName>QUANTITYORDERED</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>orderfact</dataStreamName>\n                <dataStreamElementName>REQUIREDDATE</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>orderfact</dataStreamName>\n                <dataStreamElementName>PRICEEACH</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>orderfact</dataStreamName>\n                <dataStreamElementName>STATUS</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>CUSTOMERNAME</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>time</dataStreamName>\n                <dataStreamElementName>MONTH_NAME</dataStreamElementName>\n            </column>\n            <outputname>\n                <country>FR</country>\n                <language>fr</language>\n                <value>OrderFact</value>\n            </outputname>\n        </businessTable>\n        <businessTable>\n            <name>Payments</name>\n            <description/>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>PHONE</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>payments</dataStreamName>\n                <dataStreamElementName>CHECKNUMBER</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>STATE</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>ADDRESSLINE1</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>COUNTRY</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>ADDRESSLINE2</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>CONTACTFIRSTNAME</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>payments</dataStreamName>\n                <dataStreamElementName>AMOUNT</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>CONTACTLASTNAME</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>customers</dataStreamName>\n                <dataStreamElementName>CUSTOMERNAME</dataStreamElementName>\n            </column>\n            <column>\n                <dataStreamName>payments</dataStreamName>\n                <dataStreamElementName>PAYMENTDATE</dataStreamElementName>\n            </column>\n            <outputname>\n                <country>FR</country>\n                <language>fr</language>\n                <value>Payments</value>\n            </outputname>\n        </businessTable>\n            <relation>\n                <leftDataStream>time</leftDataStream>\n                <rightDataStream>orderfact</rightDataStream>\n                <join>\n                    <left>TIME_ID</left>\n                    <right>TIME_ID</right>\n                </join>\n            </relation>\n            <relation>\n                <leftDataStream>payments</leftDataStream>\n                <rightDataStream>customers</rightDataStream>\n                <join>\n                    <left>CUSTOMERNUMBER</left>\n                    <right>CUSTOMERNUMBER</right>\n                </join>\n            </relation>\n            <relation>\n                <leftDataStream>products</leftDataStream>\n                <rightDataStream>orderfact</rightDataStream>\n                <join>\n                    <left>PRODUCTCODE</left>\n                    <right>PRODUCTCODE</right>\n                </join>\n            </relation>\n        <lov>\n            <name>AmountSum</name>\n            <dataStreamElement>AMOUNT</dataStreamElement>\n            <dataStream>payments</dataStream>\n        </lov>\n        <businessPackage>\n            <name>Finance</name>\n            <description>For finance department</description>\n        <businessTableName>Customers</businessTableName>\n        <businessTableName>Payments</businessTableName>\n        </businessPackage>\n        <businessPackage>\n            <name>Invoice</name>\n            <description>Invoice Request</description>\n        <businessTableName>Customers</businessTableName>\n        <businessTableName>Products</businessTableName>\n        <businessTableName>OrderFact</businessTableName>\n        <businessTableName>Payments</businessTableName>\n        </businessPackage>\n    </businessModel>\n        <lov>\n            <name>AmountSum</name>\n            <dataStreamElement>AMOUNT</dataStreamElement>\n            <dataStream>payments</dataStream>\n        </lov>\n</freeMetaData>',''),
 (2,'','2008-05-19 00:00:00','2008-05-19 00:00:00','','','','','<freeMetaData>\n    <document-properties>\n        <name/>\n        <author/>\n        <description/>\n        <creation>2008-05-19</creation>\n        <modification>2008-05-19</mod