PivotDrill GetPivotDrill(string mon)
mon. Moniker for working with drilldown settings.
The GetPivotDrill operation gets analytical data area slice drilldown settings.
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.
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.
{
"GetPivotDrill" :
{
"mon" : "LOFEEGJIFBPGGOAEEAMPEGKHODEJLGIEKJHAJGOPCGHHHEFI!M!S!PCHKNFLJIFBPGGOAEKDLIPHJCKJEMPFLEKJAAFDDOOFHPHEDI!DataArea!DataSources!1!DataSourceSlices!1!Pivot!Drill"
}
}
{
"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: