XL3Comment

Revision as of 08:22, 15 September 2015 by Csalter (talk | contribs) (Created page with "Returns any Cube Comments for a given cross section of the cube, can also allow entry of comments for that cube-slice if allowed. ==Syntax== {{Code|XL3Comment( Connectio...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Returns any Cube Comments for a given cross section of the cube, can also allow entry of comments for that cube-slice if allowed.

Syntax

XL3Comment( Connection, [Hierarchy1], [Member1],…, [Hierarchy14], [Member14] )

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

Example

=XL3Comment( 1, "[Time]", "[Time].[2004]", "[KeyFigures]", "[KeyFigures].[Revenue]" )


See Also