KEY.GET

KEY.GET returns the last argument of a formula as a string.

Note:

Office Plus formulas reference the unique names of elements. Not all formulas that return an element display the unique element name (for example, MEMBER.CNAME, MEMBER.MNAME). Use the KEY.GET formula to get the unique name of an element from these formulas.

Syntax

=KEY.GET(Reference)

Example

Gets the last argument from the formula MEMBER.CNAME:=MEMBER.CNAME("FoodMart 2008","Sales","[Product]","[Product].[All Products].[Food].[Breakfast Foods]")

The formula MEMBER.CNAME displays the caption of the Breakfast Foods element:


	A	B	C	D	E	F	G	H	I
1		Breakfast Foods		KEY.GET(B2)
2


	A	B	C	D	E	F	G	H	I
1		Breakfast Foods		[Product].[All Products].[Food].[Breakfast Foods]
2

KEY.GET returns the unique name, which is the last argument.