Difference between revisions of "XL3LastCubeComment"

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

Revision as of 13:32, 1 November 2023

Returns only the most recent cube comment for a given cross section of the cube.

Syntax

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