Skip to content

The TGKSEND function

Description

The TGKSEND function allows you to retrieve, edit and save a value on a different database from the one on which the form is run. It can only be used if a form is opened in data entry mode and if the user has editability rights over the function’s dimensions.

Syntax

The function uses the following syntax:=TGKSEND(value, datasource, "DimensionName1:value1", "DimensionName2:value2....). "Value" indicates the code of the Excel cell.

With this function, you must indicate the cell to be made editable as the first argument.

Arguments

The items that can be added to the function are detailed below.

Of the function’s arguments have been defined correctly and the user has the necessary rights over the dimensions involved, the cell specified as the function’s first parameter will be editable.

Note: for editability, the same arguments as the TGKRET function are permitted, but with individual elements (and not nodes); see The TGKRET function.

Syntax conventions and specifics

  • To recover several elements or nodes of aggregation structures for the same dimension, values can be separated by ",". The system reads the data related to all specified elements. For example, to recover accounts 50010 and 40010, the syntax in the position relative to the account is Account:50010,40010.
  • To recover several nodes belonging to different aggregation structures for the same dimension, the system reads the intersection data related to the elements related to the nodes. For example, to recover the entities related to node N1 of hierarchy H1 and node N1 of hierarchy H2, the syntax is Entity:H1:*N1,H2:*N1.

Example

To define a cell as editable, only individual elements, not nodes, must be used as parameters. To retrieve the value of the revenue for the Antivirus product for the geographical area Italy and for scenario 2012BDG, apply the following filters:

  • Scenario = 2012BDG
  • Period = 12
  • Account = 50010 - Product Revenues
  • Product (managed on custom dimension 2) = A01 - Antivirus
  • Entity = A00 - Distribution Rome
  • Cost Center (managed on custom dimension 1) = G01 - Generic
  • Employee (managed on custom dimension 3) = G01 - Generic

To make cell A5 editable, the function’s syntax is =TGKSEND($A$5, TGKCURRDB(), "Account:50010", "Scenario:2012BDG","Entity:A00", "Cust_Dim1:G01", "Cust_ Dim2:A01","Cust_Dim3:G01","Period:12","Category:$AMOUNT","AmountType:TIP_O","PeriodLength:LUN_0")