Aspen Report Writer for Aspen PIMS

Learn how to build reports that display data from PIMS, Aspen Petroleum Scheduler and Aspen Multi-Blend Optimizer.

Audience:

Participants will typically know how to use Aspen PIMS and wish to create a customer reports based on PIMS result.

Training Details

  • Course Id:

    RPA153

  • Duration:

    1 day(s)

  • CEUs Awarded:

    0.7

  • Level:

    Introductory

Benefits

  • Understand how to setup Report Writer
  • Build Report Writer templates to generate the customer reports in Excel format

Approach

  • Class lectures describe the Report Writer functionalities
  • Discussion and demonstrations to review the different types of functions
  • Class problems are designed to familiarize the student with the features of Aspen Report Writer. Time is allotted to allow the student to explore these features

Pre-requisites

Current PIMS User

Agenda

Overview of Aspen Report Writer
  • Discuss the features and capabilities of Aspen Report Writer
  • Review the installation requirements
  • Discuss the PIMS database considerations
  • Identify and explain the different modes of operation
  • Workshop: Setup required database output settings

Template Review
  • Discuss the template execution mode
  • Demonstrate how to execute a template
  • Use Insert Function Wizard
  • Workshop: Understand the Retrieved Data Structure

Data Function
  • Identify and explain the various data functions
  • Database functions
  • Special data set functions
  • PIMS data set functions
  • APS data set functions
  • MBO data set functions
  • Discuss best practices for data functions
  • Workshop: Review the structure of a Sample Template
  • Workshop: Exercise the Data functions using different data sets

Data Placement Functions and Templates
  • Identify and explain data placement functions
  • Review data placement functions best practices
  • Discuss how to used the ATGArray Function
  • Demonstrate the steps for template creation
  • Workshop: Review a Capacity Report Sample template
  • Workshop: Create a sales report template
  • Workshop: Exercise the data placement functions

Enhanced Reporting
  • Discuss enhanced reporting with VBA Macros
  • Review the template execution order
  • Discuss how to transfer templates between computers
  • Identify and explain the pros and cons of the pivot function
  • Workshop: Review a sample template with pivot functions
  • Discuss formatting function and other best practices
  • Workshop: Create a purchase report using pivot functions
  • Workshop: Review of common formatting issues and design tips (optional - time permitting) 

Register for a Class

Date Class Type Location Price Language
Date(s): 07/29/2024 - 07/29/2024 Type: Public Virtual Location: Reading, UK Price: (USD) 1000.00 Language: English Register
Date(s): 11/4/2024 - 11/4/2024 Type: Public Virtual Location: Virtual-EMEA Price: (USD) 1000.00 Language: English Register
Date(s): 07/29/2024 - 07/29/2024 Type: Public Classroom Location: C2, Reading International Business Park, Basingstoke Road
Reading , United Kingdom RG2 6DT 		Price: (USD) 1000.00 Language: English Register
Date(s): 11/4/2024 - 11/4/2024 Type: Public Classroom Location: C2, Reading International Business Park, Basingstoke Road
Reading , United Kingdom RG2 6DT 		Price: (USD) 1000.00 Language: English Register
Date(s): 07/29/2024 - 08/2/2024 Type: Public Virtual Location: Virtual-Americas Price: (USD) 4500.00 Language: English Register
Date(s): 10/28/2024 - 11/1/2024 Type: Public Virtual Location: Virtual-Americas Price: (USD) 4500.00 Language: English Register
Date(s): 07/29/2024 - 08/2/2024 Type: Public Classroom Location: 2500 Citywest Blvd, Suite 1600
Houston , Texas USA 77042 		Price: (USD) 4500.00 Language: English Register
Date(s): 10/28/2024 - 11/1/2024 Type: Public Classroom Location: 2500 Citywest Blvd, Suite 1600
Houston , Texas USA 77042 		Price: (USD) 4500.00 Language: English Register

Aspen Technology, Inc. awards Continuing Education Units (CEUs) for training classes conducted by our organization. One CEU is granted for every 10 hours of class participation.