In this chapter you can find instructions on how to Set up the "Current Production Orders Status (Planed vs. Made)" Dashboard.
For information on how to setup an independent Dashboard click on Cockpit Dashboards.
Query needed for this Dashboard: "Beas_ProductionOrderStatus":
SELECT "AUFTRAGINT",
CAST("AUFTRAGINT" as VARCHAR) as "KA-Nr",
"MIN_SOLL",
"MIN_IST",
case when "MIN_IST"=0 then 0
when "MIN_SOLL"=0 then 0
when "MIN_SOLL" IS NULL then 0
when "MIN_IST" IS NULL then 0
else ("MIN_IST"/"MIN_SOLL"*100)
end as "Fertigungszeit in %",
"MENGE",
"GEL_MENGE",
case when "GEL_MENGE"=0 then 0
when "MENGE"=0 then 0
when "GEL_MENGE" IS NULL then 0
when "MENGE" is null then 0
else "GEL_MENGE"/"MENGE"*100
end as "Materialverbrauch in %"
FROM "BEAS_FTPOS"
where CAST("AUFTRAGINT" as Varchar) >0
Creating the Current Production Orders Status (Planned vs. Made) Dashboard
1. Access the Pervasive Analytics Module, and click the "New Dashboard" button. (There is an explanation on how to access the "Pervasive Analytics" Module on the page:Cockpit Dashboards ).
Then, click the Data Source Icon to enter the "Dashboard Designer" window, and select the previously created query "Beas_ProductionOrderStatus" and click OK. (View: Cockpit Beas Queries).
2. Drag and drop the fields "MIN_SOLL" and "MIN_IST" to the "Target Measures" section.
Drag and Drop the field "KA-Nr" to the "Target Dimensions" section.
If wanted is possible to change the name of the fields by clicking on the black arrow on each field.
MIN_SOLL = Planned
MIN_IST = Real
3. Click the "Save As" Icon, and introduce the name "Beas – Production Order Status".
Click "OK".
4. Add the newly created dashboard to the Cockpit main page.
There is a section on how to add one particular dashboard to the cockpit on the Cockpit Dashboards page.