XL3LastCubeComment

Revision as of 13:31, 1 November 2023 by Csalter (talk | contribs) (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], [...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Returns only the most recent 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