PiLog Master Data Quality Manager (PiLog-MDQM™)
The PiLog Master Data Quality Manager (PiLog-MDQM) is an integrated platform for collecting and managing master data that is transferred to a target EAM/CMMS or ERP applications. The PiLog-MDQM solution is available under Software as a Service (SaaS) license as a web hosted application or as a client hosted integrated application. All data exchanges are complaint with ISO 22745.
In the SaaS model, the application and the data are hosted on a PiLog managed server outside of the client's firewall. In the client hosted configuration, the applications are hosted on the client's server within its firewall. It is possible to manage the ontology and data acquisition using the SaaS configuration, while managing the product, service or vendor master data on a client hosted server behind a firewall.
Web Hosted PiLog Master Data Quality Manager
The PiLog web hosted master data quality manager is split into three functional modules:
The PiLog Master Data Ontology Manager (PiLog-MDOM™) module allows users to convert their corporate business language into a formal ontology. The dictionary manager application is used to create a corporate preferred dictionary as a subset of the Open Technical Dictionary (eOTD). The eOTD contains over two million concepts with associated multilingual terminology sourced from leading international, national and industrial standards. The data requirement application is used to create and manage data requirements or cataloging templates, these are used in the Master Data Record Manager module to measure the quality of master data as well as for data capture and for cataloging at source. Included in the module is also a classification manger that allows the creation and management of multiple classifications either in a manual edit mode or through automated mapping to industry classifications such as the UNSPSC, CPV, NCS and many others. The PiLog ® MDOM can be implemented as a standalone module, or integrated with other PiLog modules or applications.
The PiLog Master Data Record Manager (PiLog-MDRM™) is the workhorse of the web hosted master data quality manager modules. The PiLog-MDRM module manages master data hosted on a PiLog server and provides continuous quality monitoring. Users can add and edit data depending on their permission and all data is continuously monitored through an Item Entry Control (IEC) application, which combined with a powerful search application protects the user from creating duplicate records. One of the key applications in this module is the ISO 22745 Cataloging at Source (C@S) application. This application is used to create and process ISO 22745 requests for data through an interface with the PiLog Cataloging at Source Server. The PiLog-MDRM module tracks the provenance (source) of all data elements in a master data record.
The PiLog Master Data Configuration Manager (PiLog-MDCM™) allows users to generate multiple descriptions in multiple languages from the hosted master data. The module leverages the multilingual terminology stored in the ontology and applies rendering rules to auto generate descriptions. The module includes applications that make it easy to select and sequence data elements as well as abbreviations and apply formatting rules for case, punctuation and overall length.
The PiLog Master Data Integration Manager (PiLog-MDIM™) module provides the ability to synchronize data in the ontology, the master data or the generated descriptions with any target system using either a push or a pull solution.
Client Hosted PiLog Master Data Quality Manager
The PiLog client hosted master data quality manager is split into five functional modules:
The PiLog Product Catalog Manager (PiLog-PCM™) is the ideal solution for the management and maintenance of a buyer catalog residing in the material master of an ERP system, e-commerce buying solutions or for suppliers to manage their catalogs for e-commerce trading. It is designed to ensure consistency in the cataloging process and to deliver well structured descriptions in accordance with international standards.
The software is Java based and is flexible, modular, scalable and suitable as a standalone system for small companies with basic cataloging needs. It can also be deployed over the internet to fulfill the sophisticated catalog management needs of a large global corporate company with distributed business units and a variety of ERP solutions.
The following are some of the standard features of the PiLog-PCM module:
- Utilize any of the major global cataloguing standards, USC, eOTD, MESC, UNSPSC, etc.
- Standardized templates used to guide the cataloguer.
- Use available data - clarify and identify missing data elements.
- Powerful and accurate search and item identification engine.
- Create structured and standardized practical short descriptions, including SAP 40 character short descriptions.
- Create clear, concise and complete purchasing descriptions to uniquely describe each item.
- Identify potential duplicates using part numbers or attribute values.
- Simple to use, no specialized codification skills required.
- Enhanced bulk data entry, standardization and description generation features.
- Potential duplicate resolution processes to de-duplicate the item master.
- Manage common items across warehouses and business units.
- Manage a corporate catalogue across multiple business units with multiple ERP's.
The application facilitates the linking and viewing of any amount of images and documents from a single item number. All images are stored in their native format and viewed with the native application.
The PiLog-PCM can be implemented as a standalone module or can be fully integrated into any ERP material master module with standard interface software such as SAP, IFS, MIMS, Maximo, etc.
The PiLog-PCM module, as with all of the other PiLog modules, allows for powerful data browsing, data mining and on-the-fly report creation features. Reports are available in tabular, graphical and hierarchical formats. Data can also be exported into Microsoft Office.
Comprehensive Audit Trails
Audit trails are embedded throughout the system so that all additions and changes can be monitored.
Powerful security features were incorporated during the system design allowing various levels of control at multi-tiered, as well as, across functional levels. Security can be deployed per user or role thereby not only limiting access, but also ensuring that data integrity is maintained.
- Improved procurement practices at lower costs.
- Accurate, comprehensive and standardized descriptions lead to end users finding items in the material masters.
- Improved spend analysis for single business units, as well as, incorporated with multiple business units.
- Improved contract management, as well as, contract based buying.
- Enhanced collaborative centralized buying and contracting across business units.
- Reduced inventory due to the identification of duplicates (single warehouse) and common items (across warehouses and business units).
- Class (domain, noun qualifier, item name, commodity): a group that has common properties.
- Classification (hierarchy, category sets, taxonomy): a structure of classes and subclasses.
- Property (attribute, characteristic): the label of a data element used to describe an entity.
- Property Value Pair: instance of a specific value, together, with an identifier for a data dictionary entry that defines a property.
- Characteristic Data: description of an entity by the class to which it belongs and a set of property value pairs.
- Data Requirement Statements (identification guides, FIIGs, IGs, cataloging templates, commercial templates, material or item specifications, form fill specification): a specification of the characteristic data (properties) needed to meet requirements.
- Rendering Guides: a specification of the representation of the characteristic data.