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 Creating a cPlan

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/distributor.cplan 
Working directory: /cplans
Command Line: /di/solution/diveline-2130/bin/spectre cplaninfo /cplans/distributor.cplan --project block4
spectre cplaninfo 7.0 (6)
Licensed to: InterReport, Dimensional Insight Inc.

project://block4/cplans/distributor.cplan:
1 other file referenced:
  project://block4/cbases/distributor.cbase
9 diveable fields:
  "Corporate Brand" (string)
  "Customer" (string)
  "Customer ID" (string)
  "Customer State" (string)
  "Customer Zip" (integer)
  "Invoice Date" (date)
  "Net Sales" (fixed100)
  "Resp Team" (string)
  "Resp Territory" (string)
0 calc sets:
31 calcs:
  "Net Sales MTD TY Diff" (fixed100): calc("Net Sales MTD") - calc("Net Sales MTD LY")
  "Net Sales MTD" (fixed100): filter(calc("Net Sales"), ts_month_to_date(value("Invoice Date"), date("2013/04/15")))
  "Cases MTD TY % Diff" (double): pct_var(calc("Cases MTD"), calc("Cases MTD LY"))
  "Cases MTD TY Diff" (double): calc("Cases MTD") - calc("Cases MTD LY")
  "Cases MTD LY" (double): filter(calc("Cases"), ts_month_to_date(value("Invoice Date"), ts_offset("year", -1, value("Invoice Date"), date("2013/04/15"))))
  "Cases MTD" (double): filter(calc("Cases"), ts_month_to_date(value("Invoice Date"), date("2013/04/15")))
  "Net Sales YTD TY % Diff" (double): pct_var(calc("Net Sales YTD"), calc("Net Sales YTD LY"))
  "Depletion Allowance" (double): sum(value("Depletion Allowance"))
  "Resp Team Count" (integer): dimcount("Resp Team")
  "Net Sales MTD TY % Diff" (double): pct_var(calc("Net Sales MTD"), calc("Net Sales MTD LY"))
  "Net Sales" (fixed100): sum(value("Net Sales"))
  "Invoice Date" (date): info(value("Invoice Date"))
  "Cases YTD" (double): filter(calc("Cases"), ts_year_to_date(value("Invoice Date"), date("2013/04/15")))
  "Net Sales YTD LY" (fixed100): filter(calc("Net Sales"), ts_year_to_date(value("Invoice Date"), ts_offset("year", -1, value("Invoice Date"), date("2013/04/15"))))
  "Corporate Brand" (string): info(value("Corporate Brand"))
  "Resp Team" (string): info(value("Resp Team"))
  "Customer ID" (string): info(value("Customer ID"))
  "Net Sales MTD LY" (fixed100): filter(calc("Net Sales"), ts_month_to_date(value("Invoice Date"), ts_offset("year", -1, value("Invoice Date"), date("2013/04/15"))))
  "Cases" (double): sum(value("Cases"))
  "Resp Territory Count" (integer): dimcount("Resp Territory")
  "Customer State" (string): info(value("Customer State"))
  "Customer Zip" (integer): sum(value("Customer Zip"))
  "Net Sales YTD" (fixed100): filter(calc("Net Sales"), ts_year_to_date(value("Invoice Date"), date("2013/04/15")))
  "Customer" (string): info(value("Customer"))
  "Resp Territory" (string): info(value("Resp Territory"))
  "Cases YTD LY" (double): filter(calc("Cases"), ts_year_to_date(value("Invoice Date"), ts_offset("year", -1, value("Invoice Date"), date("2013/04/15"))))
  "Gross Profit" (double): calc("Net Sales") - calc("Cost") - calc("Depletion Allowance")
  "Cases YTD TY Diff" (double): calc("Cases YTD") - calc("Cases YTD LY")
  "Cost" (double): sum(value("Cost"))
  "Cases YTD TY % Diff" (double): pct_var(calc("Cases YTD"), calc("Cases YTD LY"))
  "Net Sales YTD TY Diff" (fixed100): calc("Net Sales YTD") - calc("Net Sales YTD LY")