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

XL3CubeFormattedComment

Returns a cube comment for a given cross section of the cube and outputs it into a cell.

Syntax

XL3CubeFormattedComment( Connection, OutputCell, [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
OutputCell Cell to put the formatted comment into
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