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

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.