Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • 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