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...")
 
 
(2 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
==Syntax==
 
==Syntax==
  
{{Code|XL3AliasMember( Connection, Hierarchy, Member, Alias )}}
+
{{Code|XL3MemberAlias( Connection, Hierarchy, Member, Alias )}}
  
 
==Parameters==
 
==Parameters==
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]]

Latest revision as of 16:01, 22 July 2011

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

Syntax

XL3MemberAlias( 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