OpenConcerto

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

svn://code.openconcerto.org/openconcerto

Rev

Rev 110 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 110 Rev 140
Line 1... Line 1...
1
<?xml version="1.0" encoding="UTF-8" ?>
1
<?xml version="1.0" encoding="UTF-8" ?>
2
<Schema name="OpenConcerto">
2
<Schema name="OpenConcerto">
3
 
3
 
4
	<Cube name="Ventes">
4
	<Cube name="Ventes">
5
		<Table name="SAISIE_VENTE_FACTURE_ELEMENT" schema="_SCHEMA_"/>
5
		<Table name="SAISIE_VENTE_FACTURE_ELEMENT" schema="_SCHEMA_"/>	
6
		
-
 
7
		<Dimension name="Articles" foreignKey="ID_ARTICLE">
6
		<Dimension name="Articles" foreignKey="ID_ARTICLE">
8
			<Hierarchy hasAll="true" allMemberName="Tous les articles" primaryKey="ID">
7
			<Hierarchy hasAll="true" allMemberName="Tous les articles" primaryKey="ID">
9
				<View alias="ARTICLE">
8
				<View alias="ARTICLE">
10
					<SQL dialect="generic"> <![CDATA[select * from "_SCHEMA_"."ARTICLE" where "ARCHIVE" = '0']]>
9
					<SQL dialect="generic"> <![CDATA[select * from "_SCHEMA_"."ARTICLE" where "ARCHIVE" = '0']]>
11
					</SQL>
10
					</SQL>
12
				</View>
11
				</View>
13
				<Level name="Désignation" column="NOM" uniqueMembers="true" />
12
				<Level name="Designation" column="NOM" uniqueMembers="true" />
14
				<Level name="Code produit" column="CODE" uniqueMembers="true" />
13
				<Level name="Code produit" column="CODE" uniqueMembers="true" />
15
			</Hierarchy>
14
			</Hierarchy>
16
		</Dimension>
15
		</Dimension>
17
		<Dimension name="Mode de vente" foreignKey="ID_MODE_VENTE_ARTICLE">
16
		<Dimension name="Mode de vente" foreignKey="ID_MODE_VENTE_ARTICLE">
18
			<Hierarchy hasAll="true" allMemberName="Tous les modes de vente" primaryKey="ID">
17
			<Hierarchy hasAll="true" allMemberName="Tous les modes de vente" primaryKey="ID">
Line 29... Line 28...
29
 
28
 
30
				<View alias="SAISIE_VENTE_FACTURE">
29
				<View alias="SAISIE_VENTE_FACTURE">
31
					<SQL dialect="generic"> <![CDATA[select * from "_SCHEMA_"."SAISIE_VENTE_FACTURE" where "ARCHIVE" = '0']]>
30
					<SQL dialect="generic"> <![CDATA[select * from "_SCHEMA_"."SAISIE_VENTE_FACTURE" where "ARCHIVE" = '0']]>
32
					</SQL>
31
					</SQL>
33
				</View>
32
				</View>
34
				<Level name="Année" column="DATE" uniqueMembers="true" levelType="TimeYears" type="Numeric">
33
				<Level name="Annee" column="DATE" uniqueMembers="true" levelType="TimeYears" type="Numeric">
35
					<KeyExpression>
34
					<KeyExpression>
36
						<SQL dialect="generic">
35
						<SQL dialect="generic">
37
							<![CDATA[EXTRACT(YEAR FROM "SAISIE_VENTE_FACTURE"."DATE")]]>
36
							<![CDATA[EXTRACT(YEAR FROM "SAISIE_VENTE_FACTURE"."DATE")]]>
38
						</SQL>
37
						</SQL>
39
					</KeyExpression>
38
					</KeyExpression>
Line 47... Line 46...
47
						</SQL>
46
						</SQL>
48
					</KeyExpression>
47
					</KeyExpression>
49
				</Level>
48
				</Level>
50
			</Hierarchy>
49
			</Hierarchy>
51
		</Dimension>
50
		</Dimension>
52
		<Dimension name="Ligne facturées">
51
		<Dimension name="Ligne facturees">
53
  		  <Hierarchy hasAll="true" primaryKey="ID">
52
  		  <Hierarchy hasAll="true" primaryKey="ID">
54
  		    <Table name="SAISIE_VENTE_FACTURE_ELEMENT" schema="_SCHEMA_"/>
53
  		    <Table name="SAISIE_VENTE_FACTURE_ELEMENT" schema="_SCHEMA_"/>
55
  		    <Level name="Quantité" column="QTE" type="Numeric" uniqueMembers="false"/>
54
  		    <Level name="Quantite" column="QTE" type="Numeric" uniqueMembers="false"/>
56
  		    <Level name="Code article" column="CODE" type="String" uniqueMembers="false"/>
55
  		    <Level name="Code article" column="CODE" type="String" uniqueMembers="false"/>
57
  		    <Level name="Poids" column="POIDS" type="Numeric" uniqueMembers="false"/>
56
  		    <Level name="Poids" column="POIDS" type="Numeric" uniqueMembers="false"/>
58
  		    <Level name="Désignation" column="NOM" type="String" uniqueMembers="false"/>
57
  		    <Level name="Designation" column="NOM" type="String" uniqueMembers="false"/>
59
  			  </Hierarchy>
58
  			  </Hierarchy>
60
 		 </Dimension>
59
 		 </Dimension>
61
		
60
		
62
		<Measure name="Nombre vendu" column="ID_ARTICLE" aggregator="count" formatString="Standard" />
61
		<Measure name="Nombre vendu" column="ID_ARTICLE" aggregator="count" formatString="Standard" />
63
		<Measure name="Quantité" column="QTE" aggregator="count" formatString="Standard" />
62
		<Measure name="Quantite" column="QTE" aggregator="count" formatString="Standard" />
64
		<Measure name="Prix de vente HT" column="T_PV_HT" aggregator="sum"
63
		<Measure name="Prix de vente HT" column="T_PV_HT" aggregator="sum"
65
			formatter="org.openconcerto.modules.reports.olap.formatter.CentsCellFormatter" />
64
			formatter="org.openconcerto.modules.reports.olap.formatter.CentsCellFormatter" />
66
		<Measure name="Prix d'achat HT" column="T_PA_HT" aggregator="sum"
65
		<Measure name="Prix d'achat HT" column="T_PA_HT" aggregator="sum"
67
			formatter="org.openconcerto.modules.reports.olap.formatter.CentsCellFormatter" />
66
			formatter="org.openconcerto.modules.reports.olap.formatter.CentsCellFormatter" />
68
		<CalculatedMember name="Marge" dimension="Measures">
67
		<CalculatedMember name="Marge" dimension="Measures">