GE Proficy 生產(chǎn)管理（MES）數(shù)據(jù)集市解決方案介紹

Proficy*DataMartv2.1

金嘉林資深解決方案參謀GEIntelligentPlatforms什么是DataMart ProficyDataMart是基于SQLServerOLAP的數(shù)據(jù)分析軟件。 Proficy*DataMart強(qiáng)化了Proficy產(chǎn)品家族企業(yè)制造智能〔EnterpriseManufacturingIntelligence，EMI)領(lǐng)域的能力。提供上百種報表、視圖，是對ProficyPlantApplication分析功能的有效補(bǔ)充PlantManagerProductionFinanceQualityMaterialsLean/6SigmaOperatorMaintenance廠級報表–合規(guī)–持續(xù)改進(jìn)–供給鏈整合-EAI生產(chǎn)數(shù)據(jù)可視化分析報表運(yùn)營優(yōu)化實(shí)時執(zhí)行數(shù)據(jù)的可視化準(zhǔn)確而及時的訪問全球生產(chǎn)數(shù)據(jù)，這是必須的?。?！生產(chǎn)數(shù)據(jù)存儲于多個生產(chǎn)基地定制開發(fā)報表的高本錢報表的維護(hù)的本錢長周期數(shù)據(jù)分析的報表性能報表系統(tǒng)對生產(chǎn)系統(tǒng)的影響

企業(yè)級報表遇到的挑戰(zhàn)ProficyDataMart特點(diǎn)高性能分析平臺支持單站點(diǎn)及多站點(diǎn)分析企業(yè)級多生產(chǎn)基地運(yùn)營指標(biāo)評測比照使用標(biāo)準(zhǔn)技術(shù)的企業(yè)級報表策略用于處理負(fù)責(zé)的聚合、集成數(shù)據(jù)對于集團(tuán)級領(lǐng)導(dǎo)查看下屬所有工廠生產(chǎn)領(lǐng)域的運(yùn)營情況。通過KPI對工廠生產(chǎn)進(jìn)行評估，并推進(jìn)生產(chǎn)領(lǐng)域的持續(xù)改進(jìn)。得到真實(shí)的生產(chǎn)本錢對廠級領(lǐng)導(dǎo)了解本廠的生產(chǎn)運(yùn)營情況提高各車間協(xié)作減少及控制本錢(制造人工,維護(hù),&庫存)通過早期預(yù)警降低廢品率對工程師通過對MTTR&MTBF分析提高操作能力

TopN報表快速定位問題根據(jù)班別班組的生產(chǎn)質(zhì)量報表針對細(xì)顆粒度生產(chǎn)過程數(shù)據(jù)的因果分析DataMart架構(gòu)Proficy*DataMartv2.1

Proficy*Portal工廠層生產(chǎn)數(shù)據(jù)

(傳感器,儀表、PLC,HMISCADA,其他.)Proficy*HistorianProficy*PlantApplications第三方工具Proficy*DataMart數(shù)據(jù)來源及發(fā)布

34RuntimeClientWebReportsExcelAdd-InWebPartsProficyPortalReportingServicesExcel134ProficyPlantApplication在線數(shù)據(jù)庫，存儲在線生產(chǎn)數(shù)據(jù)已經(jīng)已經(jīng)經(jīng)過預(yù)聚合處理的OLAP數(shù)據(jù)立方體.在DataMart中創(chuàng)立的一個新數(shù)據(jù)庫，包含了所有生產(chǎn)數(shù)據(jù)，但適合進(jìn)行報表分析。ETL腳本，用于同步、處理、整合數(shù)據(jù).12ProficyDataMart架構(gòu)方案1

423455RuntimeClientWebReportsExcelAdd-InWebPartsProficyPortalReportingServicesExcel13451ProficyPlantApplication同步離線數(shù)據(jù)庫，存儲離線生產(chǎn)數(shù)據(jù)22ProficyDataMart架構(gòu)方案2

ProficyPlantApplication在線數(shù)據(jù)庫，存儲在線生產(chǎn)數(shù)據(jù)已經(jīng)已經(jīng)經(jīng)過預(yù)聚合處理的OLAP數(shù)據(jù)立方體.在DataMart中創(chuàng)立的一個新數(shù)據(jù)庫，包含了所有生產(chǎn)數(shù)據(jù)，但適合進(jìn)行報表分析。ETL腳本，用于同步、處理、整合數(shù)據(jù).企業(yè)級部署ProductionSite11ProductionSite2ProductionSite3Proficy*DataMartDatamart配置–單站點(diǎn)Datamart配置–多站點(diǎn)Datamart配置–發(fā)布&別離部署數(shù)據(jù)顯示Proficy*DataMart將提供

標(biāo)準(zhǔn)

OLAPcube，其中包含報表開發(fā)所需的所有生產(chǎn)數(shù)據(jù)及數(shù)據(jù)之間的關(guān)系。任何符合MicrosoftOLAP標(biāo)準(zhǔn)的客戶端都能訪問這些數(shù)據(jù)包括 -Proficy

Portal -SQLReportingServices -MicrosoftExcel

-其他OLAP客戶端

Excel:Proficy

DataMartribbonExcel:Examplepivottable&chartExcel:ConditionalformattingforheatmapsExcel:DrillingdowntodetaileddataExcel:DrilleddowntothedetaileddataProficyPortalExampleSQLReportingServices(SSRS)簡單易用的報表工具豐富的報表對象預(yù)定義格式打印DataMart專用OLAPconnector可修改模板可以與PlantApps共享報表效勞SQLReportingServices實(shí)例與其他Proficy軟件集成與PlantApplicationsDashboard&ReportServerPlantApps單站點(diǎn)數(shù)據(jù)中短期數(shù)據(jù)分析自動發(fā)布效勞DataMart多層面數(shù)據(jù)分析多站點(diǎn)KPI評估復(fù)雜數(shù)據(jù)分析、長期數(shù)據(jù)分析OLAP數(shù)據(jù)庫結(jié)構(gòu)與

Real-TimeInfoPortalRTIP實(shí)時監(jiān)視生產(chǎn)過程畫面

豐富的顯示對象及數(shù)據(jù)源定制個人視圖DataMartRoll-ups&Drill-downs數(shù)據(jù)分析更好的讀取速度及數(shù)據(jù)容量性能技術(shù)細(xì)節(jié)Cube典型的生產(chǎn)數(shù)據(jù)Cube上行數(shù)據(jù)：產(chǎn)量下行數(shù)據(jù)：報廢量三個維度：產(chǎn)品、時間、生產(chǎn)線三個維度有層級定義

度量值組MeasureGroupNameIDDescriptionAlarmsvFactAlarmDurationsforAlarms,TimetoAcknowledge,andResearchNumSeconds.MeasureforTimeSliceWeighting.BatchCycleTimevFactBatchCycleTimeDurationsforBatches,UnitProcedures,Phases,andOperations.EventReasontoReasonCategoryvFactEventReasonCategoryInternal:UsedtoMapReasonstoReasonCategoryGeneralProductionvFactUnitProductionMeasuresforTimeandEventBasedProductionandWasteProratedbyTime.ProducttoProductGroupvFactlessProductProductGroupInternal:UsedtoMapProductstoProductGroupsProductionEventComponentsvFactEventComponentMeasuresoftheSourceMaterialforaProductionEvent.ProductionEventsvFactProductionEventMeasuresderivedfromEventBasedProduction.TestResultsvFactTestResultMeasuresderivedfromTestResults.TimedEventsvFactTimedEventDetailMeasuresderivedfromTimedEvents.UnitEfficiencyvFactUnitEfficiencyMeasuresforReportingEfficiency.UserDefinedEventsvFactUserDefinedEventGenericUser-DefinedEventInformation.WasteEventsvFactWasteEventDetailMeasuresderivedfromWasteEvents.維度列表Y=objectexists;

N=objectdoesnotexistReportingDatabaseCubeAlarmDescriptionY

YCommentsYNCrewYYEYectronicSignature(FactBasedDimension)ViewOnlylEngineeringUnitConversionYNEngineeringUnitsYNEventComponent(FactBasedDimension)ViewOnlyYEventFault(bothdowntimeandwastefaultsrecordedhere)YYEventReasonYYEventReasonCategoryYYEventType(includessubtypes)YYFaultSourceLocation(DerivedfromUnitDimension)NYInventoryLocationNYMaterialInputYYNon-productiveTimeEvent(FactBasedDimension)ViewOnlyYProcessOrderYYProductYYProductDefinitionYYProductGroupYYProductionEventViewOnlyY維度列表〔續(xù)〕ProductionMetricsYNProductionPathYYProductionStatusYNProductionUnit(includesunits,lines,departments,andlinkstotablesforproductionmetricsand/orinventorylocations,dependingontheunittype)YYShiftYYSite(ageographicsite,whichmayincludemanysourcedatabases)YYSourceEventNYSourceEventTypeNYSourceProductNYSt