Converting Builder Output to cBase Output

When converting older VI scripts to use the Spectre engine, you can convert an existing Builder output object to a cBase output object.

To convert a Builder output object to a cBase output object:

  1. Right-click the Builder output object and click ClosedConvert to cBase output.

    VI Convert Builder Object to cBase Object

  2. Inspect the Model Structure tab of the cBase output object to confirm that the conversion went as expected.

NOTE:

  • If the existing Builder output object has aliases set for columns, an ClosedAlias process object is inserted prior to the cBase output object, preserving the aliases.

    VI Convert Builder with aliases to cBase

  • If the existing Builder output object has the Squash attribute set to true, a ClosedSquash process object is inserted prior to the cBase output object.

  • Dimensions defined in the Builder object become dimensions in the Squash object

  • Summaries defined in the Builder object become summaries in the Squash object

  • Info Fields in the Builder object are marked as other columns in the Squash object

    VI Convert Builder with Squash to cBase

  • Because Spectre is a typed language, be sure to designate the column types. For example, YearMonth values are designated as period-type columns instead of strings. Similarly, designate your date columns as date-type columns instead of strings or integers in the cBase output.
  • The cBase output object is more of a conversion tool than a long term solution. For robust support of the Spectre engine and cBases, use Spectre Build scripts. See Production's Build cBase Process Node and Creating cBases with Spectre Build Scripts.