PivotHeader GetPivotHeaderMetaData(string mon, PivotHeader tArg)
mon. Moniker for working with data slice header.
tArg. Parameters for getting information about slice header.
The GetPivotHeaderMetaData operation gets information about data slice header.
The operation gets various settings specified for header.
To execute the operation, in the mon field specify regular report instance moniker with the !DataArea!DataSources!<data source key>!DataSourceSlices!<slice key>!Pivot! postfix. This moniker should also be appended with one of the following values:
TopHeader - to work with columns header.
LeftHeader - to work with rows header.
The moniker can be obtained on executing the OpenPrxMeta operation.
In the tArg field set empty values or default values for the fields, which values should be obtained. The operation returns the obtained settings for data slice header.
Below is the example for getting columns header settings of data slice. The request contains moniker for working with the header and the list of fields, which values should be obtained. The response contains the requested settings.
{
"GetPivotHeaderMetaData" :
{
"mon" : "FCJKECDEBBGOFOAENKBHCHAOHGPDFHHEPJAKMBIGJNLFCJOB!M!S!PLHCGKDDEBBGOFOAENCPCGCHBJGOFDLNEIJMPDIHNAGKFLNGA!DataArea!DataSources!1!DataSourceSlices!1!Pivot!TopHeader",
"tArg" :
{
"headerSettings" :
{
"filter" :
{
"enabled" : "false",
"suppressEmptyCells" : "false",
"suppressZeroCells" : "false",
"suppressNoNumericCells" : "false"
}
},
"separated" : "0"
}
}
}
{
"GetPivotHeaderMetaDataResult" :
{
"headerSettings" :
{
"filter" :
{
"enabled" : "1",
"suppressEmptyCells" : "0",
"suppressZeroCells" : "0",
"suppressNoNumericCells" : "0"
}
},
"separated" : "1"
}
}
public static PivotHeader GetPivotHeaderMeta(string moniker, uint dataSourceKey, uint sliceKey)
{
var somClient = new SomPortTypeClient(); //Proxy object for operation execution
//Operation execution parameters
var tGet = new GetPivotHeaderMetaData()
{
tArg = new PivotHeader()
{
headerSettings = new PivotHeaderSettings()
{
filter = new PivotHeaderFilter()
{
enabled = new bool(),
suppressEmptyCells = new bool(),
suppressNoNumericCells = new bool(),
suppressZeroCells = new bool()
}
},
separated = new int()
},
mon = moniker + "!DataArea!DataSources!" + dataSourceKey.ToString() + "!DataSourceSlices!" + sliceKey.ToString() + "!Pivot!TopHeader"
};
//Get information about title
var result = somClient.GetPivotHeaderMetaData(tGet);
return result;
}
See also: