Aspen Report Writer for Aspen PIMS

Course Id:  RPA153   |   Duration:  1.00 day(s)   |   CEUs Awarded:  0.7   |   Level:  Introductory


Course Objective

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

Course Overview

  • Understand the Aspen Report Writer functionalities and the retrieved data structure
  • Examine the Report Writer setup requirements
  • Explore the use of different types of Report Writer functions

Benefits

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

Audience

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

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

Prerequisites

Current PIMS User

Class Schedule

Class Agenda

RPA153: Aspen Report Writer for Aspen PIMS

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) 

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.