XL3CubeFormattedComment

Revision as of 14:37, 5 September 2018 by Colin (talk | contribs) (Created page with "Returns a cube comment for a given cross section of the cube and outputs it into a cell. ==Syntax== {{Code|XL3CubeFormattedComment( Connection, OutputCell, [Hierarchy1], [Me...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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