Using Your Extension in a WebFOCUS Request

If you have installed and configured your extension as described, your extension will be available for use in the WebFOCUS tools as a chart type in the Other format category under HTML5 Extension, as shown in the following image.

The attribute categories you defined in the dataBuckets object of your extension are available in the query pane.

In the FOCEXEC:

• The LOOKGRAPH value is EXTENSION.
• The actual extension to use is identified in the chartType property of the *GRAPH_JS block in the StyleSheet. For example:

  *GRAPH_JS
  chartType: "com.ibi.simple_bar",
  }

• Each custom attribute category name is prepended with a greater-than character (>). For example:

  TYPE=DATA, COLUMN=N1, BUCKET= >labels, $
  TYPE=DATA, COLUMN=N2, BUCKET= >value, $
  TYPE=DATA, COLUMN=N3, BUCKET= >value, $
  TYPE=DATA, COLUMN=N4, BUCKET= >value, $
  TYPE=DATA, COLUMN=N5, BUCKET= >value, $

The following is a sample request using the Simple Bar extension.

GRAPH FILE WF_RETAIL_LITE
SUM COGS_US
GROSS_PROFIT_US
REVENUE_US
DISCOUNT_US
BY PRODUCT_CATEGORY
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET LOOKGRAPH EXTENSION
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENWarm.sty,$
TYPE=DATA, COLUMN=PRODUCT_CATEGORY, BUCKET= >labels, $
TYPE=DATA, COLUMN=COGS_US, BUCKET= >value, $
TYPE=DATA, COLUMN=GROSS_PROFIT_US, BUCKET= >value, $
TYPE=DATA, COLUMN=REVENUE_US, BUCKET= >value, $
TYPE=DATA, COLUMN=DISCOUNT_US, BUCKET= >value, $
*GRAPH_JS
chartType: "com.ibi.simple_bar",
*END
ENDSTYLE
END

Run the chart. The output is shown in the following image.