How-to's


Personalizing Default Values for Filter Controls

You can personalize default values for filters in a page based on users or conditions. This feature uses the amper (&&) global variable to specify the default option for a filter control. For example, you can set the Region value for a user, using the && global variable, and link it to the filter control to show their region as the selected value.

Procedure: How to Personalize Default Values for Filter Controls

Customizing Your InfoSearch Index Location

InfoSearch provides you with the ability to customize the location where your index data is saved. Typically, you would customize this location when using a Docker container, so that the index data is stored outside of the container and you can prevent the loss of any data. This feature is enabled through your WebFOCUS Client application server that is configured with your WebFOCUS environment. The following procedure outlines how to configure your index location using Tomcat.

Procedure: How to Configure Your Index Location

Video: How to Run a Selected File From an HTML Page

Parameterized content is a great way to give users access to the information that is most relevant for them. Sometimes, however, you may want to make multiple different files available for selection, such as when they use different data sources, show different fields, or use different styling. You can do that by creating a control that lists procedures or HTML files, and then using the Run Procedures/HTML From Control request option.

 

Video: Pivoting Data


Data sources can contain repeating columns, or groups of columns. You can use the pivot option to transform these columns or groups of columns into rows.

From the Home Page, click the Data category in the Action Bar, and then click the Upload Data button.
From the Legacy Home Page, in the Resources tree, right-click a domain or folder, point to Upload, and then click Data.

Let’s upload a file from the Home Page.

Click the Upload Data button.
The Upload page opens. 

Pivoting Data

Some data files may contain repeating columns, such as sales figures for a series of years. There may even be repeating column groups, such as both budget and actual figures for a series of years. When uploading data, you can use the pivot option to transform these columns or groups of columns into rows, as shown in the following image.

Note: The pivot option is also available when creating or editing metadata.

Saving Files

You can save a file in the Editor in one of the following ways:

  • Click the Save button on the toolbar.
  • Select Save or Save As from the Application menu.

Procedure: How to Save a Procedure File

  1. Create a new procedure (FOCEXEC) in the Editor.

    The default file name is New FOCEXEC File *. Since the file has not been saved, an asterisk (*) appears to the right of the file name. When the file is saved, the asterisk is removed.

Hiding ACROSS Group Columns with Null Values in Active Reports

Report requests that use the ACROSS sort phrase generate a group of columns (one for each display field in the request) under each value of the ACROSS field. In many cases, some of these columns have only missing or null values.

When working with active reports in AHTML format, you can use the HIDENULLACRS parameter to hide the display of ACROSS groups containing only null columns. To hide null across columns, use SET HIDENULLACRS=ON. The default value is OFF.

Video: Changing a Data Field Format

You can change the data format for a field to change how the values are displayed. For example, you can change the number of digits or decimal places displayed in a number, the maximum length of a character string, the format of a date field, or apply a custom format by typing in the WebFOCUS language designation. You can apply format changes to fields from the data source that were added to a chart, as well as to define and compute fields.

In this data grid, we can see sales information for each day.

Indexing Report Library Output

In addition to searching for parameterized reports, you can optionally enable Report Library output data for indexing and search InfoSearch. Unlike report procedures (FEX), a Report Library output does not need to contain a parameter to be found in InfoSearch.

When the Index Library Output check box is selected and saved in the ReportCaster Console, all subsequent Report Library distributions will be indexed and made searchable by InfoSearch.

Note: