CELL.GETF

You can get formatted values from a cube using the CELL.GETF formula. The formatting is predefined on the server (provider formatting).

Note: If you use this formula, charts cannot be displayed.

Syntax

=CELL.GETF(Alias,Cube,Memb 1,Memb 2, ...)

Arguments

This table describes the arguments of the function:


Argument	Description	Example
Alias	Name of the database alias	Best Practices OLAP
Cube	Name of the cube	`[SALES]`
Memb 1 Memb 2...	Unique name of the element	`[INTERCO].[TOTALPARTNER]`

Note: The default element is used if you do not select an element for a dimension of the cube.

Example

Get the formatted value from the Best Practices OLAP Sales cube.

=CELL.GETF("Best Practices OLAP","Sales","[Time].[All Years].[2008].[Q1_2008]","[Profit].[Gross Margin]")

The gross margin ([Profit].[Gross Margin]) is returned for the first quarter of 2008 ([Time].[All Years].[2008].[Q1_2008]). The default element is used for all other dimensions, because no additional elements have been specified for these dimensions.

Note: When you change the value of the cell that contains the CELL.GET formula, the value is written back to the database.