Need a special offer?Find out if your project fits.
+
API reference
  • API Reference for older versions
  • Table of contents

    MemberIdentifierObject

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

    Properties

    {
      tuple: string[],
      measure: MeasureIdentifierObject
    }
    Property/Type Description
    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