Concepts → Miscellaneous System Variable

About Miscellaneous System Variables

Miscellaneous system variables dynamically reference information and are not part of a larger category of system variables, such as date system variables. The Formula Builder gives you access to system variables when building formula expressions.

When System Variables are Calculated

Incorta will calculate a system variable at different times depending on where the variable is being utilized.

System variables in a physical schema

If you create a formula column in a physical schema that utilizes a system variable, the variable is interpreted at load time and stored in memory.

System variables in a business schema or dashboard

If you use a system variable in a business schema or dashboard, the variable is calculated at the time of query.

Available Miscellaneous System Variables

Following are the available miscellaneous system variables within Incorta:

Variable	Data Type	Description	Example
$user	string	The current Incorta user	myAdmin