User Variables

%USERFINPERIOD%

The identifier of the financial period selected in the input or report template options.

In the definition file of a drill-down sheet, this variable inherits its value from the cell (from the column definitions) that the user has drilled down from. For example, if the user drills down from a column whose column definition is '5', the value of the variable in the definition file of the drill-down sheet is always '5' regardless of what the user has selected in the input or report template options.

%USERFINYEAR%

The identifier of the financial year selected in the input or report template options.

In the definition file of a drill-down sheet, this variable inherits its value from the cell (from the column definitions) that the user has drilled down from. For example, if the user drills down from a column whose column definition is '2006', the value of the variable in the definition file of the drill-down sheet is always 2006 regardless of what the user has selected in the input or report template options.

%USERSCALINGFACTOR%

The scaling factor defined in the input or report template options.

For example, if the defined scaling factor is 1000, Header(/ %USERSCALINGFACTOR%) generates the value 'Header(/ 1000)'.

In the definition file of a drill-down sheet, this variable inherits its value from the cell (from the column definitions) that the user has drilled down from.

%USER CODE%

The user ID of the current user account.

Example of use in an SQL statement in a custom sheet:

<sql id="SaveFINYRS"><sqlstatement>UPDATE FMFINYRSET FINYR_POSITION =:position:,[FINYR_UPDATENAME] =CURRENT_USER,[FINYR_UPDATEDATE] =%USER CODE %WHERE FINYR_UDID=:udid: ;END.....

%USER EMAIL%

The email of the current user account. %USER EMAIL% fetches values from FMUSER table's USER_EMAIL column.

As an example of use, you can select user from Table where email = '%user email%'

%USER NAME%

The name of the current user account (user's last name + first name).