GetCubeValue

Syntax

GetCubeValue(DataSource, Dimension)

Parameters

DataSource. Number or identifier of data source.

Dimension. It is available only after the DataSource parameter is selected. The number, name or identifier of the dimension in the slice. Parameter name corresponds to dimension name in the cube. The number of formula parameters corresponds to the number of cube dimensions.

Description

It returns cube value.

Comments

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

=GetCubeValue ("<Container identifier1>.<Container identifier2>.<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. 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.