Concepts → Miscellaneous System Variable
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.
Incorta will calculate a system variable at different times depending on where the variable is being utilized.
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.
If you use a system variable in a business schema or dashboard, the variable is calculated at the time of query.
Following are the available miscellaneous system variables within Incorta:
|$user||string||The current Incorta user||myAdmin|