P# Training
      Back to home
      1. Datagration Knowledge Base
      2. Customer Training
      3. P# Training

      P# Lesson 2: Yearly Production Rate

      Exercise 2

      Create a script that pulls the oil production rate in bbl/d on field level and the entire production history in a yearly time increment.

      Exercise 2 Solution

      Context "All Fields FromStartToEnd Yearly"

         Entity Set "All Fields"

         Scope "FromStartToEnd Yearly"

         Hierarchy "Well Hierarchy"

      End Context

      Entity Set "All Fields"

         EntitiesByType("Field")

      End Set

      Scope "FromStartToEnd Yearly"

         Between StartOf()

         And EndOf()

         Step Yearly

      End Scope

      Table "Production Data"

         Column "Oil Rate" in "bbl/d"

            "oil production rate" in "bbl/d"

         End Column

      End Table