GetPivotDimLevelMetaData

Syntax

PivotDimensionLevel GetPivotDimLevelMetaData(string mon, PivotDimensionLevel tArg)

Parameters

mon. Moniker for working with data slice dimension level.

tArg. Dimension level parameters that should be obtained.

Description

The GetPivotDimLevelMetaData operation gets information about data slice dimension level.

Comments

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!DimLvls!level key postfix to work with a level, 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 level parameters.

Example

Below is the example of getting information about data slice dimension level. The request contains moniker for working with level and a list of the fields, which values should be obtained. The response contains the obtained information.

SOAP request:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<GetPivotDimLevelMetaData xmlns="http://www.fsight.ru/PP.SOM.Som">
  <mon xmlns="">S1!M!S!P1!DataArea!DataSources!1!DataSourceSlices!1!Pivot!PivotDims!116!DimLvls!1</mon>
<tArg xmlns="">
  <k>0</k>
  <id />
  <n />
  <separated>0</separated>
  </tArg>
  </GetPivotDimLevelMetaData>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<GetPivotDimLevelMetaDataResult xmlns="http://www.fsight.ru/PP.SOM.Som" xmlns:q1="http://www.fsight.ru/PP.SOM.Som" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <k xmlns="">0</k>
  <id xmlns="" />
  <n xmlns="" />
  <separated xmlns="">1</separated>
  </GetPivotDimLevelMetaDataResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
"GetPivotDimLevelMetaData" :
{
"mon" : "S1!M!S!P1!DataArea!DataSources!1!DataSourceSlices!1!Pivot!PivotDims!116!DimLvls!1",
"tArg" :
{
"k" : "0",
"id" : "",
"n" : "",
"separated" : "0"
}
}
}

JSON response:

{
"GetPivotDimLevelMetaDataResult" :
{
"k" : "0",
"id" : "",
"n" : "",
"separated" : "1"
}
}
public static PivotDimensionLevel GetPivotDimLevelMetadata(string moniker, uint dataSourceKey, uint sliceKey, uint dimKey, uint lvlKey)
{
var somClient = new SomPortTypeClient(); //Proxy object for operation execution
//Operation execution parameters
var tGet = new GetPivotDimLevelMetaData()
{
tArg = new PivotDimensionLevel()
{
id = "",
n = "",
separated = new int()
},
mon = moniker + "!DataArea!DataSources!" + dataSourceKey.ToString() + "!DataSourceSlices!" + sliceKey.ToString() + "!Pivot!PivotDims!" + dimKey.ToString() + "!DimLvls!" + lvlKey.ToString()
};
//Get information about dimension level
var result = somClient.GetPivotDimLevelMetaData(tGet);
return result;
}

See also:

Working With Regular Reports