Creating Editable Facets

In the Specify Data Model Options page, View Options, Specify Axis Information section, you can select a Data Source Column to be a facet in the fluid view.

Note:

You can enable this option for the data source columns that are set as Axis or Value in the Column Type. Columns that are set as Display in the column type cannot be defined as editable facets.

To enable the Axis or Value columns as editable facets:

  1. In the Specify Data Model Values page, select the Editable Facet option for the columns.

  2. In the Specify Data Model Options page, set the columns (that have Editable Facets enabled) to Filters so these columns can appear in fluid view.

  3. In fluid view, you will see the More Options link at the bottom-left of the Prompts section. Click to display the editable facets.

    Click the Show Operations link to display the operators that are specific to each prompt.

  4. Select the available operators for the prompts to filter the data in the grid and in the chart.

Note:

Editable facets behave as prompts; therefore, editable facet selections reset the other facet values.

Different operators are available for different type of fields:

  • Character fields have these operators: Contains (Default), Does Not Contain, Equal To, Not Equal To, In List, and Not In List.

  • Date and number fields have these operators: Equal To (Default), Not Equal To, Between, Not Between, Greater Than, Not Greater Than, Equal To, and Not Equal To.

Note:

You can see the editable facets only in fluid view. They are not available in classic view.

Values entered in the editable facets are user-specified and not prompted, applying filters using the editable facets may return zero value in the results, or an empty grid and empty chart. Also, security is not applied on the user-specific values, so you must be careful as to which fields can be selected as editable facets.