PivotDrill GetPivotDrill(string mon)
mon. Moniker for working with drilldown settings.
The GetPivotDrill operation gets drilldown settings for analytical data area slice.
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.
The operation results in the obtained slice drilldown settings.
Below is the example of getting drilldown settings for analytical data area slice. 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: