We have updated Flexmonster Software License Agreement, effective as of September 30, 2025 (list of changes)
All documentation

MemberIdentifierObject

This object is used to specify field members that should be expanded or drilled down.

Properties

{
  tuple: string[],
  measure: MeasureIdentifierObject
}
Property/TypeDescription
tuple
String[]
Consists of unique names that identify the member in a row/column.
measure
MeasureIdentifierObject
optional Use the measure to expand/drill down a member for a specific measure when:
  • The slice has several measures.
  • The member's field is nested in measures.
If the measure is null, the member will be expanded/drilled down for all measures in the slice.

Example

The following example shows how to specify which field members should be expanded or drilled down:

slice: {
  // Other slice properties
  drills: {
    columns: [
      {
        tuple: ["order date.[2019]"],
        measure: {
          uniqueName: "Quantity",
          aggregation: "sum"
        }
      },
    ],
  },
  expands: {
    rows: [
      {
        tuple: ["country.[japan]"],
      },
    ],
  },
}

See also

DrillsObject
ExpandsObject