====== Reports ======
Following kinds of reports:
  * Reports for single Cell
    * {{:cli:franke:1st_prio_reports_cellboard.pdf|}}
  * Reports for Department / Plant
    * {{:cli:franke:2nd_prio_reports_cic.pdf|}}
===== Reports for single Cell =====

==== Reports Input ====
^Description^Database Field Name^Rec field name^
|Location|ubicaz.codice|codubi|
|Year of reference| |year|
|Month of reference| |month|

==== Reports Output Monthly ====
^Description^Unit of measure^Formula^Db Field Threshold^Rec field name^
|OEE|%|rv*rf*rq|ubicaz.thmonoee|monthlyoee|
|Setup Percentage|%|setup time / d|ubicaz.thmonsetup|monthlysetup|
|Downtime Percentage|%|f - setup time / d|ubicaz.thmondownt|monthlydownt|
|Scrap Percentage|%|s/np|ubicaz.tmmonscrap|monthlyscrap|

==== Reports Output Daily ====
^Description^Unit of measure^Formula^Db Field Threshold^Rec field name^
|OEE|%|rv*rf*rq|ubicaz.thdayoee|dailyoee|
|Setup Time|%|setup time|ubicaz.thdaysetup|daysetup|
|Downtime Time|%|f - setup time|ubicaz.thdaydownt|dailydownt|
|Scrap Percentage|%|s/np|ubicaz.tmdayscrap|dailyscrap|

==== Threshold ====
For each location (cell / department) will be required following maximum thresholds:
  * monthly OEE %
  * daily OEE %
  * monthly Setup %
  * daily Setup Time (Minute)
  * monthly Downtime %
  * daily Downtime (Minute)
  * monthly Scrap %
  * daily Scrap %

Following Query for modifying ubicaz table:
<code sql>
alter table ubicaz add column thmonoee float;
alter table ubicaz add column thmonsetup float;
alter table ubicaz add column thmondownt float;
alter table ubicaz add column thmonscrap float;

alter table ubicaz add column thdayoee float;
alter table ubicaz add column thdaysetup float;
alter table ubicaz add column thdaydownt float;
alter table ubicaz add column thdayscrap float;

</code>

==== AgentVisualMng Ask ====
^request|cellreports| |
^p1|rec(codubi,year,month)|year and month are optional|

Retval is a Rec containing a field for each Output; each field is a JSon-Object as following:
  * name: name of the output
  * threshold: an array of values refers to limits (one threashold for each x value)
  * xvalues: an array of values refers tp the X axis
  * yvalues: an array of values refers to the Y axis (12 items for monthly, 31 items for daily)
  * um: an array of string, the first element is the unite of measure of X axis(Month, Day), the second element is the unite of measure of Y axis (%, Min)
The Retval Rec will contain also following JSON-Object to define time interval:
  *  monthly: an array of two integer elements; the first is the begin of time interval for yearly horizon, second is the end of the same
  *  daily: an array of two integer elements; the first is the begin of time interval for monthly horizon, second is the end of the same
Example URL Preview: 
<code html>
http://localhost/isw/webapp/enel/proled/iaf/ask/vismng/cellreports/newrec(jsrec,51,1,codubi,year,month)/NULL/0/400791/2017/4?_cnt=17
</code>

Example Javascript Preview: 
<code javascript>
iaf({p1:{codubi:"400791",year:2017,month:4},ag:"vismng",req:"cellreports",nume:0}).ask(function(rv){})
</code>

===== Oee Overview =====
AgentVisualManagement manages OEE-Overview. \\ \\
**Def:** OEE-Overview is an OEE calculation over the hierarchy of the plants, follows the hierarchy \\ \\

We define a central DB in which the hierarchy of location is stored; in particular this information is stored into ubicaz table. \\ \\
Furthermore it's necessary that AgentDataOEE is able to connect specific database where are stored OEE data (fact/dimension). To do that we define into central database following table:
<code sql>
create table dbubi (codubi varchar(51) not null primary key, agdbname varchar(101) not null);
</code>
Following schema of software solution for Global OEE-Overview \\ \\
{{:cli:franke:franke-centrubi.png|}} \\ \\
AgentVisManager, AgentDataOEE, AgentCenterUbica for this topic was stored in a specific platform, in which are defined also all tpevodb agents. \\ \\
Following the current version of this platform: \\ \\
{{:cli:franke:xnet_agents_oee_ovew.xml|}} \\ \\
Following an image rapresent current Plant Hierarchy defined by Simon Fretz \\ \\
{{:cli:franke:selezione_857.png?600|}} \\ \\
For each database we should define the related edge of hierarchy defining Area and Company, both defined as TIPOSET='A' \\ \\
{{:cli:franke:franke-hierarchy.png|}}

====== Additional reports ======
==== Maintenance reports =====
=== Database ====
<code sql>
GRANT SELECT ON public.movimag TO wipreadonly;
GRANT SELECT ON public.ubicaz TO wipreadonly;
GRANT SELECT ON public.causafm TO wipreadonly;
GRANT SELECT ON public.caumaga TO wipreadonly;
GRANT SELECT ON public.anags TO wipreadonly;
</code>
=== Actions ====
  * #report-maintenance-00
  * #report-maintenance-01
=== WIP-SETTINGS ===
  * k:maintenanceReports
  * v:{ odbc:'it.mynext.db.PostgreDb:andon:10.100.145.20:5432:wipreadonly:software', caufm:'U002,fermo', report:{ filename:'mnt_report_unplanned_downtime.jasper', path:'../res/modelli/', outpath:'../res/' }}