GetPivotDimensionSettingsExMetaData

Syntax

PivotDimensionSettingsEx GetPivotDimensionSettingsExMetaData(string mon, PivotDimensionSettingsEx tArg)

Parameters

mon. Moniker for working with data slice dimension.

tArg. Dimension advanced settings that should be obtained.

Description

The GetPivotDimensionSettingsExMetaData operation gets 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 empty values or default values for the fields, which values should be obtained. The moniker can be obtained on executing the OpenPrxMeta operation.

The operation will return the obtained dimension settings.

Example

Below is the example of getting advanced settings of data slice dimension. The request contains dimension moniker and the list of settings, which values should be obtained. The response contains the obtained values.

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">
<GetPivotDimensionSettingsExMetaData 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>false</MergeTopDown>
  <IsDimensionMergeAllowed>false</IsDimensionMergeAllowed>
  </tArg>
  </GetPivotDimensionSettingsExMetaData>
  </s:Body>
  </s:Envelope>

SOAP response:

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

JSON request:

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

JSON response:

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

See also:

Working with Regular Reports