SetPivotDimLevelMetaData: Operation

The SetPivotDimLevelMetaData operation changes data slice dimension level parameters.

Comments

To execute the operation, in the mon field specify regular report instance moniker with the !DataSourceSlices!<slice key>!Pivot!PivotDims!<dimension key>!DimLvls!<level key> postfix for working with level, and in the tArg field specify level parameters that should be applied.

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 indicates whether changes are applied successfully.

SOAP JSONC#

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">

<mon xmlns="">S1!M!S!P1!DataArea!DataSources!1!DataSourceSlices!1!Pivot!PivotDims!116!DimLvls!1</mon>

</tArg>

</SetPivotDimLevelMetaData>

</s:Body>

</s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

</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, ulong dataSourceKey, ulong sliceKey, ulong dimKey, ulong 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;
}

SetPivotDimLevelMetaData

Syntax