CENTERVIEW TRAINING
MODELLING CONCEPTS WORKBOOK
CenterView Version 6
10 February 2016
!worddav348d3085035cf3d99341a92e32d0d000.png|height=150,width=900!Table of contents
1 Populate models with data
2 Linked views with multiple driving views
2.1 Linked views with multiple driving views
2.2 Passing a list from a driving view
3 Presentation options
3.1 Changes row colour
3.2 Grid column width
3.3 Record detail field sizing
3.4 Layout of record details form
3.5 Set field alias
3.6 Hover text for descriptions
3.7 Conditional formatting
4 Actions – updates, inserts and deletes
4.1 Create action to update records
4.1.1 Set a fixed value on records
4.1.2 Actions to request values from user
4.2 Create actions to insert new records
4.3 Create action to delete records
5 Refresh actions
6 Actions - drop-down menus, updating from lists, unique IDs and audit
6.1 Add several actions to a single button (creating drop-down menus)
6.2 Action to update field from a list
6.3 Actions to update a field using a sequence (creating unique IDs)
6.4 Adding audit information to updates
7 Actions – opening other dashboards, action validation
7.1 Action to open another dashboard – filtered for selected row
7.2 Validating actions
7.3 Add action to chose delivery slot
8 Actions to run tasks – using selected row values
9 Excel templates
10 Combining Data Sets
10.1 Reading in data sets from files
10.2 Load file data into CenterView
10.3 Combine data sets
10.4 Record source for each update
11 Picking latest sales update for each customer
11.1 Create an Aggregate Stream
11.2 Set up Grouping and Ordering on input pipe
11.3 Test your new Stream
12 Breaking out a record into multiple output records
12.1 Load reference data
12.2 Create Stream for full channel list
13 Reading additional tabs from Excel spreadsheets
14 Enriching data directly from database tables
15 Merging data sets directly from database tables
15.1 Filter unmatched rows
16 Filtering Stream Output
17 Merging data sets with enrichment
17.1 Merge address and customer category data
17.2 Enrich addresses with postcodes
18 Static Streams and static pipes
18.1 Create and use a static Stream
18.2 Create and use a static pipe
19 Show All Successors, Show All Predecessors, Show Models
19.1 Using Show All Successors and Show All Predecessors to add components to a model view
19.2 Using Show Models to list models which an object appears in
20 Rolling back Streams
20.1 Rollback several Streams at once
20.2 Rolling back (and re-running) from the Console
20.3 Rollback a single Stream Set (a run)
21 Copying complete models
22 Copying individual Model Objects
23 Copying/moving Stream data
23.1 Copying Stream data to a copy of a Stream
23.2 Copying Stream data to a modified copy of a Stream
23.3 Moving Stream data to a copy of a Stream
23.4 Moving Stream data to a modified copy of a Stream
24 Attribute scripting
24.1 Using switch() to apply multiple tests
24.2 Using forEach() to handle lists
25 Creating and using macros
25.1 Creating macros
25.2 Using Macros