Show TOC

Background documentationPIC Analysis Query Details

 

You use this query to retrieve aggregated data from the KPI objects that are linked to the tags of Plant Information Catalog and from production events. The dimensions of the KPI object are also mapped when you map the KPI object to the tag.

Example Example

Suppose energy consumption information such as electricity, water and so on are stored in KPI objects. And, these objects are mapped to PIC nodes. You use this query to analyze energy consumption for the mapped PIC nodes.

End of the example.

This screen is available for the mode PICAnalysis.

Note Note

PIC Analysis Query supports only base KPIs.

End of the note.

Prerequisites

You have:

  • Defined Plant Information Catalog

  • Created KPI Objects

  • Mapped tag nodes in Plant Information Catalog to KPI objects

Features

You can analyze the data stored in KPI objects with reference to its relationship with Plant Information Catalog. You can define conditions to retrieve data:

  • General

    You select a tag specific category and do the following:

    • Select one or more tag-specific categories for which aggregation is required.

    • Create an alias for the selected tag category.

    • You can select a unit of measure for the tag specific category, if required. If you set to default, the query displays the unit of measure defined for the underlying KPI object. If you change the default unit of measurement, the query result displays the values in the specified unit of measurement. If there are multiple KPIs with different UoMs, then the query displays all results with the UoM of the first specified KPI. In other words, the query converts values of all subsequent KPIs to the UoM of the specified KPI. An error occurs if a converter method between the UoMs of the first and subsequent KPIs does not exist. For details to add a converter method, see Unit Converter.

    • You can select a category that already exists in the panel on the right. Add a plus sign, a minus sign, a multiplication sign, or a division sign, followed by a number or a category. Choose Add Row. The row added will be displayed in the panel.

    • Specify whether data drilling stops at the intermediate tags.

      Example Example

      A subtree in the PIC tree is defined as this:

      • Line 1 group

        • Electric Meter tag

        • Equipment 1 group

          • Electric Meter 1 tag

        • Equipment 2 group

          • Electric Meter 2 tag

        • Equipment 3 group

      The Electric Meter tag is an intermediate tag because its sibling groups contain child tags that can also be used for data aggregation. If you select the Intermediate checkbox, data from the KPI object mapped to the Electric Meter tag is used; If you do not select the checkbox, data from the KPI object mapped to the Electric Meter 1 and Electric Meter 2 tags is used.

      End of the example.

    • Specify the data aggregation mode and time granularity for analysis.

    • Specify whether to display additional time dimensions. The query results displays additional time dimensions such as year, month, quarter, week, hour, and so on depending on the selected granularity.

    • [Optional] Select a production event for analysis.

  • Node Selection

    Here, you can select group nodes from PIC using one of the following way:

    • Selecting any group specific category

    • Choosing property that is available from the selected group specific category

    • Selecting any group from the Plant Information Catalog hierarchy

  • Analysis Scope

    After selecting a node from Node Selection tab, you can further restrict the analysis scope by providing an expression using PIC node properties.

  • Group By

    You display the query results in groups according to selected properties.

Activities

To create a catalog query, do the following:

  1. Follow steps 1-3 from the Activities section of Catalog Query.

  2. From the Template Categories tab, choose PIC Analysis Query Details.

  3. On the General tab, do the following:

    1. Choose a category from Available Tag Specific Category column and move to Selected Tag Specific Category tab.

    2. Enter an alias, select a unit of measure, and specify whether or not data drilling stops at intermediate tags. (Optional)

    3. Select a mode from Aggregation Mode.

    4. Choose granularity from the drop-down list.

      Note Note

      To use a production event data source, the granularity of the PIC analysis query report must be hourly, daily, weekly, monthly, yearly, or noun. Minutes granularity or quarterly granularity is not supported.

      End of the note.

    5. Select Additional Time Dimensions checkbox to display the calendar year, month, and day. (Optional)

    6. Select a production event.

  4. Do one or more of the following in the Node Selection tab:

    • Choose a category from Available Group Specific Category column and move to Selected Group Specific Category column.

      The Available Properties for the Selected Category displays only the tags that are marked for analysis.

    • Choose one or more properties from the Available Properties column and move to Property Expression.

      The available properties depend on the selected category. You can specify a mathematical expression.

    • Select a group from Plant Information Catalog Tree column and move to Selected Node.

  5. In the Analysis Scope tab, create expressions using properties.

    You can create one expression using properties linked to group-specific categories and another expression using properties linked to the selected production event. Thus energy consumption data and production data can both be filtered.

  6. In the Group By tab, do the following:

    1. Choose a category from Available Category for Groups or choose to group by the properties linked to the selected production event.

    2. Select and move properties from the Available Properties pane to the Selected Properties pane. Choose Move Up and Move Down to reorder the properties.

More Information

Production Events