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...")
Returns any Cube Comments for a given cross section of the cube, can also allow entry of comments for that cube-slice if allowed.
Contents
[hide]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]" )