GetCubeValue

Syntax

GetCubeValue(DataSource, Dimension)

Parameters

DataSource. Number or identifier of data source.

Dimension. The number, name or identifier of the dimension.

Description

It returns cube value.

Comments

The Dimension parameter is available only after selecting the DataSource parameter. Parameter name corresponds to dimension name in the cube. The number of formula parameters corresponds to the number of cube dimensions. When the function is entered into the cell or formula bar, the parameter supports the use of the Contenante function.

To calculate the function, refresh the report. Before the refresh, the cell displays the text "Refresh data".

After the function is applied, the formula in the cell will look as follows:

=GetCubeValue ("<Container1 identifier>.<Container2 identifier>.<Cube identifier>","<Dimension identifier_1>#[<Unique element identifier>]", "<Dimension identifier_2>#[<Unique element identifier>]")

Unique element identifier for MDM dictionaries is key, for table dictionaries and calendar dictionaries - identifier.

If a table dictionary attribute assigned as identifier does not match the attribute, which is set to the primary key index, the identifier should be assigned to the attribute corresponding to this primary key.

NOTE. Container identifier should be specified if it exists.

Example

Formula	Result	Description
=GetCubeValue("CUBE_SEP", "D_FACTS#1", "D_CALENDAR#YEARS:2002", "DIC_SEP#30100" , "DIC_RF#11, "DIC_SOURCE#1")	4079	Get value from the Cube of Socio-Economic Indicators cube with the CUBE_SEP identifier and with the following attributes: D_FACTS#1 - the Value element of the Facts dimension. D_CALENDAR#YEARS:2002 - the 2002 element of the Calendar dimension. DIC_SEP#30100 - the Volume of an Industrial Output in the Actual Prices of the Enterprises, mln.rub. element. per Year element of the Socio-Economic Indicators dimension. DIC_RF#11 - the Arkhangelsk Region element of the Territories dimension. DIC_SOURCE#1 - the Data of State Committee element of the Data Types dimension.