Creating Customized Report Outputs

How to:

In addition to HTML, active report, active Flash, PDF, active PDF, Excel, and PowerPoint output formats, you can create the following custom report output formats.


Top of page

x
Procedure: How to Create OLAP Reports
  1. On the Format tab, in the Navigation group, click the Auto Drill & Analysis down arrow.

    The Auto Drill & Analysis menu opens. It contains the following options:

    • OLAP panel not accessible. (Default) Select this option to only display sorting options in the column titles. The OCP (OLAP ribbon) cannot be accessed from the title options.
    • OLAP panel accessible. Select this option to access the OLAP panel using the Auto Drill & Analysis button in the output of the report.

      Note: Using this option versus the hidden option allows the user to better distinguish the difference between the first and second options. The hidden option is available by accessing the Navigation dialog box.

    • Dimension filtering enabled. Select this option to display dimension filters at the top of the report. You customize the filter placement within the Navigation dialog box. You access the dialog box by clicking More options.
    • Dimensions grouped in tabs. Select this option to group dimension filters in tabs based on hierarchy within statements in the metadata.
    • More Options. Select this option to open the Auto Drill & Analysis dialog box, as shown in the following image.

      Auto Drill and Analysis dialog box

      In addition to the options discussed previously, the Auto Drill & Analysis dialog box allows the following additional configuration and customization options for OLAP output:

      • Hide access to the OLAP panel. Select this option to hide access to the OLAP panel.
      • Dimension filtering enabled. This option provides a secondary positioning option allowing placement of the filters on the Top (default) or Bottom of the report.

        Note: If the Dimension filtering enabled option is cleared at any time, the position option resets to Top.

      • Auto drill options. The auto drill options are:
        • Dimensions. Select this option to automatically drill down on dimensions in both reports and graphs.
        • Dimensions and Measures. (Default). Select this option to automatically drill down on dimensions in both reports and graphs and on measures in reports.
        • None. Select this option to disable automatic drill downs.
  2. Select an option.

    Selecting an option from the OLAP group, such as OLAP panel is accessible, generates output that invokes OLAP processing. The following image is an example of an OLAP report. The OLAP button below the report, when clicked, launches the OLAP ribbon.

    OLAP Report


Top of page

x
Procedure: How to Create Table of Contents Reports

Note: You cannot use the Table of Contents with the Accordion feature.

  1. Create a report.
  2. On the Format tab, in the Navigation group, click Table of Contents.

    A table of contents button appears in the top-left corner of the report output, as shown in the following image.

    Report With Table of Contents Button

  3. Double-click the button to display the Table of Contents menu, as shown in the following image. The Table of Contents menu enables you to select and view individual values of the first sort (By) field, one value at a time.

    Report With Table of Contents in Front of Report Output

    Drag the Table of Contents menu in any direction to view the report output, which appears behind the menu by default.

    Report With Table of Contents Button

    Select a sort field to view values for that field. In the following example, clicking NorthEast displays the corresponding report output.

    Report Table of Contents Sort Field Values

    You can also select options to view the entire report or remove the table of contents.


Top of page

x
Procedure: How to Freeze Column Titles in Reports

On the Format tab, in the Navigation group, click Freeze.

Column titles freeze (remain in view) when you scroll through pages of the report output.

The following image shows the scroll bar that appears when you freeze column titles.

Freeze Column Titles Report


Top of page

x
Procedure: How to Create Pages On Demand Reports

This procedure describes using the Pages on Demand feature to create an HTML report.

  1. Create a report.

    The default output is HTML.

  2. On the Format tab, in the Navigation group, click Pages on Demand.
  3. Run the report.

    The report opens in the WebFOCUS Viewer, as shown in the following image.

  4. Navigate through the report using the navigation options available on the WebFOCUS Viewer menu bar.

    The options are:

    • Go to a specific page
    • Retrieve all pages
    • Go to the first page
    • Go to the previous page
    • Go to the next page
    • Go to the last page
    • Perform case-sensitive and case-insensitive searches
    • Perform forward and backward searches
    • Access WebFOCUS Viewer Help
    • Close the WebFOCUS Viewer

Top of page

x
Procedure: How to Create Accordion Reports

Note: You cannot use the Table of Contents in conjunction with the Accordion feature.

  1. Create a report.

    The following image shows a chart before the accordion option is applied.

    Chart Before Accordion Option is Applied

  2. On the Format tab, in the Features group, click Accordion.

    Plus signs, shown in the following image, indicate that there are expandable views of data for each vertical sort field.

    Report With Expandable Views of Data

    You can manually expand your view to expose the data, as shown in the following image.

    Report With Data Expanded


Top of page

x
Procedure: How to Implement Stack Measures

On the Format tab, in the Features group, click Stack Measures.

All measures on the report are stacked.

The following image shows a report in Live Preview before the Stack Measures option is enabled.

Report Before Stack Measures Are Enabled

The following image shows a report in Live Preview after the Stack Measures option is enabled.

Report With Stack Measures


WebFOCUS