Show TOC

RemoveMemberFromRowAxis Locate this document in the navigation structure

This API enables you to remove the specified dimension member (and its dimension if it is the only member for this dimension in the report) from the row axis.

Parameter Description
Worksheet as sheet Microsoft Excel worksheet name containing the report. Mandatory.
ReportD as string Identifier of the report. Mandatory.
MemberName as string Mandatory.
  • Dimension member name (caption or unique name)
  • or dimension:member, where you can specify either the caption or unique name for the dimension and for the member
  • or hierarchy:member, where you can specify either the caption or unique name for the dimension and for the member
Note It is recommended that you use:
  • dimension:member for Planning and Consolidation connections,
  • hierarchy:member for the other connections.
DynamicRelation as integer See below the list of values available. Mandatory.

Applies only to dimension members that have been selected with the same dynamic relation.

List of supported dynamic relations values:
  • Member = 1
  • Children = 2
  • Member and Children = 3
  • Descendants = 4
  • Member and Descendants = 5
  • Leaves = 6
  • Same Level = 7
  • Siblings = 8
  • Ascendants = 9
  • Member and Ascendants = 10
  • Member and Leaves = 11
  • Property = 12
  • Named Set = 13
  • Member OffSet = 14
  • Member Property = 15
Note The refresh action is required to update the report.