SetPivotDrill: Operation

The SetPivotDrill operation changes drilldown settings for analytical data area slice.

Comments

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

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

Example

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

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