Proficy*DataMartv2.1

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

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

TopN報(bào)表快速定位問題根據(jù)班別班組的生產(chǎn)質(zhì)量報(bào)表針對(duì)細(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ǔ)在線生產(chǎn)數(shù)據(jù)已經(jīng)已經(jīng)經(jīng)過預(yù)聚合處理的OLAP數(shù)據(jù)立方體.在DataMart中創(chuàng)立的一個(gè)新數(shù)據(jù)庫，包含了所有生產(chǎn)數(shù)據(jù)，但適合進(jìn)行報(bào)表分析。ETL腳本，用于同步、處理、整合數(shù)據(jù).12ProficyDataMart架構(gòu)方案1

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

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

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

OLAPcube，其中包含報(bào)表開發(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)簡(jiǎn)單易用的報(bào)表工具豐富的報(bào)表對(duì)象預(yù)定義格式打印DataMart專用OLAPconnector可修改模板可以與PlantApps共享報(bào)表效勞SQLReportingServices實(shí)例與其他Proficy軟件集成與PlantApplicationsDashboard&ReportServerPlantApps單站點(diǎn)數(shù)據(jù)中短期數(shù)據(jù)分析自動(dòng)發(fā)布效勞DataMart多層面數(shù)據(jù)分析多站點(diǎn)KPI評(píng)估復(fù)雜數(shù)據(jù)分析、長(zhǎng)期數(shù)據(jù)分析OLAP數(shù)據(jù)庫結(jié)構(gòu)與

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

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

度量值組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