<Caption> <Value>Médecins</Value> <Font> <Alignment/> </Font> </Caption> <Background xsi:type="attribute:ColorDefinition"> <Transparency>0</Transparency> <Red>255</Red> <Green>255</Green> <Blue>255</Blue> </Background> <Outline> <Style>Solid</Style> <Thickness>1</Thickness> <Color> <Transparency>255</Transparency> <Red>0</Red> <Green>0</Green> <Blue>0</Blue> </Color> <Visible>false</Visible> </Outline> <Insets> <Top>0.0</Top> <Left>2.0</Left> <Bottom>0.0</Bottom> <Right>3.0</Right> </Insets> <Visible>true</Visible>

Eclipse BIRT Designer Version 2.3.1.v20080911 Build <2.3.1.v20080922-1151> in /templates/blank_report.gif ltr

com.mysql.jdbc.Driver jdbc:mysql://192.168.1.150/stl07 capsia

Q0Bwc2lA

recette (row["sum(produits)"]-row["sum(charges)"])/row["count(a.numsejour)"] integer dureemoyenne row["sum(a.duree)"]/row["count(a.numsejour)"] integer coutmoyen row["sum(charges)"]/row["count(a.numsejour)"] integer

1 ghm string 2 libelle string 3 concat(a.ghm," - ",b.libelle) string 4 nomcourt string 5 sum(charges) float 6 sum(produits) float 7 sum(a.duree) decimal 8 count(a.numsejour) decimal 9 recette integer 10 dureemoyenne integer 11 coutmoyen integer

ALTARES

1 ghm ghm string 2 libelle libelle string 3 concat(a.ghm," - ",b.libelle) concat(a.ghm," - ",b.libelle) string 4 nomcourt nomcourt string 5 sum(charges) sum(charges) float 6 sum(produits) sum(produits) float 7 sum(a.duree) sum(a.duree) decimal 8 count(a.numsejour) count(a.numsejour) decimal

select a.ghm,b.libelle,concat(a.ghm," - ",b.libelle),c.nomcourt,sum(charges),sum(produits),sum(a.duree),count(a.numsejour) from stl07.2cubesejourdureecout a,encc.nomenghm b,stl07.medecin c where a.ghm= '02C05Z' AND a.ghm=b.ghm AND a.medecin=c.numadeli group by a.ghm,a.medecin

NewTabularHierarchy

string nomcourt

dataSetRow["dureemoyenne"] integer

dataSetRow["recette"] integer

dispersionparghm

html

new Date()]]>

#C0C0C0 x-large bold 0pt center

Analyse de la dispersion des recettes par GHM

x-large bold 15pt 15pt center dispersionparghm

concat(a.ghm," - ",b.libelle) concat(a.ghm," - ",b.libelle) dataSetRow["concat(a.ghm,\" - \",b.libelle)"] string

concat(a.ghm," - ",b.libelle)

Scatter Chart Standard Scatter Chart 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false false 16.0 true Center Center 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true 0.0 0.0 0.0 0.0 North 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 true 5 5 0 255 0 0 0 false 0 255 255 255 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false true 0 255 0 0 0 false 2.0 2.0 2.0 2.0 Vertical Top_Bottom 1 255 0 0 0 true Below Series <Caption> <Value>Médecins</Value> <Font> <Alignment/> </Font> </Caption> <Background xsi:type="attribute:ColorDefinition"> <Transparency>0</Transparency> <Red>255</Red> <Green>255</Green> <Blue>255</Blue> </Background> <Outline> <Style>Solid</Style> <Thickness>1</Thickness> <Color> <Transparency>255</Transparency> <Red>0</Red> <Green>0</Green> <Blue>0</Blue> </Color> <Visible>false</Visible> </Outline> <Insets> <Top>0.0</Top> <Left>2.0</Left> <Bottom>0.0</Bottom> <Right>3.0</Right> </Insets> <Visible>true</Visible> Above false 0.0 0.0 465.75 361.5 3.0 3.0 3.0 3.0 -1 -1 -1 -1 1 255 0 0 0 false 0 255 255 255 true Two_Dimensional Points 10.0 6,4,12,8,10 6,4,12,8,10 0 None Linear <Caption> <Value>Durée</Value> <Font> <Size>14.0</Size> <Bold>true</Bold> <Alignment> <horizontalAlignment>Center</horizontalAlignment> <verticalAlignment>Center</verticalAlignment> </Alignment> <Rotation>0.0</Rotation> </Font> </Caption> <Background xsi:type="attribute:ColorDefinition"> <Transparency>0</Transparency> <Red>255</Red> <Green>255</Green> <Blue>255</Blue> </Background> <Outline> <Style>Solid</Style> <Thickness>1</Thickness> <Color> <Transparency>255</Transparency> <Red>0</Red> <Green>0</Green> <Blue>0</Blue> </Color> </Outline> <Insets> <Top>0.0</Top> <Left>2.0</Left> <Bottom>0.0</Bottom> <Right>3.0</Right> </Insets> <Visible>true</Visible> Below Linear <Caption> <Value>Recette</Value> <Font> <Size>14.0</Size> <Bold>true</Bold> <Alignment> <horizontalAlignment>Center</horizontalAlignment> <verticalAlignment>Center</verticalAlignment> </Alignment> <Rotation>90.0</Rotation> </Font> </Caption> <Background xsi:type="attribute:ColorDefinition"> <Transparency>0</Transparency> <Red>255</Red> <Green>255</Green> <Blue>255</Blue> </Background> <Outline> <Style>Solid</Style> <Thickness>1</Thickness> <Color> <Transparency>255</Transparency> <Red>0</Red> <Green>0</Green> <Blue>0</Blue> </Color> </Outline> <Insets> <Top>0.0</Top> <Left>2.0</Left> <Bottom>0.0</Bottom> <Right>3.0</Right> </Insets> <Visible>true</Visible> Left row["nomcourt"] false 1.0 Text Sum 255 80 166 218 255 242 88 106 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false row["recette"] Orthogonal_Value , Above false Star 4 true 1 0 255 255 255 false false false 0 255 255 255 false false 1.0 Text Sum Ascending row["nomcourt"] Vertical 1 true 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true Left 1 255 196 196 196 false Across 1 255 196 196 196 true 1 255 225 225 225 false Across 1 255 225 225 225 false 5 Min 0.0 true false 255 80 166 218 255 242 88 106 255 232 172 57 255 128 255 128 255 64 128 128 255 128 128 192 255 170 85 85 255 128 128 0 255 192 192 192 255 255 255 128 255 128 192 128 255 7 146 94 255 0 128 255 255 255 128 192 255 0 255 255 255 255 128 128 255 0 128 192 255 128 128 192 255 255 0 255 255 128 64 64 255 255 128 64 255 80 240 120 255 0 64 128 255 128 0 64 255 255 0 128 255 128 128 64 255 128 128 128 255 255 128 255 255 0 64 0 255 0 0 0 255 255 255 255 255 255 128 0 true 0 255 255 255 1 255 0 0 0 false 0.0 2.0 0.0 3.0 false row["dureemoyenne"] Orthogonal_Value , Outside false false 1.0 Text Sum Horizontal 1 true 0 255 255 255 1 255 0 0 0 0.0 2.0 0.0 3.0 true Below false 1 255 196 196 196 false Across 1 255 196 196 196 true 1 255 225 225 225 false Across 1 255 225 225 225 false 5 false Value 0.0 true false false Vertical 50.0 false ]]>

SVG dispersionparghm 5.020833333333333in 6.46875in

ghm dataSetRow["ghm"] string libelle dataSetRow["libelle"] string concat(a.ghm," - ",b.libelle) dataSetRow["concat(a.ghm,\" - \",b.libelle)"] string nomcourt dataSetRow["nomcourt"] string sum(charges) dataSetRow["sum(charges)"] float sum(produits) dataSetRow["sum(produits)"] float sum(a.duree) dataSetRow["sum(a.duree)"] decimal count(a.numsejour) dataSetRow["count(a.numsejour)"] decimal recette dataSetRow["recette"] integer dureemoyenne dataSetRow["dureemoyenne"] integer

#C0C0C0 bold 15pt 15pt center

Détail par médecin

dureemoyenne

Group/nomcourt dureemoyenne_Group/nomcourt

Durée

recette

Group/nomcourt recette_Group/nomcourt

recette

Group

Group/nomcourt

nomcourt

Data Cube

nomcourt dimension["Group"]["nomcourt"] string dureemoyenne_Group/nomcourt measure["dureemoyenne"] integer

Group/nomcourt

sum recette_Group/nomcourt measure["recette"] integer

Group/nomcourt

sum