1. On-premises 5.1
  2. Guides
  3. Tours
  4. Concepts
    1. Aggregate filter
    2. Alias
    3. Apache Avro™
    4. Apache Kafka™
    5. Applied filter
    6. Base table
    7. Bookmark
    8. Business schema
    9. Business schema view
    10. Business schema view column
    11. Business schema view formula column
    12. Column
    13. Connector
    14. Dashboard filter
    15. Dashboard folder
    16. Dashboard runtime filter
    17. Data agent
    18. Data alert
    19. Data destination
    20. Date system variable
    21. Distinct filter
    22. Expression
    23. External data source
    24. External session variable
    25. Filter expression
    26. Filter expression session variable
    27. Filter option
    28. Formula column
    29. Formula expression
    30. Full load
    31. Global Variable
    32. Incorta Analyzer Table
    33. Incorta Analyzer Table column
    34. Incorta Analyzer Table formula column
    35. Incorta SQL Table
    36. Incorta View
    37. Incorta View formula column
    38. Individual filter
    39. Insight filter
    40. Internal query expression
    41. Internal session variable
    42. Join
    43. Join condition
    44. Join condition column
    45. Join filter
    46. Join filter column
    47. Level based measure
    48. Load filter
    49. Local data file
    50. Local data folder
    51. Materialized View
    52. Materialized View Column
    53. Materialized View Formula Column
    54. Measure filter
    55. Miscellaneous system variable
    56. Multi-Source table
    57. Physical schema
    58. Physical schema table
    59. Physical schema table column
    60. Physical schema table formula column
    61. Physical schema table runtime security filter
    62. Presentation variable
    63. Prompt
    64. Query system variable
    65. Runtime business view
    66. Runtime business view formula column
    67. Runtime security filter
    68. Session variable
    69. Shared Storage
    70. SQL Interface
    71. Upgrade Readiness
    72. Variable
    73. Visualization
  5. Tools
  6. References
  7. Integrations
  8. Data applications
  9. Releases

Concepts → Presentation variable

About a presentation variable

Defined in Dashboard Filters, a presentation variable is a referenceable and mutable variable of a specific data type with a default value that exists only within the scope of the given dashboard and a user accessing the dashboard.

The definition of a presentation variable overrides the default behavior of a dashboard which is to coalesce a list of dimension columns from all insights on all tabs as filterable columns available in the Filter and Search controls. Once defined and configured, a presentation variable appears in the Columns panel in the Filter dialog and as a filter bar pill. A dashboard consumer can assign a new value to a presentation variable in the Filter dialog.

Unlike a prompt, applied filter, or filter option, a presentation variable is not in itself a filter expression.

A dashboard developer defines zero or more presentation variables for a given dashboard.

Often, a dashboard developer references a presentation variable as a filter value in a filter expression or as a part of formula in a formula expression.

A dashboard consumer can assign a new value to a presentation variable in the Filter dialog. Unlike a session variable, the new value is immediately accessible to the dashboard itself. This means that any affected formula expressions or filter expressions will immediately be recalculated and reapplied.

A dashboard developer with Edit access rights to a dashboard can create and edit one or more presentation variables. Here's how:

  • In the Action bar of a dashboard, select More Options (⋮ vertical ellipsis icon).
  • In the More Options menu, select Manage Filter & Prompts.
  • In Dashboard Filters, select Presentation Variables.
  • From the Data panel, drag & drop a column or formula to the presentation tray.

Supported usage

Because a presentation variable is a mutable, referenceable object, a dashboard developer can utilize a presentation variable in a variety of ways:

  • as a filter value in the filter expression of a dashboard filter or as any part of a formula that is a filter expression of a dashboard filter
    • an applied filter
    • a filter option
  • as a filter value in the filter expression of an insight on a dashboard or as any part of a formula that is a filter expression of an insight on a dashboard
    • an individual filter
    • an aggregated filter
    • a measure filter
  • as any part of a formula expression for a formula pill in an insight on a dashboard for
    • a grouping dimension
    • a coloring dimension
    • a measure

Unsupported usage

There are some unsupported uses of a presentation variable which may result in an error or unexpected behavior:

  • as part of a formula expression for a formula column in a physical schema table or materialized view
  • as part of a formula expression for a formula pill in an Incorta View or Incorta Analyzer Table
  • as part of the expression in a filter expression session variable
  • as part of an internal query expression for an internal session variable
  • as a default value for a global variable
  • as filter value for an individual filter, aggregated filter, or measure filter for an Incorta View or Incorta Analyzer Table
  • as a default filter value for a prompt
  • as part of a formula expression for a formula column in a runtime business view
Note

To learn more about referencing a presentation variable as part of a formula expression for a formula column in a runtime business view, see Additional considerations for a presentation variable.

Properties for a presentation variable pill

The following are the properties of a presentation variable

PropertyControlDescription
Variable namelabelDisplays the variable display name.
Display Nametext boxRequired. Enter the display name for the presentation variable. This name will appear as the name as a filterable column in the Filter dialog and as the filter bar pill name.
Variabletext boxRequired. This is the variable name.
Data Typedrop down listRequired. Set the data type for the variable as string, double, long, integer, or date.
Default Valuetext boxRequired. Enter a default value for the variable. This can be system variable, internal session variable, or external session variables.
Default Value → VariablecheckboxOptional. Only available for variables that are a date system variable, internal session variable, or external session variable.
Field (Optional)tray and pillOptional. Drag and drop a column from the Data panel to the tray. The pill populates the available values that appear in the Values panel of the Filter dialog for the presentation variable.
DonelinkSaves changes you made to the presentation variable. However, to commit these changes, you must select Done in the Action bar of the Dashboard Filters Manager.
DeletelinkDeletes the presentation variable. To commit these changes, you must select Done in the Action bar of the Dashboard Filters Manager.

A variable as a default value or assigned value

As a dashboard developer, it is important to understand that a presentation variable has a data type and default value. It is possible to define a default value using another variable. Similarly, it also possible specify as variable as an assigned value for a presentation variable in the filter dialog.

Important: Session variables store string values

All three types of session variables store values as a string. If a presentation variable is not of the type string, do not use a session variable for a default value or as an assigned value of a presentation variable.

The following table describes the supported variable and data types for a the value of presentation variable.

Variable typePresentation variable
data type		Default
value		Assigned
value
Date system variabledate✔✔
External session variablestring✔✔
Global variable
Filter expression session variablestring✔✔
Internal session variablestring✔✔
Miscellaneous system variablestring✔
Presentation variable
Note

Although it may be possible to specify a presentation variable or a global variable as a default value or as an assigned value of a presentation variable, this configuration is not supported and may produce unexpected results.

Additional considerations for a presentation variable

Note

If you have a session variable and a presentation variable with the same name, the global session variable will have a type of string and take precedence over any presentation variable you define in a dashboard.

A schema developer and dashboard developer may implement the usage of a presentation variable in a formula column for a runtime business view. The practice consists of the following steps:

  • First, create an internal session variable with a specific name such as pv_example.
  • Create a formula column in a business schema view or Incorta view with a formula expression that references the internal session variable. AS a valid expression for the Formula Builder, this expression will pass formula validation.
  • Save the changes to the runtime business view.
  • Delete the internal session variable.
  • For a given dashboard, create a presentation variable with the same name as the deleted internal session variable such as pv_example.

A future upgrade may fail without the re-introduction of the original internal session variable.