Dépôt officiel du code source de l'ERP OpenConcerto

<?xml version="1.0" encoding="UTF-8" ?>
<Schema name="OpenConcerto">

        <Cube name="Ventes">
                <Table name="SAISIE_VENTE_FACTURE_ELEMENT" schema="_SCHEMA_" />
                <Dimension name="Commercial" foreignKey="ID_SAISIE_VENTE_FACTURE">
                        <Hierarchy hasAll="true" allMemberName="Tous" primaryKey="ID" primaryKeyTable="SAISIE_VENTE_FACTURE">
                                <Join leftKey="ID_COMMERCIAL" rightKey="ID_COMMERCIAL">
                                        <Table name="SAISIE_VENTE_FACTURE" schema="_SCHEMA_" />
                                        <Table name="COMMERCIAL" schema="_SCHEMA_" />
                                </Join>
                                <Level name="Nom du commercial" table="COMMERCIAL" column="NOM" schema="_SCHEMA_">
                                </Level>
                        </Hierarchy>
                </Dimension>

                <Dimension name="Localisation du client" foreignKey="ID_SAISIE_VENTE_FACTURE">
                        <Hierarchy hasAll="true" allMemberName="Tous" primaryKey="ID" primaryKeyTable="SAISIE_VENTE_FACTURE">
                                <Join leftKey="ID_CLIENT" rightKey="ID">
                                        <Table name="SAISIE_VENTE_FACTURE" schema="_SCHEMA_" />

                                        <Join leftKey="ID_PAYS" rightKey="ID">
                                                <Table name="CLIENT" schema="_SCHEMA_" />
                                                <Table name="PAYS" schema="_SCHEMA_" />
                                        </Join>
                                </Join>
                                <Level name="Pays" table="PAYS" column="NOM" schema="_SCHEMA_" uniqueMembers="true">
                                </Level>
                                <Level name="Nom du client" table="CLIENT" column="NOM" schema="_SCHEMA_">
                                </Level>

                        </Hierarchy>
                </Dimension>

                <Dimension name="Client" foreignKey="ID_SAISIE_VENTE_FACTURE">
                        <Hierarchy hasAll="true" allMemberName="Tous" primaryKey="ID" primaryKeyTable="SAISIE_VENTE_FACTURE">
                                <Join leftKey="ID_CLIENT" rightKey="ID">
                                        <Table name="SAISIE_VENTE_FACTURE" schema="_SCHEMA_" />
                                        <Table name="CLIENT" schema="_SCHEMA_" />
                                </Join>
                                <Level name="Nom du client" table="CLIENT" column="NOM" schema="_SCHEMA_">
                                </Level>
                        </Hierarchy>
                </Dimension>



                <Dimension name="Articles" foreignKey="ID_ARTICLE">
                        <Hierarchy hasAll="true" allMemberName="Tous les articles" primaryKey="ID">
                                <View alias="articles">
                                        <SQL dialect="generic"> <![CDATA[select * from "_SCHEMA_"."ARTICLE" where "ARCHIVE" = '0']]>
                                        </SQL>
                                </View>
                                <Level name="Designation" column="NOM" uniqueMembers="true" />
                                <Level name="Code produit" column="CODE" uniqueMembers="true" />
                        </Hierarchy>
                </Dimension>
                <Dimension name="Mode de vente" foreignKey="ID_MODE_VENTE_ARTICLE">
                        <Hierarchy hasAll="true" allMemberName="Tous les modes de vente" primaryKey="ID">
                                <View alias="mode">
                                        <SQL dialect="generic"> <![CDATA[select * from "_SCHEMA_"."MODE_VENTE_ARTICLE" where "ARCHIVE" = '0']]>
                                        </SQL>
                                </View>
                                <Level name="Type" column="NOM" uniqueMembers="true" />

                        </Hierarchy>
                </Dimension>
                <Dimension name="Date de facturation" foreignKey="ID_SAISIE_VENTE_FACTURE" type="TimeDimension">
                        <Hierarchy hasAll="true" allMemberName="Toutes les dates" primaryKey="ID">

                                <View alias="factures">
                                        <SQL dialect="generic"> <![CDATA[select * from "_SCHEMA_"."SAISIE_VENTE_FACTURE" where "ARCHIVE" = '0']]>
                                        </SQL>
                                </View>
                                <Level name="Annee" column="DATE" uniqueMembers="true" levelType="TimeYears" type="Numeric">
                                        <KeyExpression>
                                                <SQL dialect="generic">
                                                        <![CDATA[EXTRACT(YEAR FROM "factures"."DATE")]]>
                                                </SQL>
                                        </KeyExpression>
                                </Level>

                                <Level name="Mois" column="DATE" uniqueMembers="false" levelType="TimeMonths" type="Numeric"
                                        formatter="org.openconcerto.modules.reports.olap.formatter.MonthMemberFormatter">
                                        <KeyExpression>
                                                <SQL dialect="generic">
                                                        <![CDATA[EXTRACT(MONTH FROM "factures"."DATE")]]>
                                                </SQL>
                                        </KeyExpression>
                                </Level>
                        </Hierarchy>
                </Dimension>
                <Dimension name="Ligne facturees">
                        <Hierarchy hasAll="true" primaryKey="ID">
                                <Table name="SAISIE_VENTE_FACTURE_ELEMENT" schema="_SCHEMA_" />
                                <Level name="Quantite" column="QTE" type="Numeric" uniqueMembers="false" />
                                <Level name="Code article" column="CODE" type="String" uniqueMembers="false" />
                                <Level name="Poids" column="POIDS" type="Numeric" uniqueMembers="false" />
                                <Level name="Designation" column="NOM" type="String" uniqueMembers="false" />
                        </Hierarchy>
                </Dimension>


                <Measure name="Quantite" column="QTE" aggregator="sum" formatString="Standard" />
                <Measure name="Prix de vente HT" column="T_PV_HT" aggregator="sum"
                        formatter="org.openconcerto.modules.reports.olap.formatter.CentsCellFormatter" />
                <Measure name="Prix d'achat HT" column="T_PA_HT" aggregator="sum"
                        formatter="org.openconcerto.modules.reports.olap.formatter.CentsCellFormatter" />
                <Measure name="Nombre de lignes" column="ID_ARTICLE" aggregator="count" formatString="Standard" />
                <CalculatedMember name="Marge" dimension="Measures">
                        <Formula>[Measures].[Prix de vente HT] - [Measures].[Prix d'achat HT]
                        </Formula>
                        <CalculatedMemberProperty name="CELL_FORMATTER"
                                value="org.openconcerto.modules.reports.olap.formatter.CentsCellFormatter" />
                </CalculatedMember>

        </Cube>

        <Cube name="Clients">
                <Table name="CLIENT" schema="_SCHEMA_" />
                <Dimension name="Type de client">
                        <Hierarchy hasAll="true" allMemberName="Toutes formes juridiques">
                                <Level name="Forme juridique" column="FORME_JURIDIQUE" uniqueMembers="true" />
                        </Hierarchy>
                </Dimension>

                <Dimension name="Langue" foreignKey="ID_LANGUE">
                        <Hierarchy hasAll="true" allMemberName="Toutes les langues" primaryKey="ID">
                                <Table name="LANGUE" schema="_SCHEMA_" />
                                <Level name="Langue" column="NOM" uniqueMembers="true" />
                        </Hierarchy>

                </Dimension>
                <Dimension name="Pays" foreignKey="ID_PAYS">
                        <Hierarchy hasAll="true" allMemberName="Tous les pays" primaryKey="ID">
                                <Table name="PAYS" schema="_SCHEMA_" />
                                <Level name="Pays" column="NOM" uniqueMembers="true" />
                        </Hierarchy>
                </Dimension>
                <Measure name="Nombre" column="ID" aggregator="count" formatString="Standard" />

        </Cube>



</Schema>