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 moniker instance with the !DataArea!DataSources!<source key>!DataSourceSlices!<silce key>!Pivot!PivotDims!<dimension> postfix to work with a data slice, and in the tArg.pos field specify a new header, to which the dimension should be moved.

The moniker can be obtained after 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 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, uint dataSourceKey, uint sliceKey, uint 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