bool SetPivotDimensionMetaData(string mon, PivotDimension tArg)
mon. Moniker for working with data slice dimension.
tArg. Dimension parameters that should be applied.
The SetPivotDimensionMetaData operation changes data slice dimension.
To execute the operation, in the mon field specify moniker of regular report instance with the !DataArea!DataSources!<source key>!DataSourceSlices!<slice key>!Pivot!PivotDims!<dimension key> postfix to work with a dimension, and in the tArg field specify new parameters of the dimension that should be applied.
The moniker can be obtained on executing the OpenPrxMeta operation.
The operation returns True if changes are applied successfully.
Below is the example of changing data slice dimension settings. The request contains moniker for working with dimension and dimension parameters to be changed. The response contains whether changes are applied successfully.
{
"SetPivotDimensionMetaData" :
{
"mon" : "S1!M!S!P1!DataArea!DataSources!1!DataSourceSlices!1!Pivot!PivotDims!116",
"tArg" :
{
"k" : "0",
"separated" : "1"
}
}
}
{
"SetPivotDimensionMetaDataResult" : "1"
}
public static bool SetPivotDimMetadata(string moniker, uint dataSourceKey, uint sliceKey, uint dimKey)
{
var somClient = new SomPortTypeClient(); //Proxy object for operation execution
//Operation execution parameters
var tSet = new SetPivotDimensionMetaData()
{
tArg = new PivotDimension()
{
separated = 1
},
mon = moniker + "!DataArea!DataSources!" + dataSourceKey.ToString() + "!DataSourceSlices!" + sliceKey.ToString() + "!Pivot!PivotDims!" + dimKey.ToString()
};
//Change dimension parameters
var result = somClient.SetPivotDimensionMetaData(tSet);
return result;
}
See also: