SOAP-запрос:
<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"><DashboardMetaModelSetField xmlns="http://www.fsight.ru/PP.SOM.Som"> <mon xmlns="">NFMKBILODHLHGOAEEMDGPNMDJGAKAAMELJFNJPGHEPMBHHLK!M!S!PKNLLKMLODHLHGOAEJAPGCGKOLOPBOAAEMILBMOPALDPBFKNH!MetaModels!1</mon>
<tArg xmlns=""> <key>5</key>
<position>0</position>
<type>Row</type>
<fieldType>0</fieldType>
<isAdd>true</isAdd>
<aggregation>Sum</aggregation>
</tArg>
</DashboardMetaModelSetField>
</s:Body>
</s:Envelope>
SOAP-ответ:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><DashboardMetaModelSetFieldResult 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"> <k xmlns="">1</k>
<columnFields xmlns=""><its><it> <k>1</k>
<aggregation>Max</aggregation>
<calendarAggregations> <its />
</calendarAggregations>
<inGroup>0</inGroup>
<external>0</external>
<dimKey>461181</dimKey>
<customFormat />
<implicit>0</implicit>
<isValid>0</isValid>
<fieldType>0</fieldType>
<fieldKey>2</fieldKey>
<dependentFact />
<dimensionType>Dimension</dimensionType>
<dataType>1</dataType>
<factElement>-1</factElement>
</it>
</its>
</columnFields>
<rowFields xmlns=""><its><it> <k>4</k>
<aggregation>Max</aggregation>
<calendarAggregations> <its />
</calendarAggregations>
<inGroup>0</inGroup>
<external>0</external>
<dimKey>-1</dimKey>
<customFormat />
<implicit>0</implicit>
<isValid>0</isValid>
<fieldType>0</fieldType>
<fieldKey>5</fieldKey>
<dependentFact />
<dimensionType>Dimension</dimensionType>
<dataType>1</dataType>
<factElement>-1</factElement>
</it>
<it> <k>2</k>
<aggregation>Max</aggregation>
<calendarAggregations> <its />
</calendarAggregations>
<inGroup>0</inGroup>
<external>0</external>
<dimKey>461183</dimKey>
<customFormat />
<implicit>0</implicit>
<isValid>0</isValid>
<fieldType>0</fieldType>
<fieldKey>4</fieldKey>
<dependentFact />
<dimensionType>Dimension</dimensionType>
<dataType>1</dataType>
<factElement>-1</factElement>
</it>
</its>
</rowFields>
<factFields xmlns=""><its><it> <k>3</k>
<aggregation>Sum</aggregation>
<calendarAggregations> <its />
</calendarAggregations>
<inGroup>1</inGroup>
<external>0</external>
<dimKey>461179</dimKey>
<customFormat />
<implicit>0</implicit>
<isValid>0</isValid>
<fieldType>0</fieldType>
<fieldKey>1</fieldKey>
<dependentFact />
<dimensionType>Fact</dimensionType>
<dataType>2</dataType>
<factElement>0</factElement>
</it>
</its>
</factFields>
<filterFields xmlns=""> <its />
</filterFields>
</DashboardMetaModelSetFieldResult>
</soapenv:Body>
</soapenv:Envelope>
JSON-запрос:
{
"DashboardMetaModelSetField" :
{
"mon" : "NFMKBILODHLHGOAEEMDGPNMDJGAKAAMELJFNJPGHEPMBHHLK!M!S!PKNLLKMLODHLHGOAEJAPGCGKOLOPBOAAEMILBMOPALDPBFKNH!MetaModels!1",
"tArg" :
{
"key" : "5",
"position" : "0",
"type" : "Row",
"fieldType" : "0",
"isAdd" : "true",
"aggregation" : "Sum"
}
}
}
JSON-ответ:
{
"DashboardMetaModelSetFieldResult" :
{
"k" : "1",
"columnFields" :
{
"its" :
{
"it" :
[
{
"k" : "1",
"aggregation" : "Max",
"calendarAggregations" :
{
"its" : ""
},
"inGroup" : "0",
"external" : "0",
"dimKey" : "461181",
"customFormat" : "",
"implicit" : "0",
"isValid" : "0",
"fieldType" : "0",
"fieldKey" : "2",
"dependentFact" : "",
"dimensionType" : "Dimension",
"dataType" : "1",
"factElement" : "4294967295"
}
]
}
},
"rowFields" :
{
"its" :
{
"it" :
[
{
"k" : "4",
"aggregation" : "Max",
"calendarAggregations" :
{
"its" : ""
},
"inGroup" : "0",
"external" : "0",
"dimKey" : "-1",
"customFormat" : "",
"implicit" : "0",
"isValid" : "0",
"fieldType" : "0",
"fieldKey" : "5",
"dependentFact" : "",
"dimensionType" : "Dimension",
"dataType" : "1",
"factElement" : "4294967295"
},
{
"k" : "2",
"aggregation" : "Max",
"calendarAggregations" :
{
"its" : ""
},
"inGroup" : "0",
"external" : "0",
"dimKey" : "461183",
"customFormat" : "",
"implicit" : "0",
"isValid" : "0",
"fieldType" : "0",
"fieldKey" : "4",
"dependentFact" : "",
"dimensionType" : "Dimension",
"dataType" : "1",
"factElement" : "4294967295"
}
]
}
},
"factFields" :
{
"its" :
{
"it" :
[
{
"k" : "3",
"aggregation" : "Sum",
"calendarAggregations" :
{
"its" : ""
},
"inGroup" : "1",
"external" : "0",
"dimKey" : "461179",
"customFormat" : "",
"implicit" : "0",
"isValid" : "0",
"fieldType" : "0",
"fieldKey" : "1",
"dependentFact" : "",
"dimensionType" : "Fact",
"dataType" : "2",
"factElement" : "0"
}
]
}
},
"filterFields" :
{
"its" : ""
}
}
}
public static DashboardMetaModel DashboardMetaModelSetField(string moniker, uint visKey, uint fieldKey)
{
var somClient = new SomPortTypeClient(); // Прокси-объект для выполнения операций
// Параметры выполнения операции
var tSet = new DashboardMetaModelSetField()
{
tArg = new DashboardMetaModelSetFieldArg()
{
key = fieldKey,
fieldType = 0,
aggregation = CubeFactBindingAggregationType.Sum,
isAdd = true,
position = 0,
type = SomSemanticLayerFieldHeaderType.Row
},
mon = moniker + "!MetaModels!" + visKey
};
// Добавление поля источника в метамодель
var result = somClient.DashboardMetaModelSetField(tSet);
return result;
}