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"><SetCalculatedCubeFormulas xmlns="http://www.fsight.ru/PP.SOM.Som"><tCube xmlns=""> <id>S1!M!S!C1</id>
</tCube>
<tArg xmlns=""><its><it><dimIds><its><it><dimId> <id>S1!M!S!S2</id>
</dimId>
</it>
<it><dimId> <id>S1!M!S!S3</id>
</dimId>
</it>
<it><dimId> <id>S1!M!S!S4</id>
</dimId>
</it>
</its>
</dimIds>
<formulas><formula><its><it> <expression>CUBE_SOURCE[0,0,7]</expression>
</it>
</its>
</formula>
</formulas>
</it>
</its>
</tArg>
</SetCalculatedCubeFormulas>
</s:Body>
</s:Envelope>
SOAP response:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body> <SetCalculatedCubeFormulasResult 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</SetCalculatedCubeFormulasResult>
</soapenv:Body>
</soapenv:Envelope>
JSON request:
{
"SetCalculatedCubeFormulas" :
{
"tCube" :
{
"id" : "S1!M!S!C1"
},
"tArg" :
{
"its" :
{
"it" :
[
{
"dimIds" :
{
"its" :
{
"it" :
[
{
"dimId" :
{
"id" : "S1!M!S!S2"
}
},
{
"dimId" :
{
"id" : "S1!M!S!S3"
}
},
{
"dimId" :
{
"id" : "S1!M!S!S4"
}
}
]
}
},
"formulas" :
{
"formula" :
[
{
"its" :
{
"it" :
[
{
"expression" : "CUBE_SOURCE[0,0,7]"
}
]
}
}
]
}
}
]
}
}
}
}
JSON response:
{
"SetCalculatedCubeFormulasResult" : "1"
}
public static bool SetCalcCubeFormulas(CubeId moniker, OpenId[] dimMonikers)
{
var somClient = new SomPortTypeClient(); //Proxy object for operation execution
//Operation execution parameters
var tSet = new SetCalculatedCubeFormulas()
{
tArg = new SetCalculatedCubeFormulasRes()
{
its = new GetCalculatedCubeCoordFormula[]
{
new GetCalculatedCubeCoordFormula()
{
dimIds = new OpenIds()
{
its = dimMonikers
},
formulas = new CalculatedCubeFormulas()
{
formula = new CltCubeFormulas()
{
its = new CalculatedCubeFormula[]
{
new CalculatedCubeFormula()
{
expression = "CUBE_SOURCE[0,0,7]"
}
}
}
}
}
}
},
tCube = moniker
};
//Change calculated cube formulas
var result = somClient.SetCalculatedCubeFormulas(tSet);
return result;
}