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


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.


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