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

Difference between revisions of "XL3CubeComment"

(Created page with "Returns a cube comment for a given cross section of the cube. ==Syntax== {{Code|XL3CubeComment( Connection, [Hierarchy1], [Member1],…, [Hierarchy14], [Member14] )}} ==Par...")
 
Line 3: Line 3:
 
==Syntax==
 
==Syntax==
  
{{Code|XL3CubeComment( Connection, [Hierarchy1], [Member1],…, [Hierarchy14], [Member14] )}}
+
{{Code|XL3CubeComment( Connection, [Hierarchy1], [Member1],…, [Hierarchy100], [Member100] )}}
 +
 
 +
{{Excel Parameter Limitation|This allowed up to 14 hierarchy-member pairs.}}
  
 
==Parameters==
 
==Parameters==

Revision as of 13:09, 29 April 2016

Returns a cube comment for a given cross section of the cube.

Syntax

XL3CubeComment( Connection, [Hierarchy1], [Member1],…, [Hierarchy100], [Member100] )

Before XLCubed Version 9, this formula was limited to 30 parameters. This allowed up to 14 hierarchy-member pairs.

Parameters

Parameter Description
Connection Connection number to use
Hierarchy1,…, HierarchyN Name of the hierarchy that the following member applies to e.g. "Measures" or "[Customer].[Customer Geography]"
Member1,…, MemberN Either a single member unique name or an XL3Member formula

See Also