PivotChangeDimHeader

Syntax

bool PivotChangeDimHeader(string mon, PivotChangeDimHeaderArg tArg)

Parameters

mon. Moniker for working with data slice dimension.

tArg. Parameters for changing dimension location.

Description

The PivotChangeDimHeader operation changes dimension location.

Comments

The operation changes the header, which contains the dimension. To execute the operation, in the mon field specify regular report instance moniker with the !DataArea!DataSources!<data source key>!DataSourceSlices!<slice key>!Pivot!PivotDims!<dimension key> postfix to work data slice dimension, and in the tArg.pos field specify the new header, to which the dimension should be moved.

The moniker can be obtained on executing the OpenPrxMeta operation. The dimensions list can be obtained using the GetPivotMetaData operation.

The operation returns True if dimension is moved successfully.

Example

Below is the example for changing data source dimension location in data slice. The request contains moniker for working with slice dimensions and type of the header, to which the dimension should be moved. The response contains whether the dimension is successfully moved.

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

<PivotChangeDimHeader xmlns="http://www.fsight.ru/PP.SOM.Som">

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

<tArg xmlns="">

  <pos>Left</pos>

  </tArg>

  </PivotChangeDimHeader>

  </s:Body>

  </s:Envelope>

SOAP response:

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

<soapenv:Body>

  <PivotChangeDimHeaderResult 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</PivotChangeDimHeaderResult>

  </soapenv:Body>

  </soapenv:Envelope>

JSON request:

{
 "PivotChangeDimHeader" : 
  {
   "mon" : "S1!M!S!P1!DataArea!DataSources!1!DataSourceSlices!1!Pivot!PivotDims!991",
   "tArg" : 
    {
     "pos" : "Left"
    }
  }
}

JSON response:

{
 "PivotChangeDimHeaderResult" : "1"
}

public static bool ChangeDimHeader(string moniker, ulong dataSourceKey, ulong sliceKey, ulong dimKey, PvtDimPos newDimPosition)
{
    var somClient = new SomPortTypeClient(); //Proxy object for operation execution
    //Operation execution parameters
    var tChange = new PivotChangeDimHeader()
    {
        tArg = new PivotChangeDimHeaderArg()
        {
            pos = newDimPosition
        },
        mon = moniker + "!DataArea!DataSources!" + dataSourceKey.ToString() + "!DataSourceSlices!" + sliceKey.ToString() + "!Pivot!PivotDims!" + dimKey.ToString()
    };
    //Change dimension location
    var result = somClient.PivotChangeDimHeader(tChange);
    return result;
}

See also:

Working with Regular Reports