SetPivotDimLevelMetaData

Syntax

bool SetPivotDimLevelMetaData(string mon, PivotDimensionLevel tArg)

Parameters

mon. Moniker for working with data slice dimension level.

tArg. Dimension level parameters that should be applied.

Description

The SetPivotDimLevelMetaData operation changes data slice dimension level parameters.

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> poostfix to work with level, and in the tArg field specify level parameters that should be applied.

The moniker can be obtained on executing the OpenPrxMeta operation.

The operation returns True if changes are applied successfully.

Example

Below is the example for changing data slice dimension level settings. The request contains moniker for working with dimension level and changeable level parameters. The response contains whether changes are applied successfully.

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">
<SetPivotDimLevelMetaData 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>
  <separated>1</separated>
  </tArg>
  </SetPivotDimLevelMetaData>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
  <SetPivotDimLevelMetaDataResult 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">1</SetPivotDimLevelMetaDataResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

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

JSON response:

{
 "SetPivotDimLevelMetaDataResult" : "1"
}
public static bool SetPivotDimLevelMetadata(string moniker, uint dataSourceKey, uint sliceKey, uint dimKey, uint lvlKey)
{
    var somClient = new SomPortTypeClient(); //Proxy object for operation execution
    //Operation execution parameters
    var tSet = new SetPivotDimLevelMetaData()
    {
        tArg = new PivotDimensionLevel()
        {
            separated = 1
        },
        mon = moniker + "!DataArea!DataSources!" + dataSourceKey.ToString() + "!DataSourceSlices!" + sliceKey.ToString() + "!Pivot!PivotDims!" + dimKey.ToString() + "!DimLvls!" + lvlKey.ToString()
    };
    //Change dimension level parameters
    var result = somClient.SetPivotDimLevelMetaData(tSet);
    return result;
}

See also:

Working With Regular Reports