CENTERVIEW TRAINING
ADVANCED MODELLING WORKBOOK
CenterView Version 6
10 February 2016
!worddav348d3085035cf3d99341a92e32d0d000.png|height=150,width=900!Table of contents
1 Merging data with enrichment, breaking out records and filtering output
1.1 Break out records with an Output Multiplier
1.2 Filter output to keep only large payments
2 Automating data collection
2.1 Reading daily files
2.2 Reading from external databases using Stream Set dates
2.3 Reading Sequenced Files
2.4 Use input multiplier to select records since last read
3 Reading all data from a input stream
4 Handling operational errors
4.1 Using try()
4.2 Using jumpTo()
4.3 Handling and reporting errors
4.4 Sending messages to the Console
5 Troubleshooting
5.1 Trouble shooting "Output attribute *** has evaluated to a set of 2 values rather than a single value..."
5.2 Trouble shooting Lookups
5.3 Trouble shooting Database Collectors
5.4 Trouble shooting Models with debug()
5.5 Trouble shooting large data sets with stop()
6 Mandatory pipes
7 Building a history
8 Building a history with a Self-Updating Stream
9 Enriching small data sets from very large data sets
9.1 Individual lookups into Streams
9.2 Individual lookups into external databases
9.3 Apply index to input stream
10 Enriching large data sets from very large data sets
10.1 Enrichment using Merge with Multiplier Pipe
10.2 Enrichment using Merge with Multiplier Pipe, with Execution Strategy
10.3 Enrichment using merge with multiplier pipe from external table
10.4 Enrichment using directed merge from external table
11 Making "near" matches
12 Calculate by Set, the cache() function
12.1 Create list of bills with group totals
12.2 Load records and give a record number to each
12.3 Create a list of bills with running totals (using cache())
13 Generating a file per team
14 Using Cache Extraction Filters
15 Extra exercises
15.1 Export / Import objects into a different instance
15.2 Techniques for creating test data
15.3 Use output filter instead of mandatory pipe
15.4 Use input multiplier to pass list to query on external database
15.5 Read excel spreadsheet with sub-headings
15.6 Re-work cache extraction filter as attribute expression
15.7 Apply VAT Rates with no end date