INFOR.GET.VALUE
Use INFOR.GET.VALUE
to perform writeback and
splashing in writeback mode. This function returns any property of the selected cell. By
default, it returns the Value property.
Syntax
The function has this syntax:
INFOR.GET.VALUE("data_connection", "cube" {, "cell_property", "cell_coordinate", ... })
This table shows the parameters and their descriptions:
Parameters | Description |
---|---|
data_connection |
Represents the database unique name. It is a string or a cell reference. |
cube |
Represents the cube unique name. It is a string or a cell reference. |
cell_property |
Represents the cell property unique name. The
default value is value . It is a string or a
cell-reference. |
cell_coordinate
|
Represents the element unique name and must be provided in its long form. It is any number of strings or cell references, up to Excel's limit of 252. |
Return values
This function returns a single value. It supports implicit aggregation.
When you provide multiple cell_coordinate
arguments from
the same hierarchy, it returns an aggregated value of all specified elements from the
specified hierarchy.