Creating the Graph

How to:

Begin by creating a procedure that contains a graph. Later, you will add this graph to a frame in the HTML file and drill down to it from a report that you will soon create.

Top of page

Procedure: How to Create the Graph
  1. Right-click the Procedures folder under the Century project.
  2. Select New, then select Procedure from the context menu.

    The Add Procedure dialog box opens.

  3. Type STORSAL in the File name text box and verify that Procedure Files (*.fex) is selected from the Files of type drop-down menu.
  4. From the Create with drop-down menu, select Procedure Viewer.
  5. Click Create.

    The Procedure viewer window opens.

  6. Click the diamond to the right of the default Comment component and select Graph from the component connector toolbar.
  7. Select the CENTORD Master File and click Ok.

    InfoAssist opens.

  8. Select the Format tab and click Other from the Chart group.

    The Other Chart Types window opens.

  9. Select Lines from the Chart Types group.

    InfoAssist refreshes showing a sample absolute line chart.

  10. From the Data panel, double-click Line, Total to add it to Measure (Sum) in the Query panel.
  11. From the Data panel, double-click Store, Name to add it to X-Axis in the Query panel.
  12. Select Product, Name in the Data panel, then drag the field into the Multi-graph heading in the Query panel.
  13. Click Save.

Top of page

Procedure: How to Create a Heading for the Graph

Adding a heading to your graph provides important information to describe the data you want to display. You can add headings and footings for your graph by clicking the Heading & Footing button, located in the Home menu. In this tutorial, you will add a heading.

  1. Click the Home tab, if it is not already selected.
  2. Click the Header & Footer button.

    The Header & Footer dialog box opens. Page Header is selected by default

  3. Type Sales of and leave a space.
  4. Drag PRODNAME from the Field list into the Header & Footer dialog box.

    <CENTORD.INVSEG.PRODNAME is added to the Heading.

  5. Place the cursor after <PRODNAME and leave a space.
  6. Type for Each Store.

    Your header will look like the following: Sales of <PRODNAME for Each Store

  7. Click Apply then OK to apply and close the Heading dialog box.

Top of page

Procedure: How to Limit Graphed Data

You can limit the data displayed in a report or graph by adding a filter. Here you will create a statement that limits the data in the graph to a certain product. You will enter this criteria as a parameter, and use the parameter later in the tutorial when you set the drill-down option for the report.

  1. Click the Data tab.
  2. Click the Advanced button from the Filter group to view the Advanced Filter expression builder.

    The following image shows the Advanced Filter expression builder.

    Filter expression builder

  3. In the Advanced Filter expression builder:
    • Click the New Filter button.
    • From the Field drop-down list, select Product, Name.
    • Select Equal to from the Logical Relation drop-down list. Equal to is the default value.
    • From the Value drop-down change the Type to Parameter.
    • Change the Parameter to Static.
    • Type PNAME in the Name field.
    • Type Product Description in the Description field.
    • Select the Get Values button and click All.

      The box beneath the Get Values button is populated by data from the Product, Name field.

    • Select all values in the now populated box and move them to the Multiple Values box by clicking .
    • Check the Select multiple values at run-time box.
  4. Click OK to save your filter.