GetPivotDrill

Syntax

PivotDrill GetPivotDrill(string mon)

Parameters

mon. Moniker for working with drilldown settings.

Description

The GetPivotDrill operation gets 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 instance moniker!DataArea!DataSources!Source key!DataSourceSlices!Slice key!Pivot!Drill.

The operation results in the obtained slice drilldown settings.

Example

Below is the example of getting analytical data area slice drilldown settings. The request contains moniker for working with drilldown settings. The response contains the obtained settings.

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">
<GetPivotDrill xmlns="http://www.fsight.ru/PP.SOM.Som">
  <mon xmlns="">LOFEEGJIFBPGGOAEEAMPEGKHODEJLGIEKJHAJGOPCGHHHEFI!M!S!PCHKNFLJIFBPGGOAEKDLIPHJCKJEMPFLEKJAAFDDOOFHPHEDI!DataArea!DataSources!1!DataSourceSlices!1!Pivot!Drill</mon>
  </GetPivotDrill>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<GetPivotDrillResult xmlns="http://www.fsight.ru/PP.SOM.Som" xmlns:q1="http://www.fsight.ru/PP.SOM.Som" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<dimensions xmlns="">
<its>
<it>
  <k>461037</k>
  </it>
<it>
  <k>461033</k>
  </it>
<it>
  <k>461031</k>
  </it>
  </its>
  </dimensions>
  <enabled xmlns="">1</enabled>
  <strategy xmlns="">Replace</strategy>
  </GetPivotDrillResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
"GetPivotDrill" :
{
"mon" : "LOFEEGJIFBPGGOAEEAMPEGKHODEJLGIEKJHAJGOPCGHHHEFI!M!S!PCHKNFLJIFBPGGOAEKDLIPHJCKJEMPFLEKJAAFDDOOFHPHEDI!DataArea!DataSources!1!DataSourceSlices!1!Pivot!Drill"
}
}

JSON response:

{
"GetPivotDrillResult" :
{
"dimensions" :
{
"its" :
{
"it" :
[
{
"k" : "461037"
},
{
"k" : "461033"
},
{
"k" : "461031"
}
]
}
},
"enabled" : "1",
"strategy" : "Replace"
}
}
public static PivotDrill GetPivotDrill(string moniker, uint sourceKey, uint sliceKey)
{
var somClient = new SomPortTypeClient(); // Proxy object for operation execution
// Operation execution parameters
var tGet = new GetPivotDrill()
{
mon = moniker + "!DataArea!DataSources!" + sourceKey + "!DataSourceSlices!" + sliceKey + "!Pivot!Drill"
};
// Get data slice drilldown settings
var result = somClient.GetPivotDrill(tGet);
return result;
}

See also:

Working with Regular Reports