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.
To view the output of a cPlan:
- In Workbench Explorer, right-click the cPlan, and select Run > Show cPlan Info.
- 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: