PivotDimension GetPivotDimensionMetaData(string mon, PivotDimension tArg)
mon. Moniker for working with data slice dimension.
tArg. Dimension parameters that should be obtained.
The GetPivotDimensionMetaData operation gets information about data slice dimension.
To execute the operation, in the mon field specify regular report instance moniker with the !DataSourceSlices!<slice key>!Pivot!PivotDims!<dimension key> postfix to work with dimension, and in the tArg field specify empty values or default values for the fields, which values should be obtained.
The moniker can be obtained on executing the OpenPrxMeta operation.
The operation returns obtained dimension parameters.
Below is the example of getting information about data slice dimension. The request contains moniker for working with dimension and a list of the fields, which values should be obtained. The response contains the obtained information.
{
"GetPivotDimensionMetaData" :
{
"mon" : "S1!M!S!P1!DataArea!DataSources!1!DataSourceSlices!1!Pivot!PivotDims!116",
"tArg" :
{
"k" : "0",
"id" : "",
"n" : "",
"position" : "Unknown",
"index" : "0",
"separated" : "0"
}
}
}
{
"GetPivotDimensionMetaDataResult" :
{
"k" : "116",
"id" : "DIM_1",
"n" : "Dim_1",
"position" : "Left",
"index" : "1",
"separated" : "1"
}
}
public static PivotDimension GetPivotDimMetadata(string moniker, ulong dataSourceKey, ulong sliceKey, ulong dimKey)
{
var somClient = new SomPortTypeClient(); //Proxy object for operation execution
//Operation execution parameters
var tGet = new GetPivotDimensionMetaData()
{
tArg = new PivotDimension()
{
id = "",
n = "",
index = new long(),
position = new PvtDimPos(),
separated = new int(),
},
mon = moniker + "!DataArea!DataSources!" + dataSourceKey.ToString() + "!DataSourceSlices!" + sliceKey.ToString() + "!Pivot!PivotDims!" + dimKey.ToString()
};
//Get information about dimension
var result = somClient.GetPivotDimensionMetaData(tGet);
return result;
}
See also: