ENLYZE
🇬🇧 ENLYZE
🇩🇪 ENLYZE🇬🇧 ENLYZE
🇬🇧 ENLYZE
🇩🇪 ENLYZE🇬🇧 ENLYZE
  • Getting Started
    • Quickstart
  • Guides
    • Platform Configuration
    • Connecting Booking Data
  • PLATFORM
    • Integrations
      • Grafana
        • Structure of the ENLYZE data sources
        • Tutorials
          • First steps with Platform Grafana
          • Grafana Basics for Process Monitoring
          • OEE data with Infinity data source
          • Mapping UUIDs to Display Names with Infinity Data Source
      • Power BI
        • Installing the ENLYZE Power BI Integration
        • Structure of the ENLYZE Power BI Connector
        • Tutorials
          • Getting Started with the ENLYZE Power BI Connector
          • Querying Time Series Data from Machine Variables
          • Querying Machine Productivity Metrics
          • Mapping UUIDs to Display Names
          • Calculating Aggregated Timeseries Data
  • IT Security
    • IT Security
Powered by GitBook
On this page
  • Querying OEE Metrics for All Machines
  • Querying OEE Metrics for a Single Machine
  1. PLATFORM
  2. Integrations
  3. Power BI
  4. Tutorials

Querying Machine Productivity Metrics

PreviousQuerying Time Series Data from Machine VariablesNextMapping UUIDs to Display Names

Last updated 18 days ago

The ENLYZE Power BI Connector allows you to query aggregated data, such as OEE metrics per machine, at selectable resolutions and time intervals. The integration utilizes parameterized queries for this purpose.

Querying OEE Metrics for All Machines

  1. Navigate to Get Data > More... and select ENLYZE.

  2. Check the boxes for Machines and Machine Productivity Metrics.

  1. Click Transform Data to access the input form for the parameterized query.

  2. Choose an appropriate option for machines, set a start and end date, and specify the resolution.

  1. Click Invoke to retrieve the data.

Querying OEE Metrics for a Single Machine

To limit the amount of retrieved data, you can query OEE metrics for individual machines:

  1. First, load all your machines into a table by selecting Machines and clicking Load.

  1. Once the query completes, click Transform Data.

  1. Filter your selection and, in the productivity_metrics column, click Function to query the aggregated OEE metrics for the selected machine.

  2. You will then be prompted to enter a start and end date as well as a resolution.