App Engine 101 People Soft Application Engine Basics

App Engine 101 People. Soft Application Engine Basics for Building a Data Mart

Agenda App Engine – What it’s for Read an App Engine Program Create an App Engine Program Configure a Run Control to run an App Engine Techniques – (Data Modeling 101? ) © 2007 Bearing. Point, Inc. HCM COIN 2

What’s App Engine For Processing Can be a Program performs a process. Example, puts away inventory in a batch process based on staged receiving Data Extract, Transform, Load Source and target data, performs aggregations, transformations, conforms data to an analyze-able model DML Database Operations, for example, dropping tables and creating indexes © 2007 Bearing. Point, Inc. HCM COIN 3

Compare and Contrast SQR to App Engine SQR App Engine 3 rd Party Proprietary, part of People. Tools Doesn’t use People. Tools macros Uses People. Tools macros Used extensively in early versions of People. Soft decided around version 7. 5 to stop using SQR and use App Engine Strength is handling of ETL, Processing of Procedures, DML Lots of programmers Less visual in last People. Soft release (SQR 6. 0)* Good reporting capabilities Scarcity of programmers Steps are somewhat visual in Application Designer Create a reporting table and use another tool * Hyperion is up to release 9 in SQR with many new features © 2007 Bearing. Point, Inc. HCM COIN 4

Read an App Engine Program © 2007 Bearing. Point, Inc. HCM COIN 5

Read an App Engine Program (cont) © 2007 Bearing. Point, Inc. HCM COIN 6

Equivalent in SQR Nested DO © 2007 Bearing. Point, Inc. HCM COIN 7

Features in App Engine Steps are numbered Commit after statement Can abort on error or continue Can click on or off the Active box to not use that step Can abort or continue if no rows Can print out the whole app engine Can include all macros available in People. Code Step can be a People. Code step, capable of processes Many other features © 2007 Bearing. Point, Inc. HCM COIN 8

Create an App Engine Easiest way to Create an App Engine: Take an existing App Engine, click File, Save as Rename App Engines can be put in Projects and imported from one database to another © 2007 Bearing. Point, Inc. HCM COIN 9

Configure a Run Control to Run an App Engine © 2007 Bearing. Point, Inc.

Technique for Building the Fact Only do a full load once a month (incremental on 15 th) Drop Indexes before massive INSERTs and then build indexes after Lookup Key - Projects that are: - Current Projects - Public Sector Create Narrow Tables based on the Lookup Key - Select Foreign keys to join in later steps - Select only data needed for this datamart Join PROJ_RES to VCHR_ACCTG for ATX, TLX Join PROJ_RES to EX_ACCTG for Subcont, ACT, EXP Effect a Triangulated Reconciliation of Cost, AP, EXP, Proj Resource, GL because we are tying out to the source of the GL, the ACCTG LINE tables. © 2007 Bearing. Point, Inc. HCM COIN 11

Q&A Steven Stein, Senior Consultant Bearing. Point 100 Matsonford Rd One Radnor Corporate Ctr Radnor, PA 19087 Tel: +1. 610. 263. 7160 Cell: +1. 267. 872. 9838 E-mail: Steven. Stein@Bearing. Point. com © 2007 Bearing. Point, Inc. HCM COIN 12