SetPivotDrill: Operation

The SetPivotDrill operation changes analytical data area slice drilldown settings.

Comments

To execute the operation, in the mon field specify moniker for working with slice drilldown settings in the following format: Regular report moniker instance!DataArea!DataSources!Source key!DataSourceSlices!Slice key!Pivot!Drill, and in the tArg field specify drilldown settings to be determined.

The operation results in the logical True if drilldown settings were changed successfully.

Example

Below is the example of changing analytical data area slice drilldown settings. The request contains moniker for working with drilldown settings, key of the dimension, in which drilldown will be available, and selection strategy. The response contains whether settings were changed successfully.

SOAP JSON C#

SOAP request:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">

<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<mon xmlns="">LOFEEGJIFBPGGOAEEAMPEGKHODEJLGIEKJHAJGOPCGHHHEFI!M!S!PCHKNFLJIFBPGGOAEKDLIPHJCKJEMPFLEKJAAFDDOOFHPHEDI!DataArea!DataSources!1!DataSourceSlices!1!Pivot!Drill</mon>

<its>

<it>

</it>

</its>

</dimensions>

<strategy>Combine</strategy>

</tArg>

</SetPivotDrill>

</s:Body>

</s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

</soapenv:Body>

</soapenv:Envelope>

JSON request:

{
 "SetPivotDrill" : 
  {
   "mon" : "LOFEEGJIFBPGGOAEEAMPEGKHODEJLGIEKJHAJGOPCGHHHEFI!M!S!PCHKNFLJIFBPGGOAEKDLIPHJCKJEMPFLEKJAAFDDOOFHPHEDI!DataArea!DataSources!1!DataSourceSlices!1!Pivot!Drill",
   "tArg" : 
    {
     "dimensions" : 
      {
       "its" : 
        {
         "it" : 
          [
            {
             "k" : "461037"
            }
          ]
        }
      },
     "enabled" : "true",
     "strategy" : "Combine"
    }
  }
}

JSON response:

{
 "SetPivotDrillResult" : "1"
}

public static bool SetPivotDrill(string moniker, uint sourceKey, uint sliceKey, ItCollectionEx drillDims)
{
    var somClient = new SomPortTypeClient(); // Proxy object for operation execution
    // Operation execution parameters
    var tSet = new SetPivotDrill()
    {
        tArg = new PivotDrill()
        {
            dimensions = drillDims,
            enabled = true,
            strategy = PivotDrillSelectionStrategy.Combine
        },
        mon = moniker + "!DataArea!DataSources!" + sourceKey + "!DataSourceSlices!" + sliceKey + "!Pivot!Drill"
    };
    // Change data slice drilldown settings
    var result = somClient.SetPivotDrill(tSet);
    return result;
}

SetPivotDrill

Syntax