Custom functions

Introduction

In CCH Tagetik, data can be read/entered data in the database without defining matrices, by inserting Custom functions directly in the cells of forms.

Function	Description
TGKCURRDB	Retrieves the identification code of the database to which the user is connected during the current work session.
TGKRET/TGKRETF	Retrieves data from a certain database according to the arguments specified in the function invocation step.
TGKSEND	Retrieves a value from a certain database and allows the user to edit it and save it in the database again.
TGKFIELD	Retrieves the value of a cell field.
TGKAMOUNT	Retrieves the value present in the database according to the filters present on a cell.
TGKCALCSET	Allows you to optimise performance in the presence of forms containing many custom functions.
TGKOPTION	Allows you to specify the reporting engine with which to calculate TGKRET functions.

IMPORTANT: custom functions only support uppercase characters.

If the forms do not contain custom functions, you can tell the system not to check for their existence in the form run step and then prevent them from being run via the "Disable custom functions“ option (see Form options window). This reduces the time needed to run the form, particularly when it contains many cells.

Note: When a CCH Tagetik form is exported to Excel, the resulting file is converted into a standard (raw) Excel file that is no longer linked to the CCH Tagetik Excel Add-in. As a consequence, the exported Excel file does not contain the information required to connect to the CCH Tagetik database, such as application context, dimensional metadata, or user authentication details. For this reason, CCH Tagetik custom functions (for example TGKAMOUNT, TGKRET, TGKSEND, and related functions) are not available and cannot retrieve data when the form is used offline or when it is opened as an exported Excel file.