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:
For users who are accustomed to Spectre Build, the following topic covers the differences between Spectre Flow and Spectre Build: