TELKOM
NIKA Indonesia
n
Journal of
Electrical En
gineering
Vol. 12, No. 12, Decembe
r
2014, pp. 83
2
6
~ 833
4
DOI: 10.115
9
1
/telkomni
ka.
v
12i12.64
94
8326
Re
cei
v
ed
Jul
y
15, 201
4; Revi
sed O
c
tob
e
r 12, 201
4; Acce
pted No
vem
ber 5, 20
14
Decision Support Dashboard in OpenERP
Laila Eken
1
, Belaid Bouikhalene
2
, Moh
a
med Fakir*
3
Information pr
o
c
essin
g
an
d de
cision s
upp
ort labor
ator
y
,
F
a
c
u
lt
y
of Science
and T
e
chni
que
s,
Soulta
n Mou
l
a
y
Slim
an
e Univ
ersit
y
Be
ni Me
ll
al, Morocco
*Corres
p
o
ndi
n
g
author, e-ma
i
l
: laila.
e
ken
@
g
m
ail.com
1
, bbo
uikh
ale
ne@
ya
hoo.fr
2
, fakfad@y
a
hoo.fr
3
A
b
st
r
a
ct
T
h
is w
o
rk focu
ses on th
e a
n
a
l
ysis a
nd d
e
si
g
n
of dec
isio
n s
upp
ort das
hbo
ard i
n
Ope
n
ER
P. W
i
th
the a
i
m to i
m
prove t
he Op
eratio
nal
Infor
m
ati
on
S
ystem
OIS of the Morocca
n
uni
versity, Hassa
n 1s
t
Univers
i
ty of SET
T
A
T
launched MISSION project, in
a
ssociati
on w
i
th 22 acad
e
m
ic
and instituti
o
na
l
partners of Mo
rocco an
d the
Europ
e
a
n
Uni
o
n. T
h
is
project
is to impr
ove
the mana
ge
me
nt of Morocca
n
univ
e
rsities. T
h
e visio
n
of the MISSION proje
c
t is to
moder
n
i
z
e
t
he gov
ern
ance of u
n
iver
sities in or
der to
improve
the
qu
ality of s
e
rvice
s
offe
red
by th
e un
iversity
ad
mi
nistratio
n
. T
he b
a
sic
id
ea i
s
to prov
ide
ea
c
h
partner
un
ivers
i
ty in
a OIS us
i
ng
ope
n s
ourc
e
ERP
(Open
E
R
P) a
nd
inte
gr
ating
4
bricks t
r
ades
(scho
o
li
ng,
Financ
e, Hu
man R
e
so
urce
Mana
ge
me
nt (
HRM) an
d H
e
ri
tage). This
ope
ration
al i
n
for
m
ation syste
m
is
not
compl
e
ted
if an
d on
ly if th
ere i
s
a Strateg
i
c In
formati
on Syst
em (SIS) that u
s
es t
he infor
m
ation prov
ide
d
b
y
the first to giv
e
un
iversity l
e
aders th
e o
p
p
o
rtunity to
tak
e
lo
ng-ter
m
de
cisions
an
d thi
s
is the a
i
m of
th
e
secon
d
. One of the tools of SIS w
e
find dash
boar
ds.
Ke
y
w
ords
:
OpenERP, MISSION, OIS
.
Copy
right
©
2014 In
stitu
t
e o
f
Ad
van
ced
En
g
i
n
eerin
g and
Scien
ce. All
rig
h
t
s reser
ve
d
.
1. Introduc
tion
To mode
rni
z
e the govern
ance of the nati
onal a
c
a
demic in
stitution and
stre
ngth its
admini
s
trativ
e and finan
ci
al autonomy,
Hassan 1
s
t University of SETTAT launch
ed MISSION
proje
c
t, in a
s
so
ciation
with
22 a
c
ad
emi
c
and in
st
itutio
nal pa
rtne
rs
of Moro
cco
a
nd the Eu
rop
ean
Unio
n. This p
r
oje
c
t is to improve the ma
nagem
ent
of universities t
h
rou
gh the impleme
n
tatio
n
o
f
an Ope
r
ation
a
l Information
System servi
c
e by introd
u
c
ing O
penE
RP.
The visio
n
of
MISSION project i
s
to mo
derni
ze th
e g
o
verna
n
ce of
universities i
n
ord
e
r
to improve the quality of service
s
offere
d by the uni
versity admini
s
tration that it is level with the
HRM, Ma
nagi
ng herita
ge, Pinnacl
e
Fina
ncial Ma
nag
e
m
ent or da
sh
board for con
t
rolling.
ERP (Ente
r
p
r
ise
Re
sou
r
ce Plan
ning
) ope
n
sou
r
ce allo
w th
e
unive
rsity t
o
have
comp
re
hen
si
ve mana
gem
ent tool
s at
the b
e
st
pri
c
e,
qui
ckly
givin
g
them
a
real
ben
efit in te
rms
of com
petitivene
ss. F
r
ee
software
then
allowed
remo
ving an inte
rmedia
r
y (di
s
tributor), re
du
cing
developm
ent co
sts by re
usi
ng of open
so
urce soft
ware
.
MISSION project i
s
to
improve
the
mana
gem
e
n
t of Mo
ro
ccan
unive
rsi
t
ies by
impleme
n
ting
a Service O
peratio
nal Inf
o
rmatio
n
System SOIS. The obj
ective
of the proj
ect
is
that every Mo
rocca
n
unive
rsity partne
r
will be pr
ovid
e
d
with a SOI
S
using a
n
o
pen sou
r
ce ERP
and integ
r
atin
g 4 bricks tra
des (E
du
catio
n
, Finance, HRM and
He
ritage) [1].
2.
Decision Su
pport Dash
board
Comp
anie
s
a
r
e in
crea
singl
y equipp
ed
with a syste
m
of busi
n
e
ss i
n
telligen
ce
(B
I), whi
c
h
is used to col
l
ect internal a
nd extern
al d
a
ta and
tra
n
sform it into information a
n
a
lyzed by u
s
ers
to make bette
r deci
s
io
ns a
nd improve p
e
rform
a
n
c
e o
f
company.
However, BI
s
y
s
t
ems often treat as
inte
rnal
an
d
qua
ntitative
data. It is
however
necessa
ry for leade
rs to in
tegrat
e
qualit
ative and
external
informa
t
ion that affect their a
c
tivities.
To man
age
a
nd mea
s
u
r
e t
he pe
rform
a
n
c
e of the
co
mpany, man
agers o
r
p
o
licy makers n
eed
synthetic in
di
cators that are grou
ped int
o
dashbo
ard.
Evaluation Warning : The document was created with Spire.PDF for Python.
TELKOM
NIKA
ISSN:
2302-4
046
Dec
i
s
i
on Support Das
h
board
in OpenERP (Laila EKEN)
8327
2.1.1. Dash
boar
d
Da
shb
oard i
s
a tool
fo
r commu
nication an
d d
e
ci
sion
-ma
k
in
g that ena
b
l
es the
manag
eme
n
t controller to
dra
w
the atte
ntion of
the h
ead of the
ke
y points of its manag
emen
t in
orde
r to improve [2].
It may be said that da
shboa
rd
s con
s
ist of
a
set
of carefully sele
cted inf
o
rmatio
n
(num
bers, rat
i
os,
g
r
a
p
h
s
), whi
c
h are synthesi
s
do
cu
ments
the ent
ire ope
ration
and,
by
practi
cal
pre
s
entatio
n sho
u
ld allo
w
leade
rs, with
out re
sea
r
ch or lo
ss of tim
e
, to be a tru
e
and a
c
cura
te
view of the situation of the entity concerned [3].
In short, we
can con
c
lud
e
that dashbo
ard is
a tool that better meets the nee
ds of a
perm
ane
nt quick co
ntrol, a set of both fi
nan
cial, qua
ntitative and qualitative variable
s
.
2.2.2.
Roles o
f
dashboar
d
:
The d
a
shbo
a
r
d i
s
an
in
strument of
co
n
t
rol
an
d
com
pari
s
on. But t
he info
rmatio
n sy
stem
make
s it a tool for dialog
u
e
and commu
nicatio
n
as
well as hel
ping
in deci
s
io
n makin
g
.
To drive bu
si
ness pe
rform
ance, t
he dashboa
rd is
re
spon
sible for:
a) Allow
to
co
n
s
tantly
moni
t
o
r a
c
hi
evem
ents
agai
nst
targets set a
s
p
a
rt of th
e
bud
getary
p
r
oc
es
s
.
b)
Dra
w
attentio
n to the key points
of the
manag
eme
n
t and thei
r po
ssi
ble d
e
viation from th
e
stand
ard fun
c
tions provide
d
.
c)
Allow to
diag
nose
wea
k
n
e
s
ses an
d
sho
w
what i
s
ab
norm
a
l a
nd t
hat ha
s
an i
m
pact
on
the
result of the company [4].
The d
a
shbo
a
r
d u
s
e
s
to
ols
of dialo
gue
a
nd
comm
uni
cation to
achie
v
e the o
b
je
ctives
set
by the compa
n
y of these tools:
a)
The da
shb
o
a
r
d, soo
n
as
it appeared, sh
o
u
ld ena
bl
e a dialogu
e
between th
e different
hiera
r
chi
c
al levels.
b)
It must all
o
w the
sub
o
rdi
nate to
discu
s
s t
he
re
sult
s of
it
s
action,
we
aknesse
s
and
stren
g
ths. It gives more sp
ecific requ
est
s
for ad
dition
al resou
r
ces
or guid
e
line
s
.
c)
The supe
rvisor mu
st
co
ordinate corre
c
tive action
s favoring the
se
arch for a gl
o
bal optimum
rathe
r
than p
a
rtial optimi
z
ations.
d)
Attracting th
e
attention
of
all on
the
sa
me p
a
rameters
, it
plays an inte
g
r
ating
role, giving
to
a spe
c
ific hi
erarchical level, a commo
n la
ngua
ge [5].
As a tool fo
r
deci
s
io
n sup
port, provide
a set
of data
to re
spo
n
si
b
l
e for it
can
guide it
s
deci
s
io
ns a
n
d
action
s to achieve its goal
s da
shb
oard'
s prim
ary vocation. The informatio
n sh
o
u
ld
be reliabl
e, u
nderstan
dabl
e, syntheti
c
a
nd often
pr
od
uce
d
. They
can b
e
u
s
e
d
e
i
ther u
nde
r th
e
sup
e
rvisi
on o
f
delegatio
ns
(whi
ch
are th
en repo
rting
data for th
e
manag
eme
n
t of the comp
any
or respon
sibl
e se
nio
r
level
s
)
or i
n
an
op
tical self (all
resp
on
sible fo
r bu
sin
e
ss m
a
y be affe
cte
d
in
t
h
is ca
se
).
The da
sh
boa
rd al
so h
a
s t
he ad
ditional
missi
on to p
r
omote th
e m
a
stery of eve
n
ts that
occur
up
strea
m
of the financial result
s. It must t
herefo
r
e be rea
c
tive (implying pe
riodicitie
s
cl
ose
diffusion
) an
d contain p
h
ysical indicators in
tun
e
on operational varia
b
le
s (qu
a
lity, time,
flexibility,
variety) that are the
source of value
creation process.
2.2.3. Designing
a
dashbo
ard
:
The de
sign
of the dashb
oard i
s
thro
u
gh cle
a
r a
n
d
pre
c
ise step
s. The sta
g
e
s
of the
desi
gn of the dashbo
ard a
r
e:
a) Missio
n Analysis a
nd def
inition of obje
c
tives:
The dashboard is
suitable
res
ponsibilities; we mu
st cl
early position
responsibiliti
e
s,
missi
on
s and
goal
s assig
n
e
d
to each ma
nage
r.
You cannot jud
ge those re
spo
n
sible on the
basi
s
of an o
b
jective sta
r
ting;
b) Identificati
on of key su
cce
ss fa
ctors:
The tables are based on
skills that must
be ma
stered
or conditions;
it is key strengths
of succe
s
s to meet to achie
v
e the assi
gn
ed obje
c
tive. It is to identify and sel
e
ct th
e most
typical or mo
st relevant, which may in
cl
ude so
me oth
e
rs. Thi
s
is th
e trickiest an
d most
importa
nt because the FCS
are the mea
n
s to
achieve
the objective
s. The qu
ality and
relevan
c
e of the da
shb
oard
depen
ds;
c) Sele
ction o
f
indicators
A perform
an
ce indicator is i
n
formatio
n to hel
p an a
c
tor
or group of a
c
tors to drive
the
cou
r
se of acti
on to achi
eve
a goal or to e
nable them to
evaluate the results.
Evaluation Warning : The document was created with Spire.PDF for Python.
ISSN: 23
02-4
046
TELKOM
NI
KA
Vol. 12, No. 12, Decem
ber 20
14 : 8326 – 83
34
8328
The indi
cato
r is not an obj
ective mea
s
u
r
e but it
is bu
ilt by the author in relatio
n
to the
obje
c
tives p
u
r
su
ed
and th
e actio
n
pla
n
that lead
s.
T
he pe
rforman
c
e in
dicator i
s
not
ne
ce
ssarily
a numbe
r. It can be a qu
alitative judgme
n
t, a binary si
gn, and grap
hic [7].
3.
Presen
tatio
n
of OpenE
R
P
OpenE
RP is an ERP fre
e
licen
se, th
e flex
ibility is ideal for in
depe
ndent. It covers
virtually all
sectors: in
dustry, trade,
servi
c
es, e-
comm
erce, trading,
etc... Li
ke m
o
st open source
softwa
r
e, accessibility, flexibility
and sim
p
licity are the
hallmarks of
developm
e
nt. All features
of
OpenE
RP de
veloped in Python whil
e interfaces a
r
e d
e
velope
d in XML [8].
3.1.1. Modular
Ar
c
h
itec
ture
This
archite
c
ture i
s
n
o
t sui
t
able for
Ope
n
ERP.
It is
in fac
t
shared
by all ERP. It is
the
ability to buil
d
computer applications in a mo
dular
way (independent mo
dules together) whil
e
sha
r
ing a
sin
g
le databa
se
. This makes a significa
nt importan
ce
becau
s
e the
data are no
w
stand
ardi
ze
d
and
sha
r
ed.
Thi
s
eli
m
ina
t
es m
u
ltiple
entrie
s
and
a
v
oids
th
e am
biguity
of sim
ilar
informatio
n. The modul
ar a
r
chite
c
tu
re of OpenE
RP
all
o
ws it to cover seve
ral area
s sh
own in the
Figure 1 [9]:
Figure 1. Modular Archite
c
ture of Ope
n
E
RP
3.1.2. Technic
a
l
Ar
chitec
ture
OpenE
RP i
s
a multitena
nt, three
-
tier architecture
. Th
e ap
plicatio
n
tier itself i
s
written a
s
a core, m
u
ltiple ad
ditiona
l modul
es
ca
n be i
n
stal
l
e
d to cre
a
te
a pa
rticul
ar
config
uratio
n
of
OpenE
RP.
The
co
re
of
OpenE
RP a
n
d
its
mod
u
le
s a
r
e
written
in Python.
The fu
nctio
n
a
lity of a
module i
s
exposed through XML
-
RPC (and/o
r
NET-RPC depen
ding
on the se
rver'
s
config
uratio
n)[#]. Modules
typically make use of
Op
enERP'
s O
R
M to persi
st their data i
n
a
relation
al d
a
taba
se
(Po
s
tg
reSQL
)
. M
o
d
u
les can
in
se
rt data
in
the
datab
ase
du
ring
in
stallation
by providing
XML, CSV, or YML files.
a) The O
pen
ERP se
rver
OpenE
RP p
r
ovides
an
ap
plicatio
n serv
er o
n
which spe
c
ific bu
sin
e
ss
ap
plications
ca
n
be built. It is also
a co
mpl
e
te develop
m
ent frame
w
o
r
k, offering
a range of featu
r
es to
write th
ose
appli
c
ation
s
. The salient feature
s
a
r
e
a flexible
ORM, a MVC architectu
re,
extensible d
a
ta
•L
e
s
salle
s
•
d
isponibles
•P
ayroll
Management
•Leave
Management
•General
Accounting
•cost
accounting
•budgetary
accounting
•
N
umber
of
students
by
step
•
N
umber
of
gir
l
s
compared
to
boys
E
duc
a
t
ion
Finance
Herit
a
g
e
HRM
Evaluation Warning : The document was created with Spire.PDF for Python.
TELKOM
NIKA
ISSN:
2302-4
046
Dec
i
s
i
on Support Das
h
board in OpenERP (Laila EKEN)
8329
model
s and
views, differe
nt repo
rt engi
nes, all ti
ed togethe
r in a coh
e
re
nt, network-a
c
cessi
b
le
frame
w
ork.
From a devel
oper p
e
rspe
ctive, the server ac
t
s
both as a libra
ry which b
r
ing
s
the above
benefits
whil
e hidin
g
the l
o
w-l
e
vel,
nitty-gritty detail
s
, and
as a
simple way to
install, config
ure
and ru
n the written appli
c
at
ions.
b) Mod
u
le
s
By itself, the
Ope
n
ERP
server is not
very u
s
eful.
For
any
ente
rpri
se, th
e v
a
lue
of
OpenE
RP lie
s in
its
differe
nt modul
es. I
t
is the
rol
e
o
f
the mod
u
le
s to i
m
plem
e
n
t any b
u
si
ne
ss
need
s. The server is o
n
ly the nec
essa
ry
machin
ery to run the mod
u
les. A lot of
module
s
alre
ady
exist. Any official O
penE
RP relea
s
e i
n
cl
ude
s ab
out 1
70 of them, a
n
d hu
ndred
s
of modul
es
a
r
e
available th
rough th
e
co
mmunity. Example
s
of
m
o
dule
s a
r
e A
c
count,
CRM
, HR, M
a
rket
ing,
MRP, Sale, etc
.
A module (Fi
gure
3) i
s
usually com
p
o
s
ed of
data m
odel
s, togeth
e
r with
som
e
initia
l
data, views
d
e
finitions (i.e.
ho
w d
a
ta fro
m
spe
c
ific
dat
a mo
dels
sho
u
ld b
e
di
spl
a
yed to
the
user),
wizard
s (sp
e
c
iali
zed
scre
ens to h
e
lp the user fo
r specifi
c
interactions),
workflows definitions,
and re
po
rts.
c) Clients
Client
s ca
n communi
cate
with an O
pen
ERP se
rver
usin
g XML-RPC. A custo
m
, faster
protocol
called NET-RPC i
s
also
provided but will shortly disa
ppear, replaced
by JSON-RPC.
XML-RP
C, a
s
JSO
N
-RP
C
in the future
, make
s it
possible to wri
t
e clients fo
r OpenE
RP in a
variety of progra
mming l
angu
age
s. O
penERP S.A.
develop
s two different cli
ents: a de
sktop
client, written
with the
wid
e
ly use
d
GT
K+ graphi
cal
toolkit, and
a
web
cli
ent th
at sho
u
ld
run
in
any mode
rn
web b
r
o
w
ser.
As the l
ogi
c o
f
OpenE
RP should
entirely re
side
on th
e serve
r
, the
client i
s
con
c
eptually
very simple; i
t
issue
s
a
re
que
st to the serve
r
an
d di
splay the result (e.g. a list
of custom
ers) in
different manners (as forms, lists,
cal
e
ndars, ...). Upon user
actions
,
it
will send modified data
to
the s
e
rver [10].
Figure 2. Technical Archite
c
ture of O
pen
ERP
3.1.3.
Open Obje
ct Frame
w
o
rk
Open O
b
je
ct is the Fram
ewo
r
k of Op
enERP, or p
r
ogra
m
to ge
nerate O
pen
ERP. It is
very
flexible and com
p
re
h
ensive,
a
nd enabl
es
th
e
cre
a
tion
of b
u
sin
e
ss a
p
pli
c
ation
s
, what
ever
they are.
Develo
p ma
n
ageme
n
t ap
p
lication
s
with
Ope
n
O
b
je
ct, far mo
re th
an a
n
y othe
r tool of
this type. A
Python file containin
g
the
descripti
on of
fields and busi
n
e
ss rule
s
a
r
e created
,
an
XML file de
scribing
the
screen
s. Of cou
r
se, the
r
e i
s
no limitation to the codes, t
h
is i
s
written
in
Python, very
rich la
ngu
age
.
If we need t
o
go furth
e
r,
Open
Obje
ct
allows the
creation
of Wi
zards
(sub
progra
m
s),
automating ta
sks an
d plan
ning, data int
egratio
n [6].
Evaluation Warning : The document was created with Spire.PDF for Python.
ISSN: 23
02-4
046
TELKOM
NI
KA
Vol. 12, No. 12, Decem
ber 20
14 : 8326 – 83
34
8330
Figure 3. Structure of O
p
en
ERP Module
3.1.4. Model
MVC
Model–Vi
e
w–
Controlle
r (M
VC) i
s
a
software a
r
chitectural patte
rn f
o
r impl
ementi
n
g u
s
e
r
interfaces. It
divide
s a
gi
ven software
appli
c
atio
n i
n
to thre
e int
e
rconn
ecte
d
parts,
so a
s
to
sep
a
rate i
n
te
rnal
rep
r
e
s
en
tations of info
rmation
from
the way
s
that
informatio
n i
s
presented t
o
or a
c
cepted
from the u
s
e
r
. The centra
l comp
one
nt, the model,
con
s
i
s
ts of a
pplication dat
a,
busi
n
e
s
s rule
s, logi
c and
f
unctio
n
s. A
view
ca
n b
e
a
n
y output
re
pre
s
entatio
n
of inform
atio
n,
su
ch a
s
a ch
art or a diag
ram. Multiple views of the same inform
ation are p
o
ssib
le, such as a
bar
cha
r
t for m
a
n
ageme
n
t and
a tabula
r
vie
w
for
acco
u
n
t
ants. Th
e third part,
the co
ntrolle
r,
acce
pts
input and
con
v
erts it to co
mmand
s for t
he model o
r
view [11].
In OpenERP,
you can ap
pl
y the semanti
cs of
Mo
del-V
iew-Co
ntrolle
r (Figu
r
e 4
)
with:
a)
Model: T
he
model
s a
r
e
reporte
d in
O
penERP
obj
e
cts. T
hey a
r
e
also Po
stgre
S
QL
tables.
b)
View: views a
r
e define
d
in XML files in OpenE
RP
c)
Controlle
r: The controlle
r is
Python which controlling
OpenE
R
P
Figure 4. Model–Vie
w–
Co
ntrolle
r
4. Application
To acce
ss th
e appli
c
ation,
we mu
st first
be authenti
c
ated
(Figu
r
e
5). After pre
s
entin
g
the
three sections (Figure 5,
6
a
nd
7) that we work
with, now we
will introduce the m
o
dul
e
t
hat
we devel
ope
d « Da
shb
oard ».
Evaluation Warning : The document was created with Spire.PDF for Python.
TELKOM
NIKA
ISSN:
2302-4
046
Dec
i
s
i
on Support Das
h
board
in OpenERP (Laila EKEN)
8331
Figure 5. Authentication In
te
rface
Figure 6. Apogée sectio
n
Figure 7. Heri
tage se
ctio
n
Figure 8. HR
Section
Figure 8. Module Dashbo
ard
In the "Activity Report
s
" found the miter
"D
ashbo
ard" that contain
s
three b
r
icks:
a)
Grade
s;
b)
Education;
c
)
Heritage.
a) Gra
d
es
:
This
se
ction
(Figure 1
0
)
gi
ves u
s
a
tabl
e an
d a
grap
h with th
e n
u
m
ber of em
pl
oyees in
each gra
de.
Evaluation Warning : The document was created with Spire.PDF for Python.
ISSN: 23
02-4
046
TELKOM
NI
KA
Vol. 12, No. 12, Decem
ber 20
14 : 8326 – 83
34
8332
Figure 9. Gra
ph employe
e
s by grad
e
b) Educa
t
ion
In this pa
rt, there
are fo
ur grap
hs th
at give
us a vie
w
of en
rollm
ent in the un
iversity
(Figu
r
e 11, 1
2
, 13, 14, 15 and 16
).
Figure 10. Graph of stud
en
ts by gende
r
Figure 11. Nu
mber of en
roll
ments by ste
p
Evaluation Warning : The document was created with Spire.PDF for Python.
TELKOM
NIKA
ISSN:
2302-4
046
Dec
i
s
i
on Support Das
h
board
in OpenERP (Laila EKEN)
8333
Figure 12. Nu
mber of stu
d
e
n
ts enrolled e
a
ch yea
r
Figure 13. % of student
s e
n
rolle
d in ea
ch year
Figure 14. Nu
mber of stu
d
e
n
ts per
establ
ishme
n
t
Evaluation Warning : The document was created with Spire.PDF for Python.
ISSN: 23
02-4
046
TELKOM
NI
KA
Vol. 12, No. 12, Decem
ber 20
14 : 8326 – 83
34
8334
Figure 15. Nu
mber of stu
d
e
n
ts
per
establ
ishme
n
t percentage
c) Patrimoine:
Figure 16. Nu
mber of r
oom
s by establi
s
h
m
ent
5.
Conclu
sion & Perspe
ctiv
es
As a
con
c
lu
sion
we
ca
n
say that
the
work in th
e
worl
d
of op
e
n
sou
r
ce, an
d mo
re
spe
c
ifically an ERP (Enterprise
Re
so
urce Planni
ng)
as Ope
n
ERP
has allo
wed
us to learn m
o
re
about thi
s
a
r
ea, incl
udin
g
the python
and u
s
e
of
framework "O
pen O
b
je
ct", and joi
n
a gl
obal
comm
unity of more th
an 1
,
500 individu
als involv
e
d
also i
n
re
se
a
r
ch
and
deve
l
opment of n
e
w
module
s
to facilitate the integratio
n of su
ch a
solution i
n
all profe
ssi
onal an
d so
ci
al domain
s
.
As persp
ectiv
e
, we propo
se to add ano
ther f
eature to the appli
c
a
t
ion as the o
c
cupie
d
room
s.
Referen
ces
[1]
Claude A
L
AZA
RD, Sabine S
EPARI
; DECF, 5 editions
« c
ontrôle de
gest
i
on
» editio
n Dunod; page :
591
[2]
Abde
lham
id EL
GADI 3 edition
s « Audit et contrôle d
e
gesti
on » ; pag
e : 32
[3]
Clau
de AL
AZAD et Sabin
e
S
EPARI, DCG 11 « contrôl
e
de
gestion »
éditi
on Du
no
d ; page : 634
[4]
Claude ALAZAD et Sabine S
EPARI, DECF
5 edi
tions, « contrôle de
gestion » ; page :600
[5]
Abde
lham
id EL
GADI 3 edition
s « Audit et contrôle d
e
gesti
on » ; page : 3
2
[6] http://
w
w
w
.
u
h
1
.
ac.ma/formation-e
n
-op
en-
er
p-da
ns-le-c
adr
e-du-
proj
et-tempus
[7] http://
w
w
w
.
me
moireo
nl
ine.co
m/10/09/28
05/
m_Ana
l
yse-crit
iqu
e
-du-s
y
ste
m
e-
de-c
ontrol
e
-de-g
e
stion-
dun
e-entr
epris
e-detat1
5
.html.
[8] http://
w
w
w
.
j
u
li
u
s
.fr/openerp/
[9] http://
w
w
w
.
openerp.com
[10] https://doc.ope
nerp.com/
6.0/
d
e
vel
oper/1
_2
_
m
odu
le_
dev
elo
p
ment/1_s
erve
r_mod
u
le/
[11] https://doc.ope
nerp.com/
6.0/
d
e
vel
oper/1
_2
_
m
odu
le_
dev
elo
p
ment/1_s
erve
r_mod
u
le/
[12] http://en.
w
i
kipedia.org/
w
iki/Mo
del
%E2%
80
%
93vi
e
w
%
E
2
%
8
0%9
3
contr
o
ll
er
Evaluation Warning : The document was created with Spire.PDF for Python.