Using cPlan Info

You can view the output of a cPlan file in Workbench to ensure that you are getting the results that you expect. For information on creating a cPlan, see Defining Spectre cPlans.

To view the output of a cPlan:

  1. In Workbench Explorer, right-click the cPlan, and select Run > Show cPlan Info.
  2. Inspect the output in the Output Status Bar.

You can see the results of columns created by the cPlan. Return to the cPlan to make changes as needed.

Below is a sample output from the Show cPlan Info command:

Starting run: spectre cplaninfo /cplans/cals.cplan 
Working directory: /cplans
project://commodities/cplans/cals.cplan:
1 other file referenced:
  project://commodities/cbases/produce.cbase
12 diveable fields:
  "Claims" (fixed100)
  "Commission" (integer)
  "Commodity" (string)
  "Customer" (string)
  "GP" (integer)
  "Qty" (integer)
  "Sales" (integer)
  "Salesperson" (string)
  "Ship Date" (date)
  "Ship Month" (period)
  "Ship Year" (integer)
  "Supplier" (string)
0 calc sets:
17 calcs:
  "Average Sales" (double): average(value("Sales"))
  "Claims" (fixed100): sum(value("Claims"))
  "Commission" (integer): sum(value("Commission"))
  "Commodity" (string): info(value("Commodity"))
  "Customer" (string): info(value("Customer"))
  "GP" (integer): sum(value("GP"))
  "Max Sales" (integer): max(value("Sales"))
  "Min Sales" (integer): min(value("Sales"))
  "Number of Customers" (integer): dimcount(value("Customer"))
  "Qty" (integer): sum(value("Qty"))
  "Sales" (integer): sum(value("Sales"))
  "Salesperson" (string): info(value("Salesperson"))
  "Ship Date" (date): info(value("Ship Date"))
  "Ship Month" (period): info(value("Ship Month"))
  "Ship Year" (integer): info(value("Ship Year"))
  "Supplier" (string): info(value("Supplier"))
  "Ucount customer" (integer): ucount(value("Customer"))

See also: