InFocus Variables

Overview

InFocus gives the user the ability to leverage common variables when building queries, reports, etc.

Leverage a list of System Variables or create custom Global Variables.

You can view a full list of available InFocus Variables when using query applets by clicking, for instance, View Variables link from Custom Reports or View Variables List from the toolbar of Dashboard Queries Manager.

Variables are referenced in queries using the following syntax: @variable@. For example: select periodcode, startdate, enddate from glperiods where periodcode='@CURRENTPERIODCODE@'

Next: System Variables