Administrator Actions

Asset Hierarchy Configuration

GE Digital APM is built on the premise that, within your company, there are multiple records that can be organized into a hierarchy. This organization relies on the parent-child relationship between records to represent the fact some records can belong to other records.

The Hierarchy can be modified to reflect a custom family. However, the baseline configuration relies on the Functional Location family and the fields in each Functional Location record to define which location each represents. Because there is only one Functional Location family, it is used to store data about all of your locations, where the values in each Functional Location record identify which type of location it is.

The baseline configuration assumes that Functional Locations have Functional Locations and that Equipment is found at the lowest levels of Functional Locations. For example, three pieces of equipment might belong to the same Functional Location, meaning the Functional Location resides on a higher level of the hierarchy than the Equipment.

More Details: Baseline Configuration

In the baseline configuration, there are two levels reflected in the Asset Hierarchy: the Root and a secondary level. The primary level of the Hierarchy, the Root, reflects the Functional Location relationships. The second level of the hierarchy reflects Equipment related to Functional Locations. The hierarchy first displays the Root Function Location, and drills down to child Functional Locations based on your selections. The hierarchy will continue to do so until there are no child relationships for the selected Functional Location. Then, using the criteria defined in the second level, the hierarchy will display Equipment records related to the selected Functional Location.

The baseline configuration is as follows:

  • Root: The primary level of the hierarchy.
    • Parent Family: Functional Location
    • Relationship: Functional Location Has Functional Location(s)
    • Child Family: Functional Location
    • Display Field: Functional Location Description
    • Taxonomy Category: Taxonomy Category
    • Taxonomy Class: Taxonomy Class
    • Taxonomy Type: Taxonomy Type
  • Secondary Level: The second level of the hierarchy.
    • Parent Family: Functional Location
    • Relationship: Functional Location Has Equipment
    • Child Family: Equipment
    • Display Field: ENTY_ID
    • Taxonomy Category: Taxonomy Category
    • Taxonomy Class: Taxonomy Class
    • Taxonomy Type: Taxonomy Type
Important: Equipment or functional location with multiple parent functional location is not supported in Asset Hierarchy.

To find the duplicate keys, run the below query in GE Digital APM:

SELECT MV_AST_HRCY_DUP.parent_enty_key
, PAR_FMLY.FMLY_CAPTION_TX "PARENT_FMLY"
, MV_AST_HRCY_DUP.enty_key "CHILD_ENTY_KEY"
, CHILD_FMLY.FMLY_CAPTION_TX "CHILD_FMLY"
, MV_AST_HRCY_DUP.enty_id "CHILD_ENTY_ID"
, MV_AST_HRCY_DUP.the_level
, MV_AST_HRCY_DUP.path
FROM MIV_MI_AST_HRCY_MV_DUP MV_AST_HRCY_DUP
 JOIN MI_FAMILIES PAR_FMLY ON PAR_FMLY.FMLY_KEY = MV_AST_HRCY_DUP.parent_fmly_key
 JOIN MI_FAMILIES CHILD_FMLY ON CHILD_FMLY.FMLY_KEY = MV_AST_HRCY_DUP.fmly_key
ORDER BY MV_AST_HRCY_DUP.enty_key Asc

Access the Asset Hierarchy Configuration Page

Procedure

Access the Operations Manager page, and then select Asset Hierarchy Configuration.
The Asset Hierarchy Configuration page appears, displaying the Asset Hierarchy configuration.

Modify the Asset Hierarchy Configuration

About This Task

Note: You only need to modify the Asset Hierarchy if you want to change the baseline configuration.

Procedure

  1. Access the Asset Hierarchy Configuration page.
  2. For the section you want to use as the primary level of the hierarchy, select Root.
  3. In the Root section, select a value for the following as necessary:
    • Parent Family: The list of all entity families that exist in the database.
    • Relationship: The list of relationship families that exist in the database for the selected parent family.
    • Child Family: The list of entity families that exist in the database that are linked to the selected parent family through the selected relationship family.
    • Display Field: The list of fields from child families.
      Note: When using the Oracle Database, you cannot assign a Long Text field as the Display Field.
    • Taxonomy Category: A list of equipment categories (e.g., electrical is a category of equipment).
    • Taxonomy Class: A list of types of equipment classifications (e.g., capacitor is a class of electrical equipment).
    • Taxonomy Type: A list of types of equipment (e.g., series capacitor is a type of capacitor).

      Tip: In GE Digital APM, taxonomy refers to the classification systems used for identifying equipment. Equipment taxonomy is broken down into three sections: Category, Class, and Type.
  4. If you want to add another level, in the upper left corner of the page, select .
  5. To save, but not apply, the modifications, select .

    -or-

    To apply the modifications, select , and then select Rebuild.

    The modifications are applied, and are reflected on the Assets page.

Schedule an Asset Hierarchy Rebuild

You can schedule an Asset Hierarchy rebuild to occur on a one-time or recurring basis.

Procedure

  1. In the module navigation menu, select Admin > Operations Manager > Asset Hierarchy Configuration.
  2. In the page, select , then select the Enable Schedule check box, and then select Schedule.
  3. In the Edit Schedule window, select either One time or Recurrence.
  4. In Time Zone, select the time zone in which you want the first scheduled rebuild to occur.
  5. In Start, specify the date and time at which you want the first scheduled rebuild to occur.
  6. If you selected Recurrence, in the Every section, specify the frequency at which you want the rebuild to occur.
  7. If you selected Recurrence, in the End section, specify when the recurring rebuild should end.
  8. Select Save.

    The Edit Schedule window closes.

  9. In the Asset Hierarchy Configuration page, select Save.

Results

The Asset Hierarchy rebuild is scheduled.

About the Custom Asset Hierarchy Data Loader

The Custom Asset Hierarchy Data Loader is designed to load data into the Asset Hierarchy Entity family in GE Digital APM, and is also used to relate records in that family to other families in GE Digital APM based on the relationship definitions defined in Family Management. You can create Custom Asset Hierarchy Data Loader workbooks for the following purposes:

  • Entity Family Data: Used to load data or records.

    -and-

  • Relationship Family Data: Used to relate a record in an entity family to another record in different entity family.

The data loader workbooks used by the Custom Asset Hierarchy Data Loader are created using the metadata definitions configured in your GE Digital APM system. When the data is loaded, the Custom Asset Hierarchy Data Loader will trigger all of the associated field and family level rules, to ensure that the data is valid, but no further validation is done to the data. You should, however, verify that the intended data, records, or relationships are present in the GE Digital APM system after a data load has been completed.

About the Custom Asset Hierarchy Data Loader Requirements

Determine Which Families and Relationships to Populate

You can determine which families are available and how families are related in Family Management. To access Family Management:

  1. Log in to GE Digital APM.
  2. On the left navigation menu, select Admin, and the select Family Management.

Security Settings

The Security User performing the data load operation must be associated with either the MI Data Loader User or MI Data Loader Admin Security Role. Depending on the type of data that the Security User wants to load, the user may need to be associated with additional Security Roles to grant privileges to create the necessary records. To determine if additional Security Role association is needed to create a particular type of record, refer to the About Roles section of the GE Digital APM Administrative User Help documentation.

About the Custom Asset Hierarchy Data Loader Data Model

The following data model illustrates the records that the Custom Asset Hierarchy Data Loader supports. The Family records illustrated with a red border are customizable.

About the Custom Asset Hierarchy General Loading Strategy

This section describes any prerequisites to loading the data and the order in which the data will be loaded.

General Loading Strategy Workflow

  1. Determine what families and or relationships you want to populate using the Custom Asset Hierarchy Data Loader.
  2. Populate the Configuration worksheet.

This data loader may run on a schedule as part of the EAM data load service.

About the Custom Asset Hierarchy Data Loader Workbook Layout and Use

This section provides a high-level overview and explanation of how the data loader workbook is constructed.

In order to import data using the Custom Asset Hierarchy Data Loader, GE Digital APM provides an Excel workbook that must be used to perform the data load.

The following table lists the worksheets that are included in the MI_AH_Entity_Dataloader.xlsx workbook.

WorksheetDescription
ConfigurationThe Configuration worksheet is needed to describe the type of data that you will be loading and how that data should be handled during the data load.
AHEntityWhere you specify the actual Asset Hierarchy entities that you want to load.
LinkAHEntitytoEntityWhere you can connect an Asset Hierarchy entity to another Asset Hierarchy entity.
LinkAHEntitytoFLWhere you can connect an Asset Hierarchy entity to a Functional Location, Equipment, or some other asset concept defined by the Family Management settings.

Each worksheet in the Custom Asset Hierarchy Data Loader workbook contains field values that can be mapped to the appropriate GE Digital APM family/field.

About Populating Site Reference Data

The Custom Asset Hierarchy Data Loader can be used to populate the Site Reference on Equipment and Functional Location records in GE Digital APM. The Custom Asset Hierarchy Data Loader populates the ENTY_KEY system field and the MI_SITE_KEY system field associated with the Site Reference value to be populated. On asset records, the Site Reference is stored in the MI_SITE_KEY field, a system field in GE Digital APM. The Custom Asset Hierarchy Data Loader uses the Site Name (MI_SITE_NAME) to translate the value to the corresponding Site Key and populate the MI_SITE_KEY field; therefore, you do not need to know the key to be able to populate the site reference. This functionality is important because this value can change from one database to another.

Steps: Populate Site Reference Using the Site Name

  1. On the data worksheet, add a column that contains MI_SITE_NAME in the column name.

    For example, if you are working with a relationship, where a distinction needs to be made regarding which family is associated with each column, then the column name will be prefaced with the Family ID. The column name might take the form ‘MI_EQUIP000|MI_SITE_NAME’, where MI_EQUIP000 is the Family ID.

  2. Enter the site name to designate the site by which the asset record, once loaded into GE Digital APM, will be filtered.
  3. Continue populating the source workbook, and then run the data loader.

    The site reference value will filter the equipment records as determined in the source workbook.

About the Custom Asset Hierarchy Data Loader Load Verification

After loading data, you must perform the following steps in GE Digital APM to ensure the integrity and accuracy of the data imported from the data loader workbook:

  • Review the details of the import job. These details will indicate any errors that occurred during the data load. The log helps you identify any records that are not loaded.
  • Run a query on the relevant family to ensure that the records have been created and populated as expected.
  • Verify the imported records in Asset Hierarchy to ensure that the relationships between families have been created.
  • Verify that the assets in a Functional Location of the Custom Asset Hierarchy Data Loader exist.

    To view the assets, perform the following steps:

    1. Log in to GE Digital APM.
    2. On the top navigation bar, select .

      The Assets page appears.

    3. Select a Functional Location of Custom Asset Hierarchy Data Loader.