CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE FAS_AGG_MES(MES_ID INTEGER,COL_ID INTEGER,AGT_ID INTEGER)
CREATE MEMORY TABLE FAS_AGGEXCLUDE(AEX_ID INTEGER,AEX_PATTERN VARCHAR(65535),AEX_CESENSITVIE CHAR(1))
CREATE MEMORY TABLE FAS_AGGLVL(LVL_ID INTEGER,COL_ID INTEGER,AGT_ID INTEGER)
CREATE MEMORY TABLE FAS_AGGTABLE(AGT_ID INTEGER,TAB_ID INTEGER,AGT_FACTCOUNT INTEGER)
CREATE MEMORY TABLE FAS_CONNECTION(CON_ID INTEGER,SRV_ID INTEGER,CON_TYPE VARCHAR(65535),CON_DSRLOCATION VARCHAR(65535),CON_DRIVER VARCHAR(65535),CON_URL VARCHAR(65535),CON_PASSWORD VARCHAR(65535),CON_LOGIN VARCHAR(65535),CON_FILELOC VARCHAR(65535),CON_TRURL VARCHAR(65535))
CREATE MEMORY TABLE FAS_CUB_AGG(CUB_ID INTEGER,AGT_ID INTEGER)
CREATE MEMORY TABLE FAS_CUB_AGGPATTERN(AEX_ID INTEGER,CUB_ID INTEGER,AGG_PATTERN VARCHAR(65535))
CREATE MEMORY TABLE FAS_CUB_DGP(CUB_ID INTEGER,DGP_ID INTEGER)
CREATE MEMORY TABLE FAS_CUB_MES(CUB_ID INTEGER,MES_ID INTEGER,OWNER_CUB_MES_ID INTEGER)
CREATE MEMORY TABLE FAS_CUB_MGP(MGP_ID INTEGER,CUB_ID INTEGER)
CREATE MEMORY TABLE FAS_CUB_NAS(NAS_ID INTEGER,CUB_ID INTEGER)
CREATE MEMORY TABLE FAS_CUB_SGP(SGP_ID INTEGER,CUB_ID INTEGER)
CREATE MEMORY TABLE FAS_CUBE(CUB_ID INTEGER,TAB_ID INTEGER,CUB_DESC VARCHAR(65535),CUB_TYPE VARCHAR(65535),CUB_PHYSNAME VARCHAR(65535),CUB_LOCATION VARCHAR(65535),CUB_ENABLED CHAR(1),CUB_CACHED CHAR(1),CUB_CAPTION VARCHAR(65535))
CREATE MEMORY TABLE FAS_DATAOBJECT(TAB_ID INTEGER,CHILD_COL_ID INTEGER,PARENT_COL_ID INTEGER,DSR_ID INTEGER,TAB_DESC VARCHAR(65535),TAB_TYPE VARCHAR(65535),TAB_SELECT VARCHAR(65535),TAB_TRNAME VARCHAR(65535),TAB_FILENAME VARCHAR(65535),TAB_CLOSURE CHAR(1))
CREATE MEMORY TABLE FAS_DATAOBJECTITEM(COL_ID INTEGER,TAB_ID INTEGER,COL_DESC VARCHAR(65535),COL_ORIGIN VARCHAR(65535),COL_TYPE VARCHAR(65535),COL_CLASSE VARCHAR(65535),COL_ATTRIB VARCHAR(65535))
CREATE MEMORY TABLE FAS_DATASOURCE(DSR_ID INTEGER,CON_ID INTEGER,DSR_NAME VARCHAR(65535))
CREATE MEMORY TABLE FAS_DIM_CUBE_REL(DIM_ID INTEGER,CUB_ID INTEGER)
CREATE MEMORY TABLE FAS_DIMENSION(DIM_ID INTEGER,DGP_ID INTEGER,DVW_ID INTEGER,DIM_DESC VARCHAR(65535),DIM_ISDATE VARCHAR(65535),DIM_LOAD VARCHAR(65535),DIM_ORDER INTEGER,DIM_WIDGET VARCHAR(65535))
CREATE MEMORY TABLE FAS_DIMGROUP(DGP_ID INTEGER,PARENT_DGP_ID INTEGER,SCH_ID INTEGER,DGP_DESC VARCHAR(65535),DGP_LVL VARCHAR(65535))
CREATE MEMORY TABLE FAS_DIMVIEW(DVW_ID INTEGER,DIM_ID INTEGER,DVW_NAME VARCHAR(65535),DVW_DESC VARCHAR(65535))
CREATE MEMORY TABLE FAS_GRANTS(GRA_ID INTEGER,SGP_ID INTEGER,DVW_ID INTEGER,GRA_NAME VARCHAR(65535),GRA_DESC VARCHAR(65535),GRA_ALLOW CHAR(1),GRA_ALLOWFULL CHAR(1))
CREATE MEMORY TABLE FAS_HIERARCHY(HIE_ID INTEGER,DIM_ID INTEGER,HIE_DESC VARCHAR(65535),HIE_HASALL CHAR(1),HIE_ALLNAME VARCHAR(65535),HIE_CAPTION VARCHAR(65535),HIE_READER VARCHAR(65535),HIE_ALLCAPTION VARCHAR(65535),HIE_DEFAULTMEMBER VARCHAR(65535))
CREATE MEMORY TABLE FAS_INLINED(TAB_ID INTEGER,COL_ID INTEGER,INL_VALUE VARCHAR(65535))
CREATE MEMORY TABLE FAS_LEVEL(LVL_ID INTEGER,CAPTION_COL_ID INTEGER,LVL_COL_ID INTEGER,LABEL_COL_ID2 INTEGER,DESC_COL_ID INTEGER,ORDINAL_COL_ID INTEGER,HIE_ID INTEGER,LVL_NUM INTEGER,LVL_DESC VARCHAR(65535),LVL_CAPTION VARCHAR(65535),LVL_FORMATTER VARCHAR(65535),LVL_TYPE VARCHAR(65535),LVL_HIDEIF VARCHAR(65535),LVL_ROWCOUNT INTEGER,LVL_UNIQUE CHAR(1),LVL_ISREAL CHAR(1),LVL_NULLPARVALUE VARCHAR(65535))
CREATE MEMORY TABLE FAS_LVL_CLOS(LVL_ID INTEGER,TAB_ID INTEGER)
CREATE MEMORY TABLE FAS_MEASURE(MES_ID INTEGER,LABEL_COL_ID INTEGER,MES_COL_ID INTEGER,MGP_ID INTEGER,MES_DESC VARCHAR(65535),MES_TYPE VARCHAR(65535),MES_ORDER INTEGER,MES_FORMULA VARCHAR(65535),MES_AGG VARCHAR(65535),MES_FORMATSTR VARCHAR(65535),MES_CAPTION VARCHAR(65535),MES_VISIBLE CHAR(1),MES_DIMNAME VARCHAR(65535))
CREATE MEMORY TABLE FAS_MEMBERRESTRICTION(RES_ID INTEGER,GRA_ID INTEGER,RES_NAME VARCHAR(65535))
CREATE MEMORY TABLE FAS_MGP(MGP_ID INTEGER,SCH_ID INTEGER,PARENT_MGP_ID INTEGER,MGP_DESC VARCHAR(65535),MGP_LVL INTEGER)
CREATE MEMORY TABLE FAS_MODEL(MODEL_ID INTEGER,MODEL_AUTHOR VARCHAR(65535),MODEL_DESC VARCHAR(65535),MODEL_CREATION TIMESTAMP,MODEL_MODIF TIMESTAMP,MODEL_ICON VARCHAR(65535),MODEL_FLYOVER VARCHAR(65535),MODEL_NAME VARCHAR(65535),MODEL_XML VARCHAR(65535),SCH_ID INTEGER,MODEL_VERSION VARCHAR(25))
CREATE MEMORY TABLE FAS_NAMEDSET(NAS_ID INTEGER,SCH_ID INTEGER,NAS_GLOBAL VARCHAR(65535),NAS_FORMULA VARCHAR(65535))
CREATE MEMORY TABLE FAS_OLAPSCHEMA(SCH_ID INTEGER,SCT_ID INTEGER,MODEL_ID INTEGER,SCHEMA_MESCAPTION VARCHAR(65535))
CREATE MEMORY TABLE FAS_PARAMETER(PAR_ID INTEGER,LVL_ID INTEGER,PAR_DESC VARCHAR(65535),PAR_TYPE VARCHAR(65535),PAR_MODIFIABLE CHAR(1),PAR_DFAULTVALUE VARCHAR(65535))
CREATE MEMORY TABLE FAS_PROPERTY(PROP_ID INTEGER,COL_ID INTEGER,LVL_ID INTEGER,PROP_CAPTION VARCHAR(65535),PROP_TYPE VARCHAR(65535),PROP_FORMATTER VARCHAR(65535))
CREATE MEMORY TABLE FAS_REL_COL(RIGHT_COL_ID INTEGER,LEFT_COL_ID INTEGER,MODEL_ID INTEGER,REL_OPERATOR VARCHAR(2),REL_NAME VARCHAR(65535),REL_PARENT INTEGER)
CREATE MEMORY TABLE FAS_SCH_AGG(AGT_ID INTEGER,SCH_ID INTEGER)
CREATE MEMORY TABLE FAS_SCH_CUB(SCH_ID INTEGER,CUB_ID INTEGER)
CREATE MEMORY TABLE FAS_SCH_DIM(DIM_ID INTEGER,SCH_ID INTEGER)
CREATE MEMORY TABLE FAS_SCH_DSR(SCH_ID INTEGER,DSR_ID INTEGER)
CREATE MEMORY TABLE FAS_SCH_MES(SCH_ID INTEGER,MES_ID INTEGER)
CREATE MEMORY TABLE FAS_SCH_SGP(SGP_ID INTEGER,SCH_ID INTEGER)
CREATE MEMORY TABLE FAS_SCHEMATYPE(SCT_ID INTEGER,SCT_NAME VARCHAR(65535))
CREATE MEMORY TABLE FAS_SECUGROUP(SGP_ID INTEGER,PARENT_SGP_ID INTEGER,SGP_DESC VARCHAR(65535),SGP_LVL INTEGER)
CREATE MEMORY TABLE FAS_SERVER(SRV_ID INTEGER,SRV_NAME VARCHAR(65535),SRV_HOST VARCHAR(65535),SRV_PORT VARCHAR(65535),SRV_LOGIN VARCHAR(65535))
CREATE MEMORY TABLE FAS_USERDEFFUNCTION(UDF_NAME VARCHAR(65535),UDF_ID INTEGER,SCH_ID INTEGER,UDF_CLASSNAME VARCHAR(65535))
CREATE MEMORY TABLE FD_MODEL(FD_ID INTEGER,FD_AUTHOR VARCHAR(45),FD_DESC VARCHAR(45),FD_CREATION TIMESTAMP,FD_MODIF TIMESTAMP,FD_ICON VARCHAR(45),FD_FLYOVER VARCHAR(45),FD_NAME VARCHAR(45),FD_VERSION VARCHAR(45),FD_XML VARCHAR(65535))
CREATE MEMORY TABLE REPORT_MODEL(REPORT_ID INTEGER,SCH_ID INTEGER,SCH_FASD_ID INTEGER,CUBE_NAME VARCHAR(65535),REPORT_AUTHOR VARCHAR(65535),REPORT_DESC VARCHAR(45),REPORT_CREATION TIMESTAMP,REPORT_MODIF TIMESTAMP,REPORT_NAME VARCHAR(45),REPORT_XML VARCHAR(65535))
CREATE MEMORY TABLE RPT_TYPE_ICON(ICON_ID INTEGER,OBJECT_TYPE VARCHAR(65535),OBJECT_IMAGE VARCHAR(65535))
CREATE MEMORY TABLE RPY_DIRECTORY(ID_DIRECTORY INTEGER,PARENT_ID INTEGER,DATE_CREATION TIMESTAMP,DATE_EFFACEMENT TIMESTAMP,IS_VISIBLE CHAR(1),NAME VARCHAR(65535),TYPE VARCHAR(65535),DELETE_BY VARCHAR(65535),COMMENT VARCHAR(65535),USER_ID INTEGER)
CREATE MEMORY TABLE RPY_DIRECTORY_ITEM(ID_ITEM INTEGER,ID_DIRECTORY INTEGER,DII_ID INTEGER,ISVISIBLE CHAR(1),DATE_CREATION TIMESTAMP,DATE_EFFACEMENT TIMESTAMP,DELETE_BY VARCHAR(65535),COMMENT VARCHAR(65535),USER_ID INTEGER)
CREATE MEMORY TABLE RPY_GROUPS(GR_ID INTEGER,GR_NAME VARCHAR(50),GR_COMMENT VARCHAR(100),GR_CREATION_DATE TIMESTAMP,GR_IMAGE VARCHAR(200),GR_CUSTOM_1 VARCHAR(80))
CREATE MEMORY TABLE RPY_ITEM(ID_ITEM INTEGER,ITEM_PROP_ID INTEGER,VISIBLE CHAR(1),NAME VARCHAR(65535),TYPE VARCHAR(65535),CREATION TIMESTAMP,MODIFICATION TIMESTAMP,DELETION TIMESTAMP,MODIFIER VARCHAR(65535),DELETER VARCHAR(65535),USER_ID INTEGER)
CREATE MEMORY TABLE RPY_ITEM_PROPERTIES(ITEM_PROP_ID INTEGER,ICON_ID INTEGER,STATUS VARCHAR(65535),INTERNAL_VERSION VARCHAR(65535),PUBLIC_VERSION VARCHAR(65535),CHECKOUT_STATUS VARCHAR(1),CHECKOUT_DATE TIMESTAMP,CHECKOUT_DEV_NAME VARCHAR(65535),CHECKIN_DATE TIMESTAMP,CHECKIN_DEV_NAME VARCHAR(65535),FAS_MODEL_ID INTEGER,FD_MODEL_ID INTEGER,FMDT_MODEL_ID INTEGER,FWR_MODEL_ID INTEGER,CUSTOM_MODEL_ID INTEGER)
CREATE MEMORY TABLE RPY_ROLES(RO_ID INTEGER,RO_NAME VARCHAR(50),RO_COMMENT VARCHAR(100),RO_CREATION_DATE TIMESTAMP,RO_IMAGE VARCHAR(200),RO_TYPE INTEGER,RO_CUSTOM_1 VARCHAR(80))
CREATE MEMORY TABLE RPY_USERS(US_ID INTEGER,US_NAME VARCHAR(60),US_PASSWORD VARCHAR(60),US_SURNAME VARCHAR(60),US_FONCTION VARCHAR(50),US_TELEPHONE VARCHAR(50),US_CELLULAR VARCHAR(50),US_SKYPE_NAME VARCHAR(50),US_SKYPE_NUMBER VARCHAR(50),US_BUSINESS_MAIL VARCHAR(50),US_PRIVATE_MAIL VARCHAR(50),US_CREATION_DATE TIMESTAMP,US_IMAGE VARCHAR(200),US_LOGIN VARCHAR(50))
CREATE MEMORY TABLE RPY_USERSGROUPS(UG_ID INTEGER,UG_USER_ID INTEGER,UG_GROUP_ID INTEGER,UG_CREATION_DATE TIMESTAMP,UG_COMMENT VARCHAR(250))
CREATE MEMORY TABLE RPY_USERSROLES(UR_ID INTEGER,UR_USER_ID INTEGER,UR_ROLE_ID INTEGER,UR_CREATION_DATE TIMESTAMP,UR_COMMENT VARCHAR(250))
CREATE MEMORY TABLE SEC_DIRECTORY_SECURED(SDS_ID INTEGER,SDS_DIRECTORY_ID INTEGER,SDS_GROUP_ID INTEGER,SDS_GRANT VARCHAR(1))
CREATE MEMORY TABLE SEC_OBJECT_SECURED(OS_ID INTEGER,OS_DI_ID INTEGER,OS_GROUP_ID INTEGER,OS_GRANT VARCHAR(1))
CREATE MEMORY TABLE SYS_VERSION(SVR_ID INTEGER,SVR_TYPE VARCHAR(65535),SVR_MAJOR_VERSION INTEGER,SVR_MINOR_VERSION INTEGER,SVR_DATE_CREATION TIMESTAMP,SVR_DATE_UPGRATE TIMESTAMP,ATTRIBUT_193 VARCHAR(10))
CREATE MEMORY TABLE FMDT_MODEL(FMDT_ID INTEGER,FMDT_DESC VARCHAR(200),FMDT_CREATION_DATE TIMESTAMP,FMDT_MODIFICATION_DATE TIMESTAMP,FMDT_VERSION VARCHAR(50),FMDT_ICON VARCHAR(200),FMDT_FLYOVER VARCHAR(200),FMDT_NAME VARCHAR(60),FMDT_XML VARCHAR(65535),FMDT_AUTHOR VARCHAR(50))
CREATE MEMORY TABLE FWR_MODEL(FWR_ID INTEGER,FWR_DESC VARCHAR(200),FWR_CREATION_DATE TIMESTAMP,FWR_MODIFICATION_DATE TIMESTAMP,FWR_VERSION VARCHAR(200),FWR_ICON VARCHAR(200),FWR_FLYOVER VARCHAR(200),FWR_NAME VARCHAR(200),FWR_XML VARCHAR(65535),FWR_AUTHOR VARCHAR(200))
CREATE MEMORY TABLE RPY_MODELS(MOD_ID INTEGER,MOD_CREATION_DATE TIMESTAMP,MOD_MODIFICATION_DATE TIMESTAMP,MOD_USER_ID INTEGER,MOD_XML VARCHAR(65535),MOD_TYPE VARCHAR(200),MOD_PENTAHO_PATH VARCHAR(200),MOD_PENTAHO_SOLUTION VARCHAR(200),MOD_XACTION VARCHAR(200))
CREATE MEMORY TABLE GED_DOCUMENTS(GED_ID INTEGER,GED_CREATION_DATE TIMESTAMP,GED_FORMAT VARCHAR(200),GED_PATH VARCHAR(200),GED_NAME VARCHAR(200))
CREATE MEMORY TABLE GED_KEYWORDS(KEY_ID INTEGER,KEY_DOC_ID INTEGER,KEY_VALUE VARCHAR(200))
CREATE MEMORY TABLE RPY_ANNOTATIONS(ANO_ID INTEGER,ANO_CREATION_DATE TIMESTAMP,ANO_DATE_BEGIN TIMESTAMP,ANO_DATE_END TIMESTAMP,ANO_TYPE INTEGER,ANO_GROUP INTEGER,ANO_COMMENT VARCHAR(65535),ANO_MODEL_ID INTEGER,ANO_MODEL_TYPE VARCHAR(200),ANO_CREATOR_ID INTEGER)
CREATE MEMORY TABLE RPY_HISTORIQUE(HST_ID INTEGER,HST_USER_ID INTEGER,HST_MODEL_ID INTEGER,HST_TYPE VARCHAR(200),HST_DII_ID INTEGER)
CREATE MEMORY TABLE RPY_WATCHLIST(WAL_ID INTEGER,WAL_CREATION_DATE TIMESTAMP,WAL_USER_ID INTEGER,WAL_DIRECTORY_ITEM_ID INTEGER)
CREATE MEMORY TABLE RPY_TIMING(TIM_ID INTEGER,TIM_DAY INTEGER,TIM_HOUR INTEGER,TIM_AUTHORIZED INTEGER,TIM_DII_ID INTEGER)
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 0 MILLIS
SET SCHEMA PUBLIC
INSERT INTO FAS_MODEL VALUES(1,'','','2008-03-13 00:00:00.000000000','2008-03-13 00:00:00.000000000','','','','<freeanalysis-schema>\u000a    <version>2.0</version>\u000a    <id>1</id>\u000a    <isSynchronized>true</isSynchronized>\u000a    <document-properties>\u000a        <name/>\u000a        <author/>\u000a        <description/>\u000a        <creation-date>2008-03-13</creation-date>\u000a        <modification-date>2008-03-13</modification-date>\u000a        <version/>\u000a        <icon/>\u000a        <flyover-icon/>\u000a    </document-properties>\u000a\u000a    <datasources>\u000a        <datasource-item>\u000a            <name>Foodmart</name>\u000a            <id>t2</id>\u000a            <connection>\u000a                <name/>\u000a                <id>a3</id>\u000a                <type>DataBase</type>\u000a                <data-source-location/>\u000a                <server-id/>\u000a                <driver>org.hsqldb.jdbcDriver</driver>\u000a                <schema-name/>\u000a                <url>jdbc:hsqldb:file:datas/foodmart/foodmart</url>\u000a                <transformation-url/>\u000a                <file-location/>\u000a                <user>sa</user>\u000a                <password/>\u000a                <description/>\u000a            </connection>\u000a            <dataobject-item>\u000a            \u0009<id>c11</id>\u000a                <name>INVENTORY_FACT_1998</name>\u000a                <data-source-id>t2</data-source-id>\u000a                <server-id/>\u000a                <data-object-type>fact</data-object-type>\u000a                <select-statment-definition>SELECT * FROM INVENTORY_FACT_1998</select-statment-definition>\u000a                <transformation-name/>\u000a                <file-name/>\u000a                <description/>\u000a                <isInline>false</isInline>\u000a                <item>\u000a                    <id>l1</id>\u000a                    <name>PRODUCT_ID</name>\u000a                    <origin>PRODUCT_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l2</id>\u000a                    <name>TIME_ID</name>\u000a                    <origin>TIME_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l3</id>\u000a                    <name>WAREHOUSE_ID</name>\u000a                    <origin>WAREHOUSE_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l4</id>\u000a                    <name>STORE_ID</name>\u000a                    <origin>STORE_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l5</id>\u000a                    <name>UNITS_ORDERED</name>\u000a                    <origin>UNITS_ORDERED</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l6</id>\u000a                    <name>UNITS_SHIPPED</name>\u000a                    <origin>UNITS_SHIPPED</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l7</id>\u000a                    <name>WAREHOUSE_SALES</name>\u000a                    <origin>WAREHOUSE_SALES</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.math.BigDecimal</classe>\u000a                    <sql-type>DECIMAL</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l8</id>\u000a                    <name>WAREHOUSE_COST</name>\u000a                    <origin>WAREHOUSE_COST</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.math.BigDecimal</classe>\u000a                    <sql-type>DECIMAL</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l9</id>\u000a                    <name>SUPPLY_TIME</name>\u000a                    <origin>SUPPLY_TIME</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>SMALLINT</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l10</id>\u000a                    <name>STORE_INVOICE</name>\u000a                    <origin>STORE_INVOICE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.math.BigDecimal</classe>\u000a                    <sql-type>DECIMAL</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a            </dataobject-item>\u000a            <dataobject-item>\u000a            \u0009<id>c12</id>\u000a                <name>TIME_BY_DAY</name>\u000a                <data-source-id>t2</data-source-id>\u000a                <server-id/>\u000a                <data-object-type>dimension</data-object-type>\u000a                <select-statment-definition>SELECT * FROM TIME_BY_DAY</select-statment-definition>\u000a                <transformation-name/>\u000a                <file-name/>\u000a                <description/>\u000a                <isInline>false</isInline>\u000a                <item>\u000a                    <id>l71</id>\u000a                    <name>TIME_ID</name>\u000a                    <origin>TIME_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l72</id>\u000a                    <name>THE_DATE</name>\u000a                    <origin>THE_DATE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.sql.Timestamp</classe>\u000a                    <sql-type>TIMESTAMP</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l73</id>\u000a                    <name>THE_DAY</name>\u000a                    <origin>THE_DAY</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l74</id>\u000a                    <name>THE_MONTH</name>\u000a                    <origin>THE_MONTH</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l75</id>\u000a                    <name>THE_YEAR</name>\u000a                    <origin>THE_YEAR</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>SMALLINT</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l76</id>\u000a                    <name>DAY_OF_MONTH</name>\u000a                    <origin>DAY_OF_MONTH</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>SMALLINT</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l77</id>\u000a                    <name>WEEK_OF_YEAR</name>\u000a                    <origin>WEEK_OF_YEAR</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l78</id>\u000a                    <name>MONTH_OF_YEAR</name>\u000a                    <origin>MONTH_OF_YEAR</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>SMALLINT</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l79</id>\u000a                    <name>QUARTER</name>\u000a                    <origin>QUARTER</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l80</id>\u000a                    <name>FISCAL_PERIOD</name>\u000a                    <origin>FISCAL_PERIOD</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a            </dataobject-item>\u000a            <dataobject-item>\u000a            \u0009<id>c13</id>\u000a                <name>WAREHOUSE</name>\u000a                <data-source-id>t2</data-source-id>\u000a                <server-id/>\u000a                <data-object-type>dimension</data-object-type>\u000a                <select-statment-definition>SELECT * FROM WAREHOUSE</select-statment-definition>\u000a                <transformation-name/>\u000a                <file-name/>\u000a                <description/>\u000a                <isInline>false</isInline>\u000a                <item>\u000a                    <id>l81</id>\u000a                    <name>WAREHOUSE_ID</name>\u000a                    <origin>WAREHOUSE_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l82</id>\u000a                    <name>WAREHOUSE_CLASS_ID</name>\u000a                    <origin>WAREHOUSE_CLASS_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l83</id>\u000a                    <name>STORES_ID</name>\u000a                    <origin>STORES_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l84</id>\u000a                    <name>WAREHOUSE_NAME</name>\u000a                    <origin>WAREHOUSE_NAME</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l85</id>\u000a                    <name>WA_ADDRESS1</name>\u000a                    <origin>WA_ADDRESS1</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l86</id>\u000a                    <name>WA_ADDRESS2</name>\u000a                    <origin>WA_ADDRESS2</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l87</id>\u000a                    <name>WA_ADDRESS3</name>\u000a                    <origin>WA_ADDRESS3</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l88</id>\u000a                    <name>WA_ADDRESS4</name>\u000a                    <origin>WA_ADDRESS4</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l89</id>\u000a                    <name>WAREHOUSE_CITY</name>\u000a                    <origin>WAREHOUSE_CITY</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l90</id>\u000a                    <name>WAREHOUSE_STATE_PROVINCE</name>\u000a                    <origin>WAREHOUSE_STATE_PROVINCE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l91</id>\u000a                    <name>WAREHOUSE_POSTAL_CODE</name>\u000a                    <origin>WAREHOUSE_POSTAL_CODE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l92</id>\u000a                    <name>WAREHOUSE_COUNTRY</name>\u000a                    <origin>WAREHOUSE_COUNTRY</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l93</id>\u000a                    <name>WAREHOUSE_OWNER_NAME</name>\u000a                    <origin>WAREHOUSE_OWNER_NAME</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l94</id>\u000a                    <name>WAREHOUSE_PHONE</name>\u000a                    <origin>WAREHOUSE_PHONE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l95</id>\u000a                    <name>WAREHOUSE_FAX</name>\u000a                    <origin>WAREHOUSE_FAX</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a            </dataobject-item>\u000a            <dataobject-item>\u000a            \u0009<id>c14</id>\u000a                <name>WAREHOUSE_CLASS</name>\u000a                <data-source-id>t2</data-source-id>\u000a                <server-id/>\u000a                <data-object-type>dimension</data-object-type>\u000a                <select-statment-definition>SELECT * FROM WAREHOUSE_CLASS</select-statment-definition>\u000a                <transformation-name/>\u000a                <file-name/>\u000a                <description/>\u000a                <isInline>false</isInline>\u000a                <item>\u000a                    <id>l96</id>\u000a                    <name>WAREHOUSE_CLASS_ID</name>\u000a                    <origin>WAREHOUSE_CLASS_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l97</id>\u000a                    <name>DESCRIPTION</name>\u000a                    <origin>DESCRIPTION</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a            </dataobject-item>\u000a            <dataobject-item>\u000a            \u0009<id>c15</id>\u000a                <name>STORE</name>\u000a                <data-source-id>t2</data-source-id>\u000a                <server-id/>\u000a                <data-object-type>dimension</data-object-type>\u000a                <select-statment-definition>SELECT * FROM STORE</select-statment-definition>\u000a                <transformation-name/>\u000a                <file-name/>\u000a                <description/>\u000a                <isInline>false</isInline>\u000a                <item>\u000a                    <id>l46</id>\u000a                    <name>STORE_ID</name>\u000a                    <origin>STORE_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l47</id>\u000a                    <name>STORE_TYPE</name>\u000a                    <origin>STORE_TYPE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l48</id>\u000a                    <name>REGION_ID</name>\u000a                    <origin>REGION_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l49</id>\u000a                    <name>STORE_NAME</name>\u000a                    <origin>STORE_NAME</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l50</id>\u000a                    <name>STORE_NUMBER</name>\u000a                    <origin>STORE_NUMBER</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l51</id>\u000a                    <name>STORE_STREET_ADDRESS</name>\u000a                    <origin>STORE_STREET_ADDRESS</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l52</id>\u000a                    <name>STORE_CITY</name>\u000a                    <origin>STORE_CITY</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l53</id>\u000a                    <name>STORE_STATE</name>\u000a                    <origin>STORE_STATE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l54</id>\u000a                    <name>STORE_POSTAL_CODE</name>\u000a                    <origin>STORE_POSTAL_CODE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l55</id>\u000a                    <name>STORE_COUNTRY</name>\u000a                    <origin>STORE_COUNTRY</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l56</id>\u000a                    <name>STORE_MANAGER</name>\u000a                    <origin>STORE_MANAGER</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l57</id>\u000a                    <name>STORE_PHONE</name>\u000a                    <origin>STORE_PHONE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l58</id>\u000a                    <name>STORE_FAX</name>\u000a                    <origin>STORE_FAX</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l59</id>\u000a                    <name>FIRST_OPENED_DATE</name>\u000a                    <origin>FIRST_OPENED_DATE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.sql.Timestamp</classe>\u000a                    <sql-type>TIMESTAMP</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l60</id>\u000a                    <name>LAST_REMODEL_DATE</name>\u000a                    <origin>LAST_REMODEL_DATE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.sql.Timestamp</classe>\u000a                    <sql-type>TIMESTAMP</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l61</id>\u000a                    <name>LEASE_SQFT</name>\u000a                    <origin>LEASE_SQFT</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l62</id>\u000a                    <name>STORE_SQFT</name>\u000a                    <origin>STORE_SQFT</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l63</id>\u000a                    <name>GROCERY_SQFT</name>\u000a                    <origin>GROCERY_SQFT</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l64</id>\u000a                    <name>FROZEN_SQFT</name>\u000a                    <origin>FROZEN_SQFT</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l65</id>\u000a                    <name>MEAT_SQFT</name>\u000a                    <origin>MEAT_SQFT</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l66</id>\u000a                    <name>COFFEE_BAR</name>\u000a                    <origin>COFFEE_BAR</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>CHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l67</id>\u000a                    <name>VIDEO_STORE</name>\u000a                    <origin>VIDEO_STORE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>CHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l68</id>\u000a                    <name>SALAD_BAR</name>\u000a                    <origin>SALAD_BAR</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>CHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l69</id>\u000a                    <name>PREPARED_FOOD</name>\u000a                    <origin>PREPARED_FOOD</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>CHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l70</id>\u000a                    <name>FLORIST</name>\u000a                    <origin>FLORIST</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>CHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a            </dataobject-item>\u000a        </datasource-item>\u000a    </datasources>\u000a    <object-relation>\u000a        <object-relation-item>\u000a             <id>l1</id>\u000a             <name>[INVENTORY_FACT_1998.TIME_ID] = [TIME_BY_DAY.TIME_ID]</name>\u000a             <left-object-id>c11</left-object-id>\u000a             <right-object-id>c12</right-object-id>\u000a             <relation-formula>\u000a                 <left-object-column-id>l2</left-object-column-id>\u000a                 <right-object-column-id>l71</right-object-column-id>\u000a                 <object-columns-relation>=</object-columns-relation>\u000a             </relation-formula>\u000a        </object-relation-item>\u000a        <object-relation-item>\u000a             <id>l2</id>\u000a             <name>[INVENTORY_FACT_1998.WAREHOUSE_ID] = [WAREHOUSE.WAREHOUSE_ID]</name>\u000a             <left-object-id>c11</left-object-id>\u000a             <right-object-id>c13</right-object-id>\u000a             <relation-formula>\u000a                 <left-object-column-id>l3</left-object-column-id>\u000a                 <right-object-column-id>l81</right-object-column-id>\u000a                 <object-columns-relation>=</object-columns-relation>\u000a             </relation-formula>\u000a        </object-relation-item>\u000a        <object-relation-item>\u000a             <id>l3</id>\u000a             <name>[INVENTORY_FACT_1998.STORE_ID] = [STORE.STORE_ID]</name>\u000a             <left-object-id>c11</left-object-id>\u000a             <right-object-id>c15</right-object-id>\u000a             <relation-formula>\u000a                 <left-object-column-id>l4</left-object-column-id>\u000a                 <right-object-column-id>l46</right-object-column-id>\u000a                 <object-columns-relation>=</object-columns-relation>\u000a             </relation-formula>\u000a        </object-relation-item>\u000a        <object-relation-item>\u000a             <id>l4</id>\u000a             <name>[WAREHOUSE_CLASS.WAREHOUSE_CLASS_ID] = [WAREHOUSE_CLASS.WAREHOUSE_CLASS_ID]</name>\u000a             <left-object-id>c14</left-object-id>\u000a             <right-object-id>c14</right-object-id>\u000a             <relation-formula>\u000a                 <left-object-column-id>l96</left-object-column-id>\u000a                 <right-object-column-id>l96</right-object-column-id>\u000a                 <object-columns-relation>=</object-columns-relation>\u000a             </relation-formula>\u000a        </object-relation-item>\u000a    </object-relation>\u000a<security>\u000a    <server-connection>\u000a    </server-connection>\u000a    <security-provider>\u000a    </security-provider>\u000a</security>\u000a<olap>\u000a\u000a    <defaultRoleName/>\u000a    <measureCaption/>\u000a    <UserDefinedFunctions>\u000a    </UserDefinedFunctions>\u000a    <Dimension-group>\u000a    </Dimension-group>\u000a    <Measure-group>\u000a    </Measure-group>\u000a    <Security-group>\u000a    </Security-group>\u000a    <Aggregate>\u000a    </Aggregate>\u000a    <Dimension>\u000a    <Dimension-item>\u000a        <id>g1</id>\u000a        <name>time</name>\u000a        <caption/>\u000a        <description/>\u000a        <dimension-group-id/>\u000a        <IsDate>false</IsDate>\u000a        <LoadMethod>cube_startup</LoadMethod>\u000a        <order/>\u000a        <Widget/>\u000a        <properties/>\u000a        <Hierarchy>\u000a            <id>n1</id>\u000a            <name/>\u000a            <caption/>\u000a            <memberReaderClass/>\u000a            <allMemberCaption/>\u000a            <desc/>\u000a            <dimension-id>g1</dimension-id>\u000a            <hasAll>true</hasAll>\u000a            <allMember>All  time</allMember>\u000a            <defaultMember/>\u000a            <Level>\u000a                <id>o1</id>\u000a                <name>QUARTER</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>0</level-nb>\u000a                <hierarchy-parent-id>n1</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l79</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a            <Level>\u000a                <id>o2</id>\u000a                <name>THE_MONTH</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>1</level-nb>\u000a                <hierarchy-parent-id>n1</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l74</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a        </Hierarchy>\u000a    </Dimension-item>\u000a    <Dimension-item>\u000a        <id>g2</id>\u000a        <name>warehouse</name>\u000a        <caption/>\u000a        <description/>\u000a        <dimension-group-id/>\u000a        <IsDate>false</IsDate>\u000a        <LoadMethod>cube_startup</LoadMethod>\u000a        <order/>\u000a        <Widget/>\u000a        <properties/>\u000a        <Hierarchy>\u000a            <id>n2</id>\u000a            <name/>\u000a            <caption/>\u000a            <memberReaderClass/>\u000a            <allMemberCaption/>\u000a            <desc/>\u000a            <dimension-id>g2</dimension-id>\u000a            <hasAll>true</hasAll>\u000a            <allMember>All  warehouse</allMember>\u000a            <defaultMember/>\u000a            <Level>\u000a                <id>o3</id>\u000a                <name>WAREHOUSE_COUNTRY</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>0</level-nb>\u000a                <hierarchy-parent-id>n2</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l92</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a            <Level>\u000a                <id>o4</id>\u000a                <name>WAREHOUSE_STATE_PROVINCE</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>1</level-nb>\u000a                <hierarchy-parent-id>n2</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l90</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a        </Hierarchy>\u000a    </Dimension-item>\u000a    <Dimension-item>\u000a        <id>g3</id>\u000a        <name>store</name>\u000a        <caption/>\u000a        <description/>\u000a        <dimension-group-id/>\u000a        <IsDate>false</IsDate>\u000a        <LoadMethod>cube_startup</LoadMethod>\u000a        <order/>\u000a        <Widget/>\u000a        <properties/>\u000a        <Hierarchy>\u000a            <id>n3</id>\u000a            <name/>\u000a            <caption/>\u000a            <memberReaderClass/>\u000a            <allMemberCaption/>\u000a            <desc/>\u000a            <dimension-id>g3</dimension-id>\u000a            <hasAll>true</hasAll>\u000a            <allMember>All  stores</allMember>\u000a            <defaultMember/>\u000a            <Level>\u000a                <id>o5</id>\u000a                <name>STORE_COUNTRY</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>0</level-nb>\u000a                <hierarchy-parent-id>n3</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l55</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a            <Level>\u000a                <id>o6</id>\u000a                <name>STORE_STATE</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>1</level-nb>\u000a                <hierarchy-parent-id>n3</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l53</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a            <Level>\u000a                <id>o7</id>\u000a                <name>STORE_CITY</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>2</level-nb>\u000a                <hierarchy-parent-id>n3</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l52</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a        </Hierarchy>\u000a    </Dimension-item>\u000a    </Dimension>\u000a    <Measure>\u000a    <Measure-item>\u000a        <id>h1</id>\u000a        <name>UNITS_ORDERED</name>\u000a        <caption/>\u000a        <description/>\u000a        <measure-group-id/>\u000a        <type>physical</type>\u000a        <order>0</order>\u000a        <origin-id>l5</origin-id>\u000a        <formula/>\u000a        <label/>\u000a        <visible>true</visible>\u000a        <aggregator>sum</aggregator>\u000a        <formatString>Standard</formatString>\u000a    </Measure-item>\u000a    <Measure-item>\u000a        <id>h2</id>\u000a        <name>UNITS_SHIPPED</name>\u000a        <caption/>\u000a        <description/>\u000a        <measure-group-id/>\u000a        <type>physical</type>\u000a        <order>0</order>\u000a        <origin-id>l6</origin-id>\u000a        <formula/>\u000a        <label/>\u000a        <visible>true</visible>\u000a        <aggregator>sum</aggregator>\u000a        <formatString>Standard</formatString>\u000a    </Measure-item>\u000a    <Measure-item>\u000a        <id>h3</id>\u000a        <name>Margin</name>\u000a        <caption/>\u000a        <description/>\u000a        <measure-group-id/>\u000a        <type>calculated</type>\u000a        <order>0</order>\u000a        <origin-id/>\u000a        <formula>[Measures].[UNITS_ORDERED]-[Measures].[UNITS_SHIPPED]</formula>\u000a        <label/>\u000a        <visible>false</visible>\u000a        <aggregator>sum</aggregator>\u000a        <formatString>Standard</formatString>\u000a        <dimensionName>Measures</dimensionName>\u000a    </Measure-item>\u000a    </Measure>\u000a    <Cube>\u000a    <Cube-item>\u000a        <id>i1</id>\u000a        <name>inventory</name>\u000a        <defaultMeasure/>\u000a        <enabled>true</enabled>\u000a        <cached>true</cached>\u000a        <description/>\u000a        <type>Rolap</type>\u000a        <physical-name/>\u000a        <cube-location/>\u000a        <fact-dataobject-id>c11</fact-dataobject-id>\u000a        <datasource-id>t2</datasource-id>\u000a        <dimension-item-id>g1</dimension-item-id>\u000a        <dimension-item-id>g2</dimension-item-id>\u000a        <dimension-item-id>g3</dimension-item-id>\u000a        <measure-item-id>h1</measure-item-id>\u000a        <measure-item-id>h2</measure-item-id>\u000a        <measure-item-id>h3</measure-item-id>\u000a    </Cube-item>\u000a    </Cube>\u000a    <VirtualCube>\u000a    </VirtualCube>\u000a    <NamedSets>\u000a    </NamedSets>\u000a    <DimensionViews>\u000a    <DimensionView-item>\u000a        <id>j1</id>\u000a        <name>QUARTER view</name>\u000a        <description/>\u000a        <dimension-id>g1</dimension-id>\u000a    </DimensionView-item>\u000a    <DimensionView-item>\u000a        <id>j2</id>\u000a        <name>WAREHOUSE_COUNTRY view</name>\u000a        <description/>\u000a        <dimension-id>g2</dimension-id>\u000a    </DimensionView-item>\u000a    <DimensionView-item>\u000a        <id>j3</id>\u000a        <name>STORE_COUNTRY view</name>\u000a        <description/>\u000a        <dimension-id>g3</dimension-id>\u000a    </DimensionView-item>\u000a    </DimensionViews>\u000a</olap>\u000a\u000a</freeanalysis-schema>',0,'')
INSERT INTO FAS_MODEL VALUES(3,'','','2008-03-13 00:00:00.000000000','2008-03-13 00:00:00.000000000','','','','<freeanalysis-schema>\u000a    <version>2.0</version>\u000a    <id>3</id>\u000a    <isSynchronized>true</isSynchronized>\u000a    <document-properties>\u000a        <name/>\u000a        <author/>\u000a        <description/>\u000a        <creation-date>2008-03-13</creation-date>\u000a        <modification-date>2008-03-13</modification-date>\u000a        <version/>\u000a        <icon/>\u000a        <flyover-icon/>\u000a    </document-properties>\u000a\u000a    <datasources>\u000a        <datasource-item>\u000a            <name>foodmart</name>\u000a            <id>t2</id>\u000a            <connection>\u000a                <name/>\u000a                <id>a3</id>\u000a                <type>DataBase</type>\u000a                <data-source-location/>\u000a                <server-id/>\u000a                <driver>org.hsqldb.jdbcDriver</driver>\u000a                <schema-name/>\u000a                <url>jdbc:hsqldb:file:datas/foodmart/foodmart</url>\u000a                <transformation-url/>\u000a                <file-location/>\u000a                <user>sa</user>\u000a                <password/>\u000a                <description/>\u000a            </connection>\u000a            <dataobject-item>\u000a            \u0009<id>c11</id>\u000a                <name>SALES_FACT_1998</name>\u000a                <data-source-id>t2</data-source-id>\u000a                <server-id/>\u000a                <data-object-type>fact</data-object-type>\u000a                <select-statment-definition>SELECT * FROM SALES_FACT_1998</select-statment-definition>\u000a                <transformation-name/>\u000a                <file-name/>\u000a                <description/>\u000a                <isInline>false</isInline>\u000a                <item>\u000a                    <id>l38</id>\u000a                    <name>PRODUCT_ID</name>\u000a                    <origin>PRODUCT_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l39</id>\u000a                    <name>TIME_ID</name>\u000a                    <origin>TIME_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l40</id>\u000a                    <name>CUSTOMER_ID</name>\u000a                    <origin>CUSTOMER_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l41</id>\u000a                    <name>PROMOTION_ID</name>\u000a                    <origin>PROMOTION_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l42</id>\u000a                    <name>STORE_ID</name>\u000a                    <origin>STORE_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l43</id>\u000a                    <name>STORE_SALES</name>\u000a                    <origin>STORE_SALES</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.math.BigDecimal</classe>\u000a                    <sql-type>DECIMAL</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l44</id>\u000a                    <name>STORE_COST</name>\u000a                    <origin>STORE_COST</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.math.BigDecimal</classe>\u000a                    <sql-type>DECIMAL</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l45</id>\u000a                    <name>UNIT_SALES</name>\u000a                    <origin>UNIT_SALES</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a            </dataobject-item>\u000a            <dataobject-item>\u000a            \u0009<id>c12</id>\u000a                <name>STORE</name>\u000a                <data-source-id>t2</data-source-id>\u000a                <server-id/>\u000a                <data-object-type>dimension</data-object-type>\u000a                <select-statment-definition>SELECT * FROM STORE</select-statment-definition>\u000a                <transformation-name/>\u000a                <file-name/>\u000a                <description/>\u000a                <isInline>false</isInline>\u000a                <item>\u000a                    <id>l46</id>\u000a                    <name>STORE_ID</name>\u000a                    <origin>STORE_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l47</id>\u000a                    <name>STORE_TYPE</name>\u000a                    <origin>STORE_TYPE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l48</id>\u000a                    <name>REGION_ID</name>\u000a                    <origin>REGION_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l49</id>\u000a                    <name>STORE_NAME</name>\u000a                    <origin>STORE_NAME</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l50</id>\u000a                    <name>STORE_NUMBER</name>\u000a                    <origin>STORE_NUMBER</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l51</id>\u000a                    <name>STORE_STREET_ADDRESS</name>\u000a                    <origin>STORE_STREET_ADDRESS</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l52</id>\u000a                    <name>STORE_CITY</name>\u000a                    <origin>STORE_CITY</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l53</id>\u000a                    <name>STORE_STATE</name>\u000a                    <origin>STORE_STATE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l54</id>\u000a                    <name>STORE_POSTAL_CODE</name>\u000a                    <origin>STORE_POSTAL_CODE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l55</id>\u000a                    <name>STORE_COUNTRY</name>\u000a                    <origin>STORE_COUNTRY</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l56</id>\u000a                    <name>STORE_MANAGER</name>\u000a                    <origin>STORE_MANAGER</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l57</id>\u000a                    <name>STORE_PHONE</name>\u000a                    <origin>STORE_PHONE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l58</id>\u000a                    <name>STORE_FAX</name>\u000a                    <origin>STORE_FAX</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l59</id>\u000a                    <name>FIRST_OPENED_DATE</name>\u000a                    <origin>FIRST_OPENED_DATE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.sql.Timestamp</classe>\u000a                    <sql-type>TIMESTAMP</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l60</id>\u000a                    <name>LAST_REMODEL_DATE</name>\u000a                    <origin>LAST_REMODEL_DATE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.sql.Timestamp</classe>\u000a                    <sql-type>TIMESTAMP</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l61</id>\u000a                    <name>LEASE_SQFT</name>\u000a                    <origin>LEASE_SQFT</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l62</id>\u000a                    <name>STORE_SQFT</name>\u000a                    <origin>STORE_SQFT</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l63</id>\u000a                    <name>GROCERY_SQFT</name>\u000a                    <origin>GROCERY_SQFT</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l64</id>\u000a                    <name>FROZEN_SQFT</name>\u000a                    <origin>FROZEN_SQFT</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l65</id>\u000a                    <name>MEAT_SQFT</name>\u000a                    <origin>MEAT_SQFT</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l66</id>\u000a                    <name>COFFEE_BAR</name>\u000a                    <origin>COFFEE_BAR</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>CHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l67</id>\u000a                    <name>VIDEO_STORE</name>\u000a                    <origin>VIDEO_STORE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>CHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l68</id>\u000a                    <name>SALAD_BAR</name>\u000a                    <origin>SALAD_BAR</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>CHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l69</id>\u000a                    <name>PREPARED_FOOD</name>\u000a                    <origin>PREPARED_FOOD</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>CHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l70</id>\u000a                    <name>FLORIST</name>\u000a                    <origin>FLORIST</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>CHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a            </dataobject-item>\u000a            <dataobject-item>\u000a            \u0009<id>c13</id>\u000a                <name>TIME_BY_DAY</name>\u000a                <data-source-id>t2</data-source-id>\u000a                <server-id/>\u000a                <data-object-type>dimension</data-object-type>\u000a                <select-statment-definition>SELECT * FROM TIME_BY_DAY</select-statment-definition>\u000a                <transformation-name/>\u000a                <file-name/>\u000a                <description/>\u000a                <isInline>false</isInline>\u000a                <item>\u000a                    <id>l71</id>\u000a                    <name>TIME_ID</name>\u000a                    <origin>TIME_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l72</id>\u000a                    <name>THE_DATE</name>\u000a                    <origin>THE_DATE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.sql.Timestamp</classe>\u000a                    <sql-type>TIMESTAMP</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l73</id>\u000a                    <name>THE_DAY</name>\u000a                    <origin>THE_DAY</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l74</id>\u000a                    <name>THE_MONTH</name>\u000a                    <origin>THE_MONTH</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l75</id>\u000a                    <name>THE_YEAR</name>\u000a                    <origin>THE_YEAR</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>SMALLINT</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l76</id>\u000a                    <name>DAY_OF_MONTH</name>\u000a                    <origin>DAY_OF_MONTH</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>SMALLINT</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l77</id>\u000a                    <name>WEEK_OF_YEAR</name>\u000a                    <origin>WEEK_OF_YEAR</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l78</id>\u000a                    <name>MONTH_OF_YEAR</name>\u000a                    <origin>MONTH_OF_YEAR</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>SMALLINT</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l79</id>\u000a                    <name>QUARTER</name>\u000a                    <origin>QUARTER</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l80</id>\u000a                    <name>FISCAL_PERIOD</name>\u000a                    <origin>FISCAL_PERIOD</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a            </dataobject-item>\u000a        </datasource-item>\u000a    </datasources>\u000a    <object-relation>\u000a        <object-relation-item>\u000a             <id>l1</id>\u000a             <name>[SALES_FACT_1998.TIME_ID] = [TIME_BY_DAY.TIME_ID]</name>\u000a             <left-object-id>c11</left-object-id>\u000a             <right-object-id>c13</right-object-id>\u000a             <relation-formula>\u000a                 <left-object-column-id>l39</left-object-column-id>\u000a                 <right-object-column-id>l71</right-object-column-id>\u000a                 <object-columns-relation>=</object-columns-relation>\u000a             </relation-formula>\u000a        </object-relation-item>\u000a        <object-relation-item>\u000a             <id>l2</id>\u000a             <name>[SALES_FACT_1998.STORE_ID] = [STORE.STORE_ID]</name>\u000a             <left-object-id>c11</left-object-id>\u000a             <right-object-id>c12</right-object-id>\u000a             <relation-formula>\u000a                 <left-object-column-id>l42</left-object-column-id>\u000a                 <right-object-column-id>l46</right-object-column-id>\u000a                 <object-columns-relation>=</object-columns-relation>\u000a             </relation-formula>\u000a        </object-relation-item>\u000a    </object-relation>\u000a<security>\u000a    <server-connection>\u000a    </server-connection>\u000a    <security-provider>\u000a    </security-provider>\u000a</security>\u000a<olap>\u000a\u000a    <defaultRoleName/>\u000a    <measureCaption/>\u000a    <UserDefinedFunctions>\u000a    </UserDefinedFunctions>\u000a    <Dimension-group>\u000a    </Dimension-group>\u000a    <Measure-group>\u000a    </Measure-group>\u000a    <Security-group>\u000a    </Security-group>\u000a    <Aggregate>\u000a    </Aggregate>\u000a    <Dimension>\u000a    <Dimension-item>\u000a        <id>g1</id>\u000a        <name>stores</name>\u000a        <caption/>\u000a        <description/>\u000a        <dimension-group-id/>\u000a        <IsDate>false</IsDate>\u000a        <LoadMethod>cube_startup</LoadMethod>\u000a        <order/>\u000a        <Widget/>\u000a        <properties/>\u000a        <Hierarchy>\u000a            <id>n1</id>\u000a            <name/>\u000a            <caption/>\u000a            <memberReaderClass/>\u000a            <allMemberCaption/>\u000a            <desc/>\u000a            <dimension-id>g1</dimension-id>\u000a            <hasAll>true</hasAll>\u000a            <allMember>All  stores</allMember>\u000a            <defaultMember/>\u000a            <Level>\u000a                <id>o1</id>\u000a                <name>STORE_COUNTRY</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>1</level-nb>\u000a                <hierarchy-parent-id>n1</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l55</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a            <Level>\u000a                <id>o2</id>\u000a                <name>STORE_STATE</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>1</level-nb>\u000a                <hierarchy-parent-id>n1</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l53</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a            <Level>\u000a                <id>o3</id>\u000a                <name>STORE_CITY</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>2</level-nb>\u000a                <hierarchy-parent-id>n1</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l52</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a        </Hierarchy>\u000a    </Dimension-item>\u000a    <Dimension-item>\u000a        <id>g2</id>\u000a        <name>time</name>\u000a        <caption/>\u000a        <description/>\u000a        <dimension-group-id/>\u000a        <IsDate>false</IsDate>\u000a        <LoadMethod>cube_startup</LoadMethod>\u000a        <order/>\u000a        <Widget/>\u000a        <properties/>\u000a        <Hierarchy>\u000a            <id>n2</id>\u000a            <name/>\u000a            <caption/>\u000a            <memberReaderClass/>\u000a            <allMemberCaption/>\u000a            <desc/>\u000a            <dimension-id>g2</dimension-id>\u000a            <hasAll>true</hasAll>\u000a            <allMember>All  time</allMember>\u000a            <defaultMember/>\u000a            <Level>\u000a                <id>o4</id>\u000a                <name>QUARTER</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>0</level-nb>\u000a                <hierarchy-parent-id>n2</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l79</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a            <Level>\u000a                <id>o5</id>\u000a                <name>THE_MONTH</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>1</level-nb>\u000a                <hierarchy-parent-id>n2</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l74</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a            <Level>\u000a                <id>o6</id>\u000a                <name>THE_DAY</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>2</level-nb>\u000a                <hierarchy-parent-id>n2</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l73</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a        </Hierarchy>\u000a    </Dimension-item>\u000a    </Dimension>\u000a    <Measure>\u000a    <Measure-item>\u000a        <id>h1</id>\u000a        <name>STORE_SALES</name>\u000a        <caption/>\u000a        <description/>\u000a        <measure-group-id/>\u000a        <type>physical</type>\u000a        <order>0</order>\u000a        <origin-id>l43</origin-id>\u000a        <formula/>\u000a        <label/>\u000a        <visible>true</visible>\u000a        <aggregator>sum</aggregator>\u000a        <formatString>Standard</formatString>\u000a    </Measure-item>\u000a    <Measure-item>\u000a        <id>h2</id>\u000a        <name>STORE_COST</name>\u000a        <caption/>\u000a        <description/>\u000a        <measure-group-id/>\u000a        <type>physical</type>\u000a        <order>0</order>\u000a        <origin-id>l44</origin-id>\u000a        <formula/>\u000a        <label/>\u000a        <visible>true</visible>\u000a        <aggregator>sum</aggregator>\u000a        <formatString>Standard</formatString>\u000a    </Measure-item>\u000a    </Measure>\u000a    <Cube>\u000a    <Cube-item>\u000a        <id>i1</id>\u000a        <name>sales</name>\u000a        <defaultMeasure/>\u000a        <enabled>true</enabled>\u000a        <cached>true</cached>\u000a        <description/>\u000a        <type>Rolap</type>\u000a        <physical-name/>\u000a        <cube-location/>\u000a        <fact-dataobject-id>c11</fact-dataobject-id>\u000a        <datasource-id>t2</datasource-id>\u000a        <dimension-item-id>g1</dimension-item-id>\u000a        <dimension-item-id>g2</dimension-item-id>\u000a        <measure-item-id>h1</measure-item-id>\u000a        <measure-item-id>h2</measure-item-id>\u000a    </Cube-item>\u000a    </Cube>\u000a    <VirtualCube>\u000a    </VirtualCube>\u000a    <NamedSets>\u000a    </NamedSets>\u000a    <DimensionViews>\u000a    <DimensionView-item>\u000a        <id>j4</id>\u000a        <name>STORE_COUNTRY view</name>\u000a        <description/>\u000a        <dimension-id>g1</dimension-id>\u000a    </DimensionView-item>\u000a    <DimensionView-item>\u000a        <id>j5</id>\u000a        <name>QUARTER view</name>\u000a        <description/>\u000a        <dimension-id>g2</dimension-id>\u000a    </DimensionView-item>\u000a    </DimensionViews>\u000a</olap>\u000a\u000a</freeanalysis-schema>',0,'')
INSERT INTO FAS_MODEL VALUES(2,'','','2008-03-13 00:00:00.000000000','2008-03-13 00:00:00.000000000','','','','<freeanalysis-schema>\u000a    <version>2.0</version>\u000a    <id>2</id>\u000a    <isSynchronized>true</isSynchronized>\u000a    <document-properties>\u000a        <name/>\u000a        <author/>\u000a        <description/>\u000a        <creation-date>2008-03-13</creation-date>\u000a        <modification-date>2008-03-13</modification-date>\u000a        <version/>\u000a        <icon/>\u000a        <flyover-icon/>\u000a    </document-properties>\u000a\u000a    <datasources>\u000a        <datasource-item>\u000a            <name>Foodmart</name>\u000a            <id>t2</id>\u000a            <connection>\u000a                <name/>\u000a                <id>a3</id>\u000a                <type>DataBase</type>\u000a                <data-source-location/>\u000a                <server-id/>\u000a                <driver>org.hsqldb.jdbcDriver</driver>\u000a                <schema-name/>\u000a                <url>jdbc:hsqldb:file:datas/foodmart/foodmart</url>\u000a                <transformation-url/>\u000a                <file-location/>\u000a                <user>sa</user>\u000a                <password/>\u000a                <description/>\u000a            </connection>\u000a            <dataobject-item>\u000a            \u0009<id>c11</id>\u000a                <name>INVENTORY_FACT_1998</name>\u000a                <data-source-id>t2</data-source-id>\u000a                <server-id/>\u000a                <data-object-type>fact</data-object-type>\u000a                <select-statment-definition>SELECT * FROM INVENTORY_FACT_1998</select-statment-definition>\u000a                <transformation-name/>\u000a                <file-name/>\u000a                <description/>\u000a                <isInline>false</isInline>\u000a                <item>\u000a                    <id>l1</id>\u000a                    <name>PRODUCT_ID</name>\u000a                    <origin>PRODUCT_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l2</id>\u000a                    <name>TIME_ID</name>\u000a                    <origin>TIME_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l3</id>\u000a                    <name>WAREHOUSE_ID</name>\u000a                    <origin>WAREHOUSE_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l4</id>\u000a                    <name>STORE_ID</name>\u000a                    <origin>STORE_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l5</id>\u000a                    <name>UNITS_ORDERED</name>\u000a                    <origin>UNITS_ORDERED</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l6</id>\u000a                    <name>UNITS_SHIPPED</name>\u000a                    <origin>UNITS_SHIPPED</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l7</id>\u000a                    <name>WAREHOUSE_SALES</name>\u000a                    <origin>WAREHOUSE_SALES</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.math.BigDecimal</classe>\u000a                    <sql-type>DECIMAL</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l8</id>\u000a                    <name>WAREHOUSE_COST</name>\u000a                    <origin>WAREHOUSE_COST</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.math.BigDecimal</classe>\u000a                    <sql-type>DECIMAL</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l9</id>\u000a                    <name>SUPPLY_TIME</name>\u000a                    <origin>SUPPLY_TIME</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>SMALLINT</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l10</id>\u000a                    <name>STORE_INVOICE</name>\u000a                    <origin>STORE_INVOICE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.math.BigDecimal</classe>\u000a                    <sql-type>DECIMAL</sql-type>\u000a                    <attribut>U</attribut>\u000a                    <description/>\u000a                </item>\u000a            </dataobject-item>\u000a            <dataobject-item>\u000a            \u0009<id>c12</id>\u000a                <name>TIME_BY_DAY</name>\u000a                <data-source-id>t2</data-source-id>\u000a                <server-id/>\u000a                <data-object-type>dimension</data-object-type>\u000a                <select-statment-definition>SELECT * FROM TIME_BY_DAY</select-statment-definition>\u000a                <transformation-name/>\u000a                <file-name/>\u000a                <description/>\u000a                <isInline>false</isInline>\u000a                <item>\u000a                    <id>l71</id>\u000a                    <name>TIME_ID</name>\u000a                    <origin>TIME_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l72</id>\u000a                    <name>THE_DATE</name>\u000a                    <origin>THE_DATE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.sql.Timestamp</classe>\u000a                    <sql-type>TIMESTAMP</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l73</id>\u000a                    <name>THE_DAY</name>\u000a                    <origin>THE_DAY</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l74</id>\u000a                    <name>THE_MONTH</name>\u000a                    <origin>THE_MONTH</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l75</id>\u000a                    <name>THE_YEAR</name>\u000a                    <origin>THE_YEAR</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>SMALLINT</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l76</id>\u000a                    <name>DAY_OF_MONTH</name>\u000a                    <origin>DAY_OF_MONTH</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>SMALLINT</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l77</id>\u000a                    <name>WEEK_OF_YEAR</name>\u000a                    <origin>WEEK_OF_YEAR</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l78</id>\u000a                    <name>MONTH_OF_YEAR</name>\u000a                    <origin>MONTH_OF_YEAR</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>SMALLINT</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l79</id>\u000a                    <name>QUARTER</name>\u000a                    <origin>QUARTER</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l80</id>\u000a                    <name>FISCAL_PERIOD</name>\u000a                    <origin>FISCAL_PERIOD</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a            </dataobject-item>\u000a            <dataobject-item>\u000a            \u0009<id>c13</id>\u000a                <name>WAREHOUSE</name>\u000a                <data-source-id>t2</data-source-id>\u000a                <server-id/>\u000a                <data-object-type>dimension</data-object-type>\u000a                <select-statment-definition>SELECT * FROM WAREHOUSE</select-statment-definition>\u000a                <transformation-name/>\u000a                <file-name/>\u000a                <description/>\u000a                <isInline>false</isInline>\u000a                <item>\u000a                    <id>l81</id>\u000a                    <name>WAREHOUSE_ID</name>\u000a                    <origin>WAREHOUSE_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l82</id>\u000a                    <name>WAREHOUSE_CLASS_ID</name>\u000a                    <origin>WAREHOUSE_CLASS_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l83</id>\u000a                    <name>STORES_ID</name>\u000a                    <origin>STORES_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l84</id>\u000a                    <name>WAREHOUSE_NAME</name>\u000a                    <origin>WAREHOUSE_NAME</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l85</id>\u000a                    <name>WA_ADDRESS1</name>\u000a                    <origin>WA_ADDRESS1</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l86</id>\u000a                    <name>WA_ADDRESS2</name>\u000a                    <origin>WA_ADDRESS2</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l87</id>\u000a                    <name>WA_ADDRESS3</name>\u000a                    <origin>WA_ADDRESS3</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l88</id>\u000a                    <name>WA_ADDRESS4</name>\u000a                    <origin>WA_ADDRESS4</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l89</id>\u000a                    <name>WAREHOUSE_CITY</name>\u000a                    <origin>WAREHOUSE_CITY</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l90</id>\u000a                    <name>WAREHOUSE_STATE_PROVINCE</name>\u000a                    <origin>WAREHOUSE_STATE_PROVINCE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l91</id>\u000a                    <name>WAREHOUSE_POSTAL_CODE</name>\u000a                    <origin>WAREHOUSE_POSTAL_CODE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l92</id>\u000a                    <name>WAREHOUSE_COUNTRY</name>\u000a                    <origin>WAREHOUSE_COUNTRY</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l93</id>\u000a                    <name>WAREHOUSE_OWNER_NAME</name>\u000a                    <origin>WAREHOUSE_OWNER_NAME</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l94</id>\u000a                    <name>WAREHOUSE_PHONE</name>\u000a                    <origin>WAREHOUSE_PHONE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l95</id>\u000a                    <name>WAREHOUSE_FAX</name>\u000a                    <origin>WAREHOUSE_FAX</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a            </dataobject-item>\u000a            <dataobject-item>\u000a            \u0009<id>c14</id>\u000a                <name>WAREHOUSE_CLASS</name>\u000a                <data-source-id>t2</data-source-id>\u000a                <server-id/>\u000a                <data-object-type>dimension</data-object-type>\u000a                <select-statment-definition>SELECT * FROM WAREHOUSE_CLASS</select-statment-definition>\u000a                <transformation-name/>\u000a                <file-name/>\u000a                <description/>\u000a                <isInline>false</isInline>\u000a                <item>\u000a                    <id>l96</id>\u000a                    <name>WAREHOUSE_CLASS_ID</name>\u000a                    <origin>WAREHOUSE_CLASS_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l97</id>\u000a                    <name>DESCRIPTION</name>\u000a                    <origin>DESCRIPTION</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a            </dataobject-item>\u000a            <dataobject-item>\u000a            \u0009<id>c15</id>\u000a                <name>STORE</name>\u000a                <data-source-id>t2</data-source-id>\u000a                <server-id/>\u000a                <data-object-type>dimension</data-object-type>\u000a                <select-statment-definition>SELECT * FROM STORE</select-statment-definition>\u000a                <transformation-name/>\u000a                <file-name/>\u000a                <description/>\u000a                <isInline>false</isInline>\u000a                <item>\u000a                    <id>l46</id>\u000a                    <name>STORE_ID</name>\u000a                    <origin>STORE_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l47</id>\u000a                    <name>STORE_TYPE</name>\u000a                    <origin>STORE_TYPE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l48</id>\u000a                    <name>REGION_ID</name>\u000a                    <origin>REGION_ID</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Integer</classe>\u000a                    <sql-type>INTEGER</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l49</id>\u000a                    <name>STORE_NAME</name>\u000a                    <origin>STORE_NAME</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l50</id>\u000a                    <name>STORE_NUMBER</name>\u000a                    <origin>STORE_NUMBER</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l51</id>\u000a                    <name>STORE_STREET_ADDRESS</name>\u000a                    <origin>STORE_STREET_ADDRESS</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l52</id>\u000a                    <name>STORE_CITY</name>\u000a                    <origin>STORE_CITY</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l53</id>\u000a                    <name>STORE_STATE</name>\u000a                    <origin>STORE_STATE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l54</id>\u000a                    <name>STORE_POSTAL_CODE</name>\u000a                    <origin>STORE_POSTAL_CODE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l55</id>\u000a                    <name>STORE_COUNTRY</name>\u000a                    <origin>STORE_COUNTRY</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l56</id>\u000a                    <name>STORE_MANAGER</name>\u000a                    <origin>STORE_MANAGER</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l57</id>\u000a                    <name>STORE_PHONE</name>\u000a                    <origin>STORE_PHONE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l58</id>\u000a                    <name>STORE_FAX</name>\u000a                    <origin>STORE_FAX</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>VARCHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l59</id>\u000a                    <name>FIRST_OPENED_DATE</name>\u000a                    <origin>FIRST_OPENED_DATE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.sql.Timestamp</classe>\u000a                    <sql-type>TIMESTAMP</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l60</id>\u000a                    <name>LAST_REMODEL_DATE</name>\u000a                    <origin>LAST_REMODEL_DATE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.sql.Timestamp</classe>\u000a                    <sql-type>TIMESTAMP</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l61</id>\u000a                    <name>LEASE_SQFT</name>\u000a                    <origin>LEASE_SQFT</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l62</id>\u000a                    <name>STORE_SQFT</name>\u000a                    <origin>STORE_SQFT</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l63</id>\u000a                    <name>GROCERY_SQFT</name>\u000a                    <origin>GROCERY_SQFT</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l64</id>\u000a                    <name>FROZEN_SQFT</name>\u000a                    <origin>FROZEN_SQFT</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l65</id>\u000a                    <name>MEAT_SQFT</name>\u000a                    <origin>MEAT_SQFT</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.Double</classe>\u000a                    <sql-type>DOUBLE</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l66</id>\u000a                    <name>COFFEE_BAR</name>\u000a                    <origin>COFFEE_BAR</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>CHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l67</id>\u000a                    <name>VIDEO_STORE</name>\u000a                    <origin>VIDEO_STORE</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>CHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l68</id>\u000a                    <name>SALAD_BAR</name>\u000a                    <origin>SALAD_BAR</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>CHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l69</id>\u000a                    <name>PREPARED_FOOD</name>\u000a                    <origin>PREPARED_FOOD</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>CHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a                <item>\u000a                    <id>l70</id>\u000a                    <name>FLORIST</name>\u000a                    <origin>FLORIST</origin>\u000a                    <type>physical</type>\u000a                    <classe>java.lang.String</classe>\u000a                    <sql-type>CHAR</sql-type>\u000a                    <attribut>D</attribut>\u000a                    <description/>\u000a                </item>\u000a            </dataobject-item>\u000a        </datasource-item>\u000a    </datasources>\u000a    <object-relation>\u000a        <object-relation-item>\u000a             <id>l1</id>\u000a             <name>[INVENTORY_FACT_1998.TIME_ID] = [TIME_BY_DAY.TIME_ID]</name>\u000a             <left-object-id>c11</left-object-id>\u000a             <right-object-id>c12</right-object-id>\u000a             <relation-formula>\u000a                 <left-object-column-id>l2</left-object-column-id>\u000a                 <right-object-column-id>l71</right-object-column-id>\u000a                 <object-columns-relation>=</object-columns-relation>\u000a             </relation-formula>\u000a        </object-relation-item>\u000a        <object-relation-item>\u000a             <id>l2</id>\u000a             <name>[INVENTORY_FACT_1998.WAREHOUSE_ID] = [WAREHOUSE.WAREHOUSE_ID]</name>\u000a             <left-object-id>c11</left-object-id>\u000a             <right-object-id>c13</right-object-id>\u000a             <relation-formula>\u000a                 <left-object-column-id>l3</left-object-column-id>\u000a                 <right-object-column-id>l81</right-object-column-id>\u000a                 <object-columns-relation>=</object-columns-relation>\u000a             </relation-formula>\u000a        </object-relation-item>\u000a        <object-relation-item>\u000a             <id>l3</id>\u000a             <name>[INVENTORY_FACT_1998.STORE_ID] = [STORE.STORE_ID]</name>\u000a             <left-object-id>c11</left-object-id>\u000a             <right-object-id>c15</right-object-id>\u000a             <relation-formula>\u000a                 <left-object-column-id>l4</left-object-column-id>\u000a                 <right-object-column-id>l46</right-object-column-id>\u000a                 <object-columns-relation>=</object-columns-relation>\u000a             </relation-formula>\u000a        </object-relation-item>\u000a        <object-relation-item>\u000a             <id>l4</id>\u000a             <name>[WAREHOUSE_CLASS.WAREHOUSE_CLASS_ID] = [WAREHOUSE_CLASS.WAREHOUSE_CLASS_ID]</name>\u000a             <left-object-id>c14</left-object-id>\u000a             <right-object-id>c14</right-object-id>\u000a             <relation-formula>\u000a                 <left-object-column-id>l96</left-object-column-id>\u000a                 <right-object-column-id>l96</right-object-column-id>\u000a                 <object-columns-relation>=</object-columns-relation>\u000a             </relation-formula>\u000a        </object-relation-item>\u000a    </object-relation>\u000a<security>\u000a    <server-connection>\u000a        <server-connection-item>\u000a            <name>securityServer</name>\u000a            <id>m0</id>\u000a            <type>authentification</type>\u000a            <host>http://localhost:8080/FA/SecurityProvider</host>\u000a            <port>99</port>\u000a            <user/>\u000a            <password/>\u000a            <description/>\u000a        </server-connection-item>\u000a    </server-connection>\u000a    <security-provider>\u000a    </security-provider>\u000a</security>\u000a<olap>\u000a\u000a    <defaultRoleName/>\u000a    <measureCaption/>\u000a    <UserDefinedFunctions>\u000a    </UserDefinedFunctions>\u000a    <Dimension-group>\u000a    </Dimension-group>\u000a    <Measure-group>\u000a    </Measure-group>\u000a    <Security-group>\u000a    </Security-group>\u000a    <Aggregate>\u000a    </Aggregate>\u000a    <Dimension>\u000a    <Dimension-item>\u000a        <id>g1</id>\u000a        <name>times</name>\u000a        <caption/>\u000a        <description/>\u000a        <dimension-group-id/>\u000a        <IsDate>false</IsDate>\u000a        <LoadMethod>cube_startup</LoadMethod>\u000a        <order/>\u000a        <Widget/>\u000a        <properties/>\u000a        <Hierarchy>\u000a            <id>n1</id>\u000a            <name/>\u000a            <caption/>\u000a            <memberReaderClass/>\u000a            <allMemberCaption/>\u000a            <desc/>\u000a            <dimension-id>g1</dimension-id>\u000a            <hasAll>true</hasAll>\u000a            <allMember>All  time</allMember>\u000a            <defaultMember/>\u000a            <Level>\u000a                <id>o1</id>\u000a                <name>QUARTER</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>0</level-nb>\u000a                <hierarchy-parent-id>n1</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l79</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a            <Level>\u000a                <id>o2</id>\u000a                <name>THE_MONTH</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>1</level-nb>\u000a                <hierarchy-parent-id>n1</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l74</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a        </Hierarchy>\u000a    </Dimension-item>\u000a    <Dimension-item>\u000a        <id>g2</id>\u000a        <name>warehouse</name>\u000a        <caption/>\u000a        <description/>\u000a        <dimension-group-id/>\u000a        <IsDate>false</IsDate>\u000a        <LoadMethod>cube_startup</LoadMethod>\u000a        <order/>\u000a        <Widget/>\u000a        <properties/>\u000a        <Hierarchy>\u000a            <id>n2</id>\u000a            <name/>\u000a            <caption/>\u000a            <memberReaderClass/>\u000a            <allMemberCaption/>\u000a            <desc/>\u000a            <dimension-id>g2</dimension-id>\u000a            <hasAll>true</hasAll>\u000a            <allMember>All  warehouse</allMember>\u000a            <defaultMember/>\u000a            <Level>\u000a                <id>o3</id>\u000a                <name>WAREHOUSE_COUNTRY</name>\u000a                <caption/>\u000a                <captionColumn/>\u000a                <formatter/>\u000a                <type/>\u000a                <levelType/>\u000a                <hideMemberIf/>\u000a                <ordinalColumn/>\u000a                <level-nb>0</level-nb>\u000a                <hierarchy-parent-id>n2</hierarchy-parent-id>\u000a                <description/>\u000a                <uniqueMembers>false</uniqueMembers>\u000a                <dataobjectitem-code-id>l92</dataobjectitem-code-id>\u000a                <parent-dataobjectitem-id/>\u000a                <closure-dataobject-id/>\u000a                <closure-parent-dataobjectitem-id/>\u000a                <closure-child-dataobjectitem-id/>\u000a                <null-parent-value/>\u000a            </Level>\u000a            <Level>\u000a                <id>o4</id>\u000a                <name>WAREHOUSE_STATE_PROVINCE</name>\u000a