Difference between revisions of "XL3MemberAlias"

(Created page with "Allows you to alias a member lookup to return a more readable name. ==Syntax== {{Code|XL3AliasMember( Connection, Hierarchy, Member, Alias )}} ==Parameters== {| class="wikitab...")
 
Line 22: Line 22:
 
| Text that can be used to refer to the member specified. This will often be used by a cell containing an [[XL3Lookup]] formula.
 
| Text that can be used to refer to the member specified. This will often be used by a cell containing an [[XL3Lookup]] formula.
 
|}
 
|}
 +
 +
==See Also==
 +
* [[Formula Reference]]
 +
 +
[[Category:Formulae]]
 +
[[Category:OLAP Formulae]]

Revision as of 12:43, 22 July 2011

Allows you to alias a member lookup to return a more readable name.

Syntax

XL3AliasMember( Connection, Hierarchy, Member, Alias )

Parameters

Parameter Description
Connection Connection number to use
Hierarchy Name of the hierarchy that the member applies to e.g. "Measures" or "[Customer].[Customer Geography]"
Member Member to use. This will often point to a cell containing an XL3Member formula.
Alias Text that can be used to refer to the member specified. This will often be used by a cell containing an XL3Lookup formula.

See Also