SetPivotDimensionSettingsExMetaData

Syntax

bool SetPivotDimensionSettingsExMetaData(string mon, PivotDimensionSettingsEx tArg)

Parameters

mon. Moniker for working with data slice dimension.

tArg. Dimension advanced settings that should be changed.

Description

The SetPivotDimensionSettingsExMetaData operation changes advanced settings of data slice dimension.

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!Settings postfix to work with dimension settings, and in the tArg field specify the settings to be determined. The moniker can be obtained on executing the OpenPrxMeta operation.

The operation results in the logical True if the settings were changed successfully.

Example

Below is the example of changing data advanced settings of data slice dimension. The request contains dimension moniker and determines whether the dimension should be combined with the previous one and selected elements should be tucked. The response contains whether the settings were 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">
<SetPivotDimensionSettingsExMetaData xmlns="http://www.fsight.ru/PP.SOM.Som">
  <mon xmlns="">OKOJDJGKNIENFOAEJNJLKGEKADFPDGEEGJGOMBCJJOBOMJEF!M!S!PBAJILOGKNIENFOAEONEKNMNEGGHGMDBEPLLMLDOJNKGLFFDF!DataArea!DataSources!3!DataSourceSlices!3!Pivot!PivotDims!991!Settings</mon>
<tArg xmlns="">
  <MergeTopDown>true</MergeTopDown>
  <IsDimensionMergeAllowed>true</IsDimensionMergeAllowed>
  </tArg>
  </SetPivotDimensionSettingsExMetaData>
  </s:Body>
  </s:Envelope>

SOAP response:

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

JSON request:

{
"SetPivotDimensionSettingsExMetaData" :
{
"mon" : "OKOJDJGKNIENFOAEJNJLKGEKADFPDGEEGJGOMBCJJOBOMJEF!M!S!PBAJILOGKNIENFOAEONEKNMNEGGHGMDBEPLLMLDOJNKGLFFDF!DataArea!DataSources!3!DataSourceSlices!3!Pivot!PivotDims!991!Settings",
"tArg" :
{
"MergeTopDown" : "true",
"IsDimensionMergeAllowed" : "true"
}
}
}

JSON response:

{
"SetPivotDimensionSettingsExMetaDataResult" : "1"
}
public static bool SetPivotDimensionSettingsExMetaData(string moniker, uint dataSourceKey, uint sliceKey, uint dimKey)
{
var somClient = new SomPortTypeClient(); // Proxy object for operation execution
// Operation execution parameters
var tSet = new SetPivotDimensionSettingsExMetaData()
{
tArg = new PivotDimensionSettingsEx()
{
IsDimensionMergeAllowed = true,
MergeTopDown = true
},
mon = moniker + "!DataArea!DataSources!" + dataSourceKey.ToString() + "!DataSourceSlices!" + sliceKey.ToString() + "!Pivot!PivotDims!" + dimKey.ToString() + "!Settings"
};
// Change dimension settings
var result = somClient.SetPivotDimensionSettingsExMetaData(tSet);
return result;
}

See also:

Working with Regular Reports