❄️✨Ho-ho-holiday offer for new projects! Check out our pricing page.
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 or column.
    measure
    MeasureIdentifierObject
    optional Use the measure to expand or 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 or 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