The consolidated data warehouse object - SmartPlant Foundation - IM Update 46 - Help - Hexagon

SmartPlant Foundation Help

Language
English
Product
SmartPlant Foundation
Search by Category
Help
SmartPlant Foundation / SDx Version
10
SmartPlant Markup Plus Version
10.0 (2019)
Smart Review Version
2020 (15.0)

The limitations presented by the shared object are overcome with the introduction of the consolidated data warehouse (CDW) object.

  • The CDW object replaces the shared object by a configurable set of class definitions, which are based on the shared object definition in the initial demonstration model.

  • Each class definition has fully-modeled interfaces, properties, and relationships that are used to store data, and they are consolidated from the published objects.

  • The SmartPlant schema is mapped to the CDW schema to control which properties or relationships from published objects are consolidated to the CDW objects.

  • In the default implementation, consolidation is limited to display the last published value of a property shared across multiple tools.

  • Correlation is limited to data published with the Same As relationship. For example, when using the retrieve and publish operation. The SmartPlant Foundation Auto-Correlate functionality is available for CDW using correlation by name.

  • The structure of the CDW objects can be summarized by the following diagram:

  • Queries are fully supported and can be used to find the CDW object in the database because the CDW object has direct access to the published data, unlike the shared object.

  • Custom list view column sets for viewing CDW object data are fully supported.

  • In addition to consolidating properties or relationships from published objects, the CDW objects are classified and related to the classification tree.

  • Relationship navigation is now easier, either individually or by edges, for example, from CDW object to CDW object, such as instrument to pipeline.

     

  • Navigation to the related published objects, viewing inconsistencies, and running inconsistencies reports are exactly the same as when using the shared object technology.

  • The CDW objects can be enhanced over and above the storage of published data. For example, the CDW schema can be extended to store data for purchasing or for construction status management information. This can be done by adding interfaces with properties or relationships.