XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "XL3MemberAlias"

 
Line 3: Line 3:
 
==Syntax==
 
==Syntax==
  
{{Code|XL3AliasMember( Connection, Hierarchy, Member, Alias )}}
+
{{Code|XL3MemberAlias( Connection, Hierarchy, Member, Alias )}}
  
 
==Parameters==
 
==Parameters==

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