What's New in Workbench 7.1?
New for DiveTab
Starting with DiveTab 7.1(15), you can create a stamp page for DiveTab that allows users to add stamps for specific measures. Requires a Measure Factory license.
New for Spectre
The Spectre graphical editor for building cBases has been recreated with a flow panel and properties panel similar to those found in Visual Integrator and Production. A Spectre build can include joins and rotates similar to the VI functionality.
You can dive on a date column as if it were a period column by describing the specific type within the dive script.
Recent and rolling time series can include future periods.
See Time Series Ranges.
Functions that accept dates and periods as arguments now accept datetimes too.
The conversion function fixed100() converts a numeric value to a fixed100, truncating precision if necessary.
The date and time function format_datetime() gives you presentation options for datetime data.
The predicate function bit_get() tests arbitrary bits in an integer.
The function on_previous_row() enables detail-level cumulative calculations.
The dimension function dimsum() adds functionality similar to dimmin() and dimmax().
You may also want to note two math functions added late to version 7.0:
The intercept() function calculates the point at which a line will intersect the y-axis by using existing x-values and y-values.
The slope() function computes the slope of the linear regression line through the specified data points.
Combining cBases built with different locales can be done in Build scripts starting with version 7.1.
The internal structure of cBases for 7.1 has changed. You must use version 7.0(55) or later to open 7.1 cBases using version 7.0 tools.
The Dimensional Insight ODBC Driver (DI-ODBC) is an ODBC driver which can retrieve data from DiveLine. When installed, ODBC-capable applications can use the driver to make queries against a DiveLine server, as specified by a connection string or a configured DSN. The driver can be used to query a cBase, cPlan, or dive script. Queries are made using SQL.
See DI-ODBC Overview.
A duration tag can be used to format integer columns as h:mm:ss.
A zone tag can be used with datetime input to store time data in your cBase in GMT.
A tunnel-input tag can be used with Spectre Build.
Spectre Build supports several new tags: file-list, prefix, and modified-column.
A hash function, blake2(), has been added to Spectre.
Spectre Build can process data from list-input.
The Spectre Build Flow Editor has two tabs at the bottom. The first tab is for the node UI, and the second tab is for test run results, similar to VI.
In the Spectre Expression Editor, the auto completion for quotes and brackets is disabled by default.
A Spectre build can be configured to process dates prior to 1900 or after 2199 without warnings.
Spectre cPlans now support system and custom properties.
There are more ways to examine the property metadata defined for a cBase or cPlan.
The Build Flow Editor now includes a source column in data grids to help understand the data flow between nodes in a script.
The Spectre Build Flow Editor (7.1(19.1) includes VI-like context menu items in the Test results grid.
The Spectre dive command has a new --delimiter argument.
Spectre format strings now handle custom formatting for null and unknown values. This applies to all Spectre data types and can be used on the command line, in ProDiver, in DivePort Chart, Indicator, Measures, and Marker portlets, and in DIAL.
Spectre build scripts now support the expand build tag.
New for Workbench
The Workbench Connection Manager has new features. You have the option to configure quick connection buttons with various icons, to add comments, and to examine Last Connected information.
See Connections Overview.
Workbench allows you to switch between a script's graphical editor and text editor views in the same tab. Each different view of the file is available with a single click. Edits made in one view appear directly in the other view when you switch views.
See View Switcher.
Users can select a different font for use on text editor tabs. This applies to text files as well as script files.
There is a new sub-tab within Server Settings where you can view all running DI processes on the server via a new Process Manager.
See Processes Tab.
Project metadata includes the creator and creation time.
A tooltip displays the project name for an open script—useful when you have two scripts in different projects with the same name open in Workbench.
Workbench has a table editor where you can add and delete rows and filter data. Supported delimiters now include the pipe character.
See Using Table Editor.
The online Help system now includes basic How To videos for Workbench.
There is a new context menu item for the Workbench Explorer pane.
You can now open a script from the Production Results view.
Workbench 7.1(14) expands the Version Control functionality to include project cloning and pushing/pulling to a remote Git server. This supports DTAP style project management.
Users can have path settings for both non-Unicode and Unicode ProDiver executables.
You can export the Workbench connections from the Connection Manager to an encrypted file.
Starting in Workbench 7.1(15) you can run DIAL in server mode from Workbench and Production.
Workbench 7.1(21) refines Git functionality to make integration with new and existing Workbench projects easier.
The Project Contents display for a very large project can consume significant resources from both the client and server machines. To prevent such an occurrence, controls have been added.
Opening a script on the Start Page opens the project if it is not already open.
A new sub-conditional has been added for Production scripts. Normally, Trigger file sub-conditions are met if a file exists (and optionally, have certain text that appears in them). This feature adds a check box to cause the sub-condition to be met if a file doesn't exist. Using this sub-condition allows a Production script to wait for a file to exist before proceeding.
Production has a new process node.
The Server Settings email test now allows you to specify the From address.
The search in VI now includes object names, not just properties.
More Production work files (.table-index) have been identified and moved to a project folder for better housekeeping.
You can reset the language for display in Workbench, independent of Windows default settings.
The Production End Node has expanded options for reporting the branch success state.
The Workbench Git GUI allows checkout operations.
The Workbench Git GUI allows conflict resolution operations.
New for Measure Factory
There is a graphical tool for editing rules, measures, and data sets in a Factory configuration file.
You can create template files for DivePort stamps with assistance from the grammar-aware text editor.
A new top-level tag in a factory configuration file allows parameters to be passed to a factory at time of query, for example, from a QuickView in DivePort.
The view tag has been deprecated in favor of the scope tag.
The threshold tag has been deprecated in favor of the aux-measure tag.
Assisted Analytics adds a new mode to the DivePort Analysis Portlet, which performs automatic dives and summarizes the results, to give users ideas about where to go next in their data analysis. Settings are made in the factory configuration.