What's New in Workbench?

New in Workbench 8.0

Analysis tables are available in Workbench 8.0, and enable users to view and compare dimensions and their associated summaries. Different skins can be applied to appear as different interface data tables, depending on the user's needs or preferences. This feature includes the ability to expand columns, switch dimensions, and more.

For more information about analysis tables, see Analysis Tables Overview.

The version control interface has changed. Uncommitted changes in a project with version control are now in bold with icons signifying whether the file is new or has been changed. This can be turned off by going to Preferences > Version Control and unchecking Show Version Control changes in Explorer.

For more information about this change, see File Status with Version Control

New for Spectre

The Spectre Flow scripting language has been released in Spectre 8.0. This scripting language combines the speed and functionality of Spectre with the user interface of Visual Integrator.

For information about the Spectre Flow language, see About Spectre Flow.

For information about the Spectre Flow editor interface, see Spectre Flow Editor Interface

Spectre Flow has multiple different way to set data sources as an input. Spectre Flow Input Nodes are:

Object Description
cBase Accesses data in a DI cBase. See Spectre Flow cBase Input Object.
cPlan Accesses data from a DI cPlan. See Spectre Flow cPlan Input Object.
Datagen Provides data generation capability. See Spectre Flow Datagen Input Object.
Directory Processes file system directories as input data. See Spectre Flow Directory Input Object.
Dive Accesses data from a Spectre Dive. See Spectre Flow Dive Input Object.
Excel Accesses data from a .xls or .xlsx file. See Spectre Flow Excel Input Object.
Flow Processes data from the output of another Spectre Flow script. See Spectre Flow Flow Input Object.
JSON Processes data from a .json file. See Spectre Flow JSON Input Object
List Provides a method of defining an input table. See Spectre Flow List Input Object.
ODBC Defines data to be accessed from an ODBC-accessible database. See Spectre Flow ODBC Input Object.
Text Accepts input from a set of external text files. See Spectre Flow Text Input Object.
Tunnel Processes data from the output of an Integrator tunnel script. See Spectre Flow Tunnel Input Object.

Spectre Flow has multiple ways to process and transform data before sending it to output objects. Spectre Flow Process Nodes are:

Object Description
Alias Renames columns. See Spectre Flow Alias Process Object.
Break Identifies break levels in the input flow. See Spectre Flow Break Process Object.
Calc Performs various calculations on data. See Spectre Flow Calc Process Object.
Chop Chops input into tokens. See Spectre Flow Chop Process Object.
Concat Concatenates multiple input flows. See Spectre Flow Concat Process Object.
Expand Expands a single row into multiple rows. See Spectre Flow Expand Process Object.
Filter Filters rows in a data flow that match specified criteria. See Spectre Flow Filter Process Object.
Lookup Combines two input flows to form a single output flow. See Spectre Flow Lookup Process Object.
Metadata Creates a table containing metadata information for a source input. See Spectre Flow Metadata Process Object.
Merge Combines multiple input flows with the same structure. See Spectre Flow Merge Process Object.
Rotate Rotates information from multiple columns into multiple rows. See Spectre Flow Rotate Process Object.
Sort Sorts the data flow based on a set of columns, and changes the order in which the data appears in subsequent objects later in the data flow. See Spectre Flow Sort Process Object.
Squash Combines rows that are identical for a set of dimension columns, and optionally summarizes number columns. See Spectre Flow Squash Process Object.
Unrotate Converts a single column into multiple columns. See Spectre Flow Unrotate Process Object.

Spectre Flow has multiple ways to output data into different file types. Spectre Flow Output Objects are:

Object Description
cBase Creates a DI cBase file. See Spectre Flow cBase Output Object.
Flow Allows the Flow script to be used as a data source for another process (a DivePort portlet or another Flow script, for example). See Spectre Flow Flow Output Object.
Text Creates a text file. See Spectre Flow Text Output Object.

For users who are accustomed to Visual Integrator, the following topic covers the differences between Spectre Flow and Visual Integrator:

Differences Between Spectre Flow and Visual Integrator

For users who are accustomed to Spectre Build, the following topic covers the differences between Spectre Flow and Spectre Build:

Differences Between Spectre Build and Spectre Flow