SOAPНиже приведен пример использования операции SetCubeImport для настройки параметров объекта импорта в куб из кросс-таблицы. Источником кросс-таблицы является файл Microsoft Excel. В запросе передается содержимое файла и параметры идентификации кросс-таблицы. В ответе приходит информация об идентифицированных полях, их привязки к измерениям и фактам. Также будут получены первые десять строк преобразованной таблицы.
<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"><SetCubeImport xmlns="http://www.prognoz.ru/PP.SOM.Som"><tCubeImport xmlns=""><tArg xmlns=""><pattern><source><meta><source><props><unpivot><provider><props><excel><fixedCells><Item><parent isShortcut="false" isLink="false" hf="false"><createInfo><action><metaGet><source><rowsFilter><range><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"><soapenv:Body><SetCubeImportResult xmlns="http://www.prognoz.ru/PP.SOM.Som" xmlns:q1="http://www.prognoz.ru/PP.SOM.Som" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><id xmlns=""><meta xmlns=""><obInst><obDesc isShortcut="0" isLink="0" fullUrl="/"><dimBinds><its><it><fields><its><Item><Item><nameFields><factBinds><its><it><it><source><fields><its><it><it><it><it><it><it><rows><its><r><r><r><r><r><r><r><r><r><r>
{
"SetCubeImport" :
{
"tCubeImport" :
{
"id" : "S1!M!S!I1"
},
"tArg" :
{
"pattern" :
{
"obInst" : "true",
"source" :
{
"props" : "true"
},
"parent" : "true",
"createInfo" : "true",
"resultType" : "true"
},
"meta" :
{
"source" :
{
"props" :
{
"type" : "Unpivot",
"unpivot" :
{
"provider" :
{
"props" :
{
"type" : "Excel",
"fileContent" : "0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAPgADAP7\/CQAGAAAAAAAAAAAAAAABAAAANgAAAAAAAAAAEAAA\/v\/\/\/wAAAAD+\/\/\/\/AAAAADUAAAD\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/8JCBAAAAYFAFQ4zQfJwAEABgcAAOEAAgCwBMEAAgAAAOIAAABcAHAAFQAAU2VkdW5vdiwgQWxleGFuZGVyIE0uICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEIAAgCwBGEBAgAAAMABAAA9AQIAAQC6ARMACAABLQRCBDAEGgQ9BDgEMwQwBJwAAgARABkAAgAAABIAAgAAABMAAgAAAK8BAgAAALwBAgAAAD0AEgAAAAAAgHCTMDgAAAAAAAEAWAJAAAIAAACNAAIAAAAiAAIAAAAOAAIAAQC3AQIAAADaAAIAAAAxAB4A3AAAAAgAkAEAAAACzAAHAUMAYQBsAGkAYgByAGkAMQAeANwAAAAIAJABAAAAAswABwFDAGEAbABpAGIAcgBpADEAHgDcAAAACACQAQAAAALMAAcBQwBhAGwAaQBiAHIAaQAxAB4A3AAAAAgAkAEAAAACzAAHAUMAYQBsAGkAYgByAGkAMQAeANwAAAAIAJABAAAAAswABwFDAGEAbABpAGIAcgBpADEAHgDcAAAACQCQAQAAAALMAAcBQwBhAGwAaQBiAHIAaQAxAB4A3AAAAD4AkAEAAAACzAAHAUMAYQBsAGkAYgByAGkAMQAeANwAAQA\/ALwCAAAAAswABwFDAGEAbABpAGIAcgBpADEAHgDcAAEANAC8AgAAAALMAAcBQwBhAGwAaQBiAHIAaQAxAB4ALAEBADYAvAIAAAACzAAHAUMAYQBsAGkAYgByAGkAMQAeAAQBAQA2ALwCAAAAAswABwFDAGEAbABpAGIAcgBpADEAHgDcAAEANgC8AgAAAALMAAcBQwBhAGwAaQBiAHIAaQAxAB4A3AABAAgAvAIAAAACzAAHAUMAYQBsAGkAYgByAGkAMQAeANwAAQAJALwCAAAAAswABwFDAGEAbABpAGIAcgBpADEAKgBoAQAANgCQAQAAAALMAA0BQwBhAGwAaQBiAHIAaQAgAEwAaQBnAGgAdAAxAB4A3AAAADwAkAEAAAACzAAHAUMAYQBsAGkAYgByAGkAMQAeANwAAAAUAJABAAAAAswABwFDAGEAbABpAGIAcgBpADEAHgDcAAIAFwCQAQAAAALMAAcBQwBhAGwAaQBiAHIAaQAxAB4A3AAAADQAkAEAAAACzAAHAUMAYQBsAGkAYgByAGkAMQAeANwAAAAKAJABAAAAAswABwFDAGEAbABpAGIAcgBpADEAHgDcAAAAEQCQAQAAAALMAAcBQwBhAGwAaQBiAHIAaQAeBC8ABQAVAAEjACwAIwAjADAAIgBABC4AIgA7AFwALQAjACwAIwAjADAAIgBABC4AIgAeBDkABgAaAAEjACwAIwAjADAAIgBABC4AIgA7AFsAUgBlAGQAXQBcAC0AIwAsACMAIwAwACIAQAQuACIAHgQ7AAcAGwABIwAsACMAIwAwAC4AMAAwACIAQAQuACIAOwBcAC0AIwAsACMAIwAwAC4AMAAwACIAQAQuACIAHgRFAAgAIAABIwAsACMAIwAwAC4AMAAwACIAQAQuACIAOwBbAFIAZQBkAF0AXAAtACMALAAjACMAMAAuADAAMAAiAEAELgAiAB4EawAqADMAAV8ALQAqACAAIwAsACMAIwAwACIAQAQuACIAXwAtADsAXAAtACoAIAAjACwAIwAjADAAIgBABC4AIgBfAC0AOwBfAC0AKgAgACIALQAiACIAQAQuACIAXwAtADsAXwAtAEAAXwAtAB4EawApADMAAV8ALQAqACAAIwAsACMAIwAwAF8AQARfAC4AXwAtADsAXAAtACoAIAAjACwAIwAjADAAXwBABF8ALgBfAC0AOwBfAC0AKgAgACIALQAiAF8AQARfAC4AXwAtADsAXwAtAEAAXwAtAB4EewAsADsAAV8ALQAqACAAIwAsACMAIwAwAC4AMAAwACIAQAQuACIAXwAtADsAXAAtACoAIAAjACwAIwAjADAALgAwADAAIgBABC4AIgBfAC0AOwBfAC0AKgAgACIALQAiAD8APwAiAEAELgAiAF8ALQA7AF8ALQBAAF8ALQAeBHsAKwA7AAFfAC0AKgAgACMALAAjACMAMAAuADAAMABfAEAEXwAuAF8ALQA7AFwALQAqACAAIwAsACMAIwAwAC4AMAAwAF8AQARfAC4AXwAtADsAXwAtACoAIAAiAC0AIgA\/AD8AXwBABF8ALgBfAC0AOwBfAC0AQABfAC0AHgQ7AKQAGwABWwAkAC0ARgBDADEAOQBdAGQAXAAgAG0AbQBtAG0AXAAgAHkAeQB5AHkAXAAgACIAMwQuACIA4AAUAAAAAAD1\/yAAAAAAAAAAAAAAAMAg4AAUAAUAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAUAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAUAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAUAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAUAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAUAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAUAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAUAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAUAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAUAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAUAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAUAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAUAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAUAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAAAAAABACAAAAAAAAAAAAAAAsAg4AAUAAUAAAD1\/yAAALQAAAAAAAAABJsg4AAUAAUAAAD1\/yAAALQAAAAAAAAABK8g4AAUAAUAAAD1\/yAAALQAAAAAAAAABIkg4AAUAAUAAAD1\/yAAALQAAAAAAAAABJog4AAUAAUAAAD1\/yAAALQAAAAAAAAABJ8g4AAUAAUAAAD1\/yAAALQAAAAAAAAABKog4AAUAAUAAAD1\/yAAALQAAAAAAAAABKwg4AAUAAUAAAD1\/yAAALQAAAAAAAAABK8g4AAUAAUAAAD1\/yAAALQAAAAAAAAABJYg4AAUAAUAAAD1\/yAAALQAAAAAAAAABKsg4AAUAAUAAAD1\/yAAALQAAAAAAAAABKwg4AAUAAUAAAD1\/yAAALQAAAAAAAAABKsg4AAUAAYAAAD1\/yAAALQAAAAAAAAABKwg4AAUAAYAAAD1\/yAAALQAAAAAAAAABK8g4AAUAAYAAAD1\/yAAALQAAAAAAAAABJYg4AAUAAYAAAD1\/yAAALQAAAAAAAAABKsg4AAUAAYAAAD1\/yAAALQAAAAAAAAABLEg4AAUAAYAAAD1\/yAAALQAAAAAAAAABLkg4AAUAAYAAAD1\/yAAALQAAAAAAAAABLEg4AAUAAYAAAD1\/yAAALQAAAAAAAAABLUg4AAUAAYAAAD1\/yAAALQAAAAAAAAABLcg4AAUAAYAAAD1\/yAAALQAAAAAAAAABLMg4AAUAAYAAAD1\/yAAALQAAAAAAAAABL4g4AAUAAYAAAD1\/yAAALQAAAAAAAAABLkg4AAUAAcAAAD1\/yAAAJQREZcLlwsABK8g4AAUAAgAAAD1\/yAAAJQREb8fvx8ABJYg4AAUAAkAAAD1\/yAAAJQREZcLlwsABJYg4AAUAAUALAD1\/yAAAPgAAAAAAAAAAMAg4AAUAAUAKgD1\/yAAAPgAAAAAAAAAAMAg4AAUAAoAAAD1\/yAAANQAUAAAgBgAAMAg4AAUAAsAAAD1\/yAAANQAUAAAABYAAMAg4AAUAAwAAAD1\/yAAANQAIAAAABYAAMAg4AAUAAwAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAA0AAAD1\/yAAANQAYQAAsRgAAMAg4AAUAA4AAAD1\/yAAAJRmZr8fvx8ABLcg4AAUAA8AAAD1\/yAAAPQAAAAAAAAAAMAg4AAUABAAAAD1\/yAAALQAAAAAAAAABKsg4AAUABEAAAD1\/yAAALQAAAAAAAAABK0g4AAUABIAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAUAAAD1\/yAAAJwRERYLFgsABJog4AAUAAUACQD1\/yAAAPgAAAAAAAAAAMAg4AAUABMAAAD1\/yAAANQAYAAAABoAAMAg4AAUABQAAAD1\/yAAAPQAAAAAAAAAAMAg4AAUAAUAKwD1\/yAAAPgAAAAAAAAAAMAg4AAUAAUAKQD1\/yAAAPgAAAAAAAAAAMAg4AAUABUAAAD1\/yAAALQAAAAAAAAABKog4AAUAAAAAAABACAAAAQAAAAAAAAAAsAg4AAUAAAAAAABACIAABAAAAAAAAAAAsAgfAgUAHwIAAAAAAAAAAAAAAAAQAApyLxafQgtAH0IAAAAAAAAAAAAAAAAAAAAAAIADQAUAAMAAAABAAAAAG0AXAAgAHkOAAUAAn0ILQB9CAAAAAAAAAAAAAAAAAEAAAACAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAACAAAAAgANABQAAwAAAAEAAAAAbQBcACAAeQ4ABQACfQgtAH0IAAAAAAAAAAAAAAAAAwAAAAIADQAUAAMAAAABAAAAAG0AXAAgAHkOAAUAAn0ILQB9CAAAAAAAAAAAAAAAAAQAAAACAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAAFAAAAAgANABQAAwAAAAEAAAAAbQBcACAAeQ4ABQACfQgtAH0IAAAAAAAAAAAAAAAABgAAAAIADQAUAAMAAAABAAAAAG0AXAAgAHkOAAUAAn0ILQB9CAAAAAAAAAAAAAAAAAcAAAACAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAAIAAAAAgANABQAAwAAAAEAAAAAbQBcACAAeQ4ABQACfQgtAH0IAAAAAAAAAAAAAAAACQAAAAIADQAUAAMAAAABAAAAAG0AXAAgAHkOAAUAAn0ILQB9CAAAAAAAAAAAAAAAAAoAAAACAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAALAAAAAgANABQAAwAAAAEAAAAAbQBcACAAeQ4ABQACfQgtAH0IAAAAAAAAAAAAAAAADAAAAAIADQAUAAMAAAABAAAAAG0AXAAgAHkOAAUAAn0ILQB9CAAAAAAAAAAAAAAAAA0AAAACAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAAOAAAAAgANABQAAwAAAAEAAAAAbQBcACAAeQ4ABQACfQgtAH0IAAAAAAAAAAAAAAAADwAAAAIADQAUAAMAAAABAAAAAG0AXAAgAHkOAAUAAn0IQQB9CAAAAAAAAAAAAAAAABAAAAADAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAIEABQAAwBlZgQAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAABEAAAADAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAIEABQAAwBlZgUAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAABIAAAADAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAIEABQAAwBlZgYAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAABMAAAADAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAIEABQAAwBlZgcAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAABQAAAADAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAIEABQAAwBlZggAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAABUAAAADAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAIEABQAAwBlZgkAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAABYAAAADAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAIEABQAAwDMTAQAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAABcAAAADAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAIEABQAAwDMTAUAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAABgAAAADAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAIEABQAAwDMTAYAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAABkAAAADAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAIEABQAAwDMTAcAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAABoAAAADAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAIEABQAAwDMTAgAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAABsAAAADAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAIEABQAAwDMTAkAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAABwAAAADAA0AFAADAAAAAAAAAABtAFwAIAB5DgAFAAIEABQAAwAyMwQAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAAB0AAAADAA0AFAADAAAAAAAAAABtAFwAIAB5DgAFAAIEABQAAwAyMwUAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAAB4AAAADAA0AFAADAAAAAAAAAABtAFwAIAB5DgAFAAIEABQAAwAyMwYAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAAB8AAAADAA0AFAADAAAAAAAAAABtAFwAIAB5DgAFAAIEABQAAwAyMwcAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAACAAAAADAA0AFAADAAAAAAAAAABtAFwAIAB5DgAFAAIEABQAAwAyMwgAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAACEAAAADAA0AFAADAAAAAAAAAABtAFwAIAB5DgAFAAIEABQAAwAyMwkAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAACIAAAADAA0AFAADAAAAAAAAAABtAFwAIAB5DgAFAAIEABQAAwAAAAQAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAACMAAAADAA0AFAADAAAAAAAAAABtAFwAIAB5DgAFAAIEABQAAwAAAAUAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAACQAAAADAA0AFAADAAAAAAAAAABtAFwAIAB5DgAFAAIEABQAAwAAAAYAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAACUAAAADAA0AFAADAAAAAAAAAABtAFwAIAB5DgAFAAIEABQAAwAAAAcAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAACYAAAADAA0AFAADAAAAAAAAAABtAFwAIAB5DgAFAAIEABQAAwAAAAgAAAAiADAALgAwAH0IQQB9CAAAAAAAAAAAAAAAACcAAAADAA0AFAADAAAAAAAAAABtAFwAIAB5DgAFAAIEABQAAwAAAAkAAAAiADAALgAwAH0IkQB9CAAAAAAAAAAAAAAAACgAAAAHAA0AFAACAAAAPz92\/wBtAFwAIAB5DgAFAAIEABQAAgAAAP\/Mmf8iADAALgAwAAcAFAACAAAAf39\/\/y0AOwBfAC0ACAAUAAIAAAB\/f3\/\/PwBfAEAEXwAJABQAAgAAAH9\/f\/9AAF8ALQAAAAoAFAACAAAAf39\/\/wAAAAAAAAAAfQiRAH0IAAAAAAAAAAAAAAAAKQAAAAcADQAUAAIAAAA\/Pz\/\/AG0AXAAgAHkOAAUAAgQAFAACAAAA8vLy\/yIAMAAuADAABwAUAAIAAAA\/Pz\/\/LQA7AF8ALQAIABQAAgAAAD8\/P\/8\/AF8AQARfAAkAFAACAAAAPz8\/\/0AAXwAtAAAACgAUAAIAAAA\/Pz\/\/AAAAAAAAAAB9CJEAfQgAAAAAAAAAAAAAAAAqAAAABwANABQAAgAAAPp9AP8AbQBcACAAeQ4ABQACBAAUAAIAAADy8vL\/IgAwAC4AMAAHABQAAgAAAH9\/f\/8tADsAXwAtAAgAFAACAAAAf39\/\/z8AXwBABF8ACQAUAAIAAAB\/f3\/\/QABfAC0AAAAKABQAAgAAAH9\/f\/8AAAAAAAAAAH0ILQB9CAAAAAAAAAAAAAAAACsAAAACAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAAsAAAAAgANABQAAwAAAAEAAAAAbQBcACAAeQ4ABQACfQhBAH0IAAAAAAAAAAAAAAAALQAAAAMADQAUAAMAAAADAAAAAG0AXAAgAHkOAAUAAggAFAADAAAABAAAACIAMAAuADAAfQhBAH0IAAAAAAAAAAAAAAAALgAAAAMADQAUAAMAAAADAAAAAG0AXAAgAHkOAAUAAggAFAADAP8\/BAAAACIAMAAuADAAfQhBAH0IAAAAAAAAAAAAAAAALwAAAAMADQAUAAMAAAADAAAAAG0AXAAgAHkOAAUAAggAFAADADIzBAAAACIAMAAuADAAfQgtAH0IAAAAAAAAAAAAAAAAMAAAAAIADQAUAAMAAAADAAAAAG0AXAAgAHkOAAUAAn0IVQB9CAAAAAAAAAAAAAAAADEAAAAEAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAIHABQAAwAAAAQAAAAiADAALgAwAAgAFAADAAAABAAAAC0AOwBfAC0AfQiRAH0IAAAAAAAAAAAAAAAAMgAAAAcADQAUAAMAAAAAAAAAAG0AXAAgAHkOAAUAAgQAFAACAAAApaWl\/yIAMAAuADAABwAUAAIAAAA\/Pz\/\/LQA7AF8ALQAIABQAAgAAAD8\/P\/8\/AF8AQARfAAkAFAACAAAAPz8\/\/0AAXwAtAAAACgAUAAIAAAA\/Pz\/\/AAAAAAAAAAB9CC0AfQgAAAAAAAAAAAAAAAAzAAAAAgANABQAAwAAAAMAAAAAbQBcACAAeQ4ABQABfQhBAH0IAAAAAAAAAAAAAAAANAAAAAMADQAUAAIAAACcZQD\/AG0AXAAgAHkOAAUAAgQAFAACAAAA\/+uc\/yIAMAAuADAAfQhBAH0IAAAAAAAAAAAAAAAANQAAAAMADQAUAAIAAACcAAb\/AG0AXAAgAHkOAAUAAgQAFAACAAAA\/8fO\/yIAMAAuADAAfQgtAH0IAAAAAAAAAAAAAAAANgAAAAIADQAUAAIAAAB\/f3\/\/AG0AXAAgAHkOAAUAAn0IkQB9CAAAAAAAAAAAAAAAADcAAAAHAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAIEABQAAgAAAP\/\/zP8iADAALgAwAAcAFAACAAAAsrKy\/y0AOwBfAC0ACAAUAAIAAACysrL\/PwBfAEAEXwAJABQAAgAAALKysv9AAF8ALQAAAAoAFAACAAAAsrKy\/wAAAAAAAAAAfQgtAH0IAAAAAAAAAAAAAAAAOAAAAAIADQAUAAMAAAABAAAAAG0AXAAgAHkOAAUAAn0IQQB9CAAAAAAAAAAAAAAAADkAAAADAA0AFAACAAAA+n0A\/wBtAFwAIAB5DgAFAAIIABQAAgAAAP+AAf8iADAALgAwAH0ILQB9CAAAAAAAAAAAAAAAADoAAAACAA0AFAACAAAA\/wAA\/wBtAFwAIAB5DgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAA7AAAAAgANABQAAwAAAAEAAAAAbQBcACAAeQ4ABQACfQgtAH0IAAAAAAAAAAAAAAAAPAAAAAIADQAUAAMAAAABAAAAAG0AXAAgAHkOAAUAAn0IQQB9CAAAAAAAAAAAAAAAAD0AAAADAA0AFAACAAAAAGEA\/wBtAFwAIAB5DgAFAAIEABQAAgAAAMbvzv8iADAALgAwAH0ILQB9CAAAAAAAAAAAAAAAAD4AAAACAA0AFAADAAAAAQAAAABtAFwAIAB5DgAFAAJ9CC0AfQgAAAAAAAAAAAAAAAA\/AAAAAgANABQAAwAAAAEAAAAAbQBcACAAeQ4ABQACkwIfABAADQABMgAwACUAIAAUICAAMAQ6BEYENQQ9BEIEMQCSCE0AkggAAAAAAAAAAAAAAQQe\/w0AMgAwACUAIAAUICAAMAQ6BEYENQQ9BEIEMQAAAAMAAQAMAAcEZWbd6\/f\/BQAMAAcBAAAAAAD\/JQAFAAKTAh8AEQANAAEyADAAJQAgABQgIAAwBDoERgQ1BD0EQgQyAJIITQCSCAAAAAAAAAAAAAABBCL\/DQAyADAAJQAgABQgIAAwBDoERgQ1BD0EQgQyAAAAAwABAAwABwVlZvzk1v8FAAwABwEAAAAAAP8lAAUAApMCHwASAA0AATIAMAAlACAAFCAgADAEOgRGBDUEPQRCBDMAkghNAJIIAAAAAAAAAAAAAAEEJv8NADIAMAAlACAAFCAgADAEOgRGBDUEPQRCBDMAAAADAAEADAAHBmVm7e3t\/wUADAAHAQAAAAAA\/yUABQACkwIfABMADQABMgAwACUAIAAUICAAMAQ6BEYENQQ9BEIENACSCE0AkggAAAAAAAAAAAAAAQQq\/w0AMgAwACUAIAAUICAAMAQ6BEYENQQ9BEIENAAAAAMAAQAMAAcHZWb\/8sz\/BQAMAAcBAAAAAAD\/JQAFAAKTAh8AFAANAAEyADAAJQAgABQgIAAwBDoERgQ1BD0EQgQ1AJIITQCSCAAAAAAAAAAAAAABBC7\/DQAyADAAJQAgABQgIAAwBDoERgQ1BD0EQgQ1AAAAAwABAAwABwhlZtnh8v8FAAwABwEAAAAAAP8lAAUAApMCHwAVAA0AATIAMAAlACAAFCAgADAEOgRGBDUEPQRCBDYAkghNAJIIAAAAAAAAAAAAAAEEMv8NADIAMAAlACAAFCAgADAEOgRGBDUEPQRCBDYAAAADAAEADAAHCWVm4u\/a\/wUADAAHAQAAAAAA\/yUABQACkwIfABYADQABNAAwACUAIAAUICAAMAQ6BEYENQQ9BEIEMQCSCE0AkggAAAAAAAAAAAAAAQQf\/w0ANAAwACUAIAAUICAAMAQ6BEYENQQ9BEIEMQAAAAMAAQAMAAcEzEy91+7\/BQAMAAcBAAAAAAD\/JQAFAAKTAh8AFwANAAE0ADAAJQAgABQgIAAwBDoERgQ1BD0EQgQyAJIITQCSCAAAAAAAAAAAAAABBCP\/DQA0ADAAJQAgABQgIAAwBDoERgQ1BD0EQgQyAAAAAwABAAwABwXMTPjLrf8FAAwABwEAAAAAAP8lAAUAApMCHwAYAA0AATQAMAAlACAAFCAgADAEOgRGBDUEPQRCBDMAkghNAJIIAAAAAAAAAAAAAAEEJ\/8NADQAMAAlACAAFCAgADAEOgRGBDUEPQRCBDMAAAADAAEADAAHBsxM29vb\/wUADAAHAQAAAAAA\/yUABQACkwIfABkADQABNAAwACUAIAAUICAAMAQ6BEYENQQ9BEIENACSCE0AkggAAAAAAAAAAAAAAQQr\/w0ANAAwACUAIAAUICAAMAQ6BEYENQQ9BEIENAAAAAMAAQAMAAcHzEz\/5pn\/BQAMAAcBAAAAAAD\/JQAFAAKTAh8AGgANAAE0ADAAJQAgABQgIAAwBDoERgQ1BD0EQgQ1AJIITQCSCAAAAAAAAAAAAAABBC\/\/DQA0ADAAJQAgABQgIAAwBDoERgQ1BD0EQgQ1AAAAAwABAAwABwjMTLTG5\/8FAAwABwEAAAAAAP8lAAUAApMCHwAbAA0AATQAMAAlACAAFCAgADAEOgRGBDUEPQRCBDYAkghNAJIIAAAAAAAAAAAAAAEEM\/8NADQAMAAlACAAFCAgADAEOgRGBDUEPQRCBDYAAAADAAEADAAHCcxMxuC0\/wUADAAHAQAAAAAA\/yUABQACkwIfABwADQABNgAwACUAIAAUICAAMAQ6BEYENQQ9BEIEMQCSCE0AkggAAAAAAAAAAAAAAQQg\/w0ANgAwACUAIAAUICAAMAQ6BEYENQQ9BEIEMQAAAAMAAQAMAAcEMjObwub\/BQAMAAcAAAD\/\/\/\/\/JQAFAAKTAh8AHQANAAE2ADAAJQAgABQgIAAwBDoERgQ1BD0EQgQyAJIITQCSCAAAAAAAAAAAAAABBCT\/DQA2ADAAJQAgABQgIAAwBDoERgQ1BD0EQgQyAAAAAwABAAwABwUyM\/SwhP8FAAwABwAAAP\/\/\/\/8lAAUAApMCHwAeAA0AATYAMAAlACAAFCAgADAEOgRGBDUEPQRCBDMAkghNAJIIAAAAAAAAAAAAAAEEKP8NADYAMAAlACAAFCAgADAEOgRGBDUEPQRCBDMAAAADAAEADAAHBjIzycnJ\/wUADAAHAAAA\/\/\/\/\/yUABQACkwIfAB8ADQABNgAwACUAIAAUICAAMAQ6BEYENQQ9BEIENACSCE0AkggAAAAAAAAAAAAAAQQs\/w0ANgAwACUAIAAUICAAMAQ6BEYENQQ9BEIENAAAAAMAAQAMAAcHMjP\/2Wb\/BQAMAAcAAAD\/\/\/\/\/JQAFAAKTAh8AIAANAAE2ADAAJQAgABQgIAAwBDoERgQ1BD0EQgQ1AJIITQCSCAAAAAAAAAAAAAABBDD\/DQA2ADAAJQAgABQgIAAwBDoERgQ1BD0EQgQ1AAAAAwABAAwABwgyM46p2\/8FAAwABwAAAP\/\/\/\/8lAAUAApMCHwAhAA0AATYAMAAlACAAFCAgADAEOgRGBDUEPQRCBDYAkghNAJIIAAAAAAAAAAAAAAEENP8NADYAMAAlACAAFCAgADAEOgRGBDUEPQRCBDYAAAADAAEADAAHCTIzqdCO\/wUADAAHAAAA\/\/\/\/\/yUABQACkwITACIABwABEAQ6BEYENQQ9BEIEMQCSCEEAkggAAAAAAAAAAAAAAQQd\/wcAEAQ6BEYENQQ9BEIEMQAAAAMAAQAMAAcEAABbm9X\/BQAMAAcAAAD\/\/\/\/\/JQAFAAKTAhMAIwAHAAEQBDoERgQ1BD0EQgQyAJIIQQCSCAAAAAAAAAAAAAABBCH\/BwAQBDoERgQ1BD0EQgQyAAAAAwABAAwABwUAAO19Mf8FAAwABwAAAP\/\/\/\/8lAAUAApMCEwAkAAcAARAEOgRGBDUEPQRCBDMAkghBAJIIAAAAAAAAAAAAAAEEJf8HABAEOgRGBDUEPQRCBDMAAAADAAEADAAHBgAApaWl\/wUADAAHAAAA\/\/\/\/\/yUABQACkwITACUABwABEAQ6BEYENQQ9BEIENACSCEEAkggAAAAAAAAAAAAAAQQp\/wcAEAQ6BEYENQQ9BEIENAAAAAMAAQAMAAcHAAD\/wAD\/BQAMAAcAAAD\/\/\/\/\/JQAFAAKTAhMAJgAHAAEQBDoERgQ1BD0EQgQ1AJIIQQCSCAAAAAAAAAAAAAABBC3\/BwAQBDoERgQ1BD0EQgQ1AAAAAwABAAwABwgAAERyxP8FAAwABwAAAP\/\/\/\/8lAAUAApMCEwAnAAcAARAEOgRGBDUEPQRCBDYAkghBAJIIAAAAAAAAAAAAAAEEMf8HABAEOgRGBDUEPQRCBDYAAAADAAEADAAHCQAAcK1H\/wUADAAHAAAA\/\/\/\/\/yUABQACkwIPACgABQABEgQyBD4ENAQgAJIIdQCSCAAAAAAAAAAAAAABAhT\/BQASBDIEPgQ0BCAAAAAHAAEADAAF\/wAA\/8yZ\/wUADAAF\/wAAPz92\/yUABQACBgAOAAX\/AAB\/f3\/\/AQAHAA4ABf8AAH9\/f\/8BAAgADgAF\/wAAf39\/\/wEACQAOAAX\/AAB\/f3\/\/AQCTAg8AKQAFAAESBEsEMgQ+BDQEkgh1AJIIAAAAAAAAAAAAAAECFf8FABIESwQyBD4ENAQAAAcAAQAMAAX\/AADy8vL\/BQAMAAX\/AAA\/Pz\/\/JQAFAAIGAA4ABf8AAD8\/P\/8BAAcADgAF\/wAAPz8\/\/wEACAAOAAX\/AAA\/Pz\/\/AQAJAA4ABf8AAD8\/P\/8BAJMCGQAqAAoAARIESwRHBDgEQQQ7BDUEPQQ4BDUEkgh\/AJIIAAAAAAAAAAAAAAECFv8KABIESwRHBDgEQQQ7BDUEPQQ4BDUEAAAHAAEADAAF\/wAA8vLy\/wUADAAF\/wAA+n0A\/yUABQACBgAOAAX\/AAB\/f3\/\/AQAHAA4ABf8AAH9\/f\/8BAAgADgAF\/wAAf39\/\/wEACQAOAAX\/AAB\/f3\/\/AQCTAgQAK4AE\/5IIJgCSCAAAAAAAAAAAAAABBQT\/CAAUBDUEPQQ1BDYEPQRLBDkEAAAAAJMCBAAsgAf\/kgguAJIIAAAAAAAAAAAAAAEFB\/8MABQENQQ9BDUENgQ9BEsEOQQgAFsAMABdAAAAAACTAhsALQALAAEXBDAEMwQ+BDsEPgQyBD4EOgQgADEAkghLAJIIAAAAAAAAAAAAAAEDEP8LABcEMAQzBD4EOwQ+BDIEPgQ6BCAAMQAAAAMABQAMAAcDAABEVGr\/JQAFAAIHAA4ABwQAAFub1f8FAJMCGwAuAAsAARcEMAQzBD4EOwQ+BDIEPgQ6BCAAMgCSCEsAkggAAAAAAAAAAAAAAQMR\/wsAFwQwBDMEPgQ7BD4EMgQ+BDoEIAAyAAAAAwAFAAwABwMAAERUav8lAAUAAgcADgAHBP8\/rMzq\/wUAkwIbAC8ACwABFwQwBDMEPgQ7BD4EMgQ+BDoEIAAzAJIISwCSCAAAAAAAAAAAAAABAxL\/CwAXBDAEMwQ+BDsEPgQyBD4EOgQgADMAAAADAAUADAAHAwAARFRq\/yUABQACBwAOAAcEMjObwub\/AgCTAhsAMAALAAEXBDAEMwQ+BDsEPgQyBD4EOgQgADQAkgg9AJIIAAAAAAAAAAAAAAEDE\/8LABcEMAQzBD4EOwQ+BDIEPgQ6BCAANAAAAAIABQAMAAcDAABEVGr\/JQAFAAKTAg0AMQAEAAEYBEIEPgQzBJIISwCSCAAAAAAAAAAAAAABAxn\/BAAYBEIEPgQzBAAABAAFAAwABwEAAAAAAP8lAAUAAgYADgAHBAAAW5vV\/wEABwAOAAcEAABbm9X\/BgCTAikAMgASAAEaBD4EPQRCBEAEPgQ7BEwEPQQwBE8EIABPBEcENQQ5BDoEMASSCI8AkggAAAAAAAAAAAAAAQIX\/xIAGgQ+BD0EQgRABD4EOwRMBD0EMARPBCAATwRHBDUEOQQ6BDAEAAAHAAEADAAF\/wAApaWl\/wUADAAHAAAA\/\/\/\/\/yUABQACBgAOAAX\/AAA\/Pz\/\/BgAHAA4ABf8AAD8\/P\/8GAAgADgAF\/wAAPz8\/\/wYACQAOAAX\/AAA\/Pz\/\/BgCTAhUAMwAIAAEdBDAENwQyBDAEPQQ4BDUEkgg3AJIIAAAAAAAAAAAAAAEDD\/8IAB0EMAQ3BDIEMAQ9BDgENQQAAAIABQAMAAcDAABEVGr\/JQAFAAGTAhsANAALAAEdBDUEOQRCBEAEMAQ7BEwEPQRLBDkEkghJAJIIAAAAAAAAAAAAAAEBHP8LAB0ENQQ5BEIEQAQwBDsETAQ9BEsEOQQAAAMAAQAMAAX\/AAD\/65z\/BQAMAAX\/AACcZQD\/JQAFAAKTAgQAAIAA\/5IINQCSCAAAAAAAAAAAAAABAQD\/BwAeBDEESwRHBD0ESwQ5BAAAAgAFAAwABwEAAAAAAP8lAAUAApMCEQA1AAYAAR8EOwQ+BEUEPgQ5BJIIPwCSCAAAAAAAAAAAAAABARv\/BgAfBDsEPgRFBD4EOQQAAAMAAQAMAAX\/AAD\/x87\/BQAMAAX\/AACcAAb\/JQAFAAKTAhcANgAJAAEfBD4ETwRBBD0ENQQ9BDgENQSSCDkAkggAAAAAAAAAAAAAAQI1\/wkAHwQ+BE8EQQQ9BDUEPQQ4BDUEAAACAAUADAAF\/wAAf39\/\/yUABQACkwIZADcACgABHwRABDgEPAQ1BEcEMAQ9BDgENQSSCG4AkggAAAAAAAAAAAAAAQIK\/woAHwRABDgEPAQ1BEcEMAQ9BDgENQQAAAUAAQAMAAX\/AAD\/\/8z\/BgAOAAX\/AACysrL\/AQAHAA4ABf8AALKysv8BAAgADgAF\/wAAsrKy\/wEACQAOAAX\/AACysrL\/AQCTAgQAOIAF\/5IIKgCSCAAAAAAAAAAAAAABBQX\/CgAfBEAEPgRGBDUEPQRCBD0ESwQ5BAAAAACTAiUAOQAQAAEhBDIETwQ3BDAEPQQ9BDAETwQgAE8ERwQ1BDkEOgQwBJIIVQCSCAAAAAAAAAAAAAABAhj\/EAAhBDIETwQ3BDAEPQQ9BDAETwQgAE8ERwQ1BDkEOgQwBAAAAwAFAAwABf8AAPp9AP8lAAUAAgcADgAF\/wAA\/4AB\/wYAkwItADoAFAABIgQ1BDoEQQRCBCAAPwRABDUENARDBD8EQAQ1BDYENAQ1BD0EOARPBJIITwCSCAAAAAAAAAAAAAABAgv\/FAAiBDUEOgRBBEIEIAA\/BEAENQQ0BEMEPwRABDUENgQ0BDUEPQQ4BE8EAAACAAUADAAF\/wAA\/wAA\/yUABQACkwIEADuAA\/+SCCoAkggAAAAAAAAAAAAAAQUD\/woAJAQ4BD0EMAQ9BEEEPgQyBEsEOQQAAAAAkwIEADyABv+SCDIAkggAAAAAAAAAAAAAAQUG\/w4AJAQ4BD0EMAQ9BEEEPgQyBEsEOQQgAFsAMABdAAAAAACTAhMAPQAHAAElBD4EQAQ+BEgEOAQ5BJIIQQCSCAAAAAAAAAAAAAABARr\/BwAlBD4EQAQ+BEgEOAQ5BAAAAwABAAwABf8AAMbvzv8FAAwABf8AAABhAP8lAAUAAo4IWACOCAAAAAAAAAAAAACQAAAAEQARAFQAYQBiAGwAZQBTAHQAeQBsAGUATQBlAGQAaQB1AG0AMgBQAGkAdgBvAHQAUwB0AHkAbABlAEwAaQBnAGgAdAAxADYAYAECAAAAhQAMAGE\/AAAAAAQARGF0YZoIGACaCAAAAAAAAAAAAAABAAAAAAAAAAEAAACjCBAAowgAAAAAAAAAAAAAAAAAAIwABAAHAAcAwQEIAMEBAAC\/UwIA\/ABoAAkAAAAJAAAACwAAUmVmdW5kLCBVU0QZAABSZWZ1bmQgKGJhZCBxdWFsaXR5KSwgVVNEBQAAMjAwMWEFAAAyMDAyYQUAADIwMDNhBQAAMjAwNGEFAAAyMDA1YQUAAFZlciAxAwAAQkNB\/wASAAgAODIAAAwAAACSMgAAZgAAAGMIFgBjCAAAAAAAAAAAAAAWAAAAAAAAAAIAlghpDJYIAAAAAAAAAAAAAIZWAgBQSwMEFAAGAAgAAAAhAOneD7\/\/AAAAHAIAABMAAABbQ29udGVudF9UeXBlc10ueG1srJHLTsMwEEX3SPyD5S1KnLJACCXpgseOx6J8wMiZJBbJ2LKnVfv3TNJUQqggFmws2TP3njvjcr0fB7XDmJynSq\/yQisk6xtHXaXfN0\/ZrVaJgRoYPGGlD5j0ur68KDeHgEmJmlKle+ZwZ0yyPY6Qch+QpNL6OALLNXYmgP2ADs11UdwY64mROOPJQ9flA7awHVg97uX5mCTikLS6PzZOrEpDCIOzwJLU7Kj5RskWQi7KuSf1LqQriaHNWcJU+Rmw6F5lNdE1qN4g8guMEsOwDIlfz2cgGS3mvzueiezb1llsvN2Oso58Nl7MTsH\/FGD1P+gT08x\/W38CAAD\/\/wMAUEsDBBQABgAIAAAAIQCl1qfnwAAAADYBAAALAAAAX3JlbHMvLnJlbHOEj89qwzAMh++FvYPRfVHSwxgldi+lkEMvo30A4Sh\/aCIb2xvr20\/HBgq7CISk7\/epPf6ui\/nhlOcgFpqqBsPiQz\/LaOF2Pb9\/gsmFpKclCFt4cIaje9u1X7xQ0aM8zTEbpUi2MJUSD4jZT7xSrkJk0ckQ0kpF2zRiJH+nkXFf1x+YnhngNkzT9RZS1zdgro+oyf+zwzDMnk\/Bf68s5UUEbjeUTGnkYqGoL+NTvZCoZarUHtC1uPnW\/QEAAP\/\/AwBQSwMEFAAGAAgAAAAhAGt5lhaDAAAAigAAABwAAAB0aGVtZS90aGVtZS90aGVtZU1hbmFnZXIueG1sDMxNCsMgEEDhfaF3kNk3Y7soRWKyy6679gBDnBpBx6DSn9vX5eODN87fFNWbSw1ZLJwHDYplzS6It\/B8LKcbqNpIHMUsbOHHFebpeBjJtI0T30nIc1F9I9WQha213SDWtSvVIe8s3V65JGo9i0dX6NP3KeJF6ysmCgI4\/QEAAP\/\/AwBQSwMEFAAGAAgAAAAhAOPGPQDhBgAAwRoAABYAAAB0aGVtZS90aGVtZS90aGVtZTEueG1s7FndbhtFFL5H4h1We+\/6b9c\/UZ3KXtstNGmr2i3q5dgee6eZ3bV2xkmtqlKVXiKBEAVxgwTccIGASC3iJn2H9BkCRVCkvgJnZtfrGXtC0qgXBTWRkvX4O2e+Oefsd2Z3Ll66F1BrF8eMRGHDLl4o2BYOh9GIhJOGfavfzdVsi3EUjhCNQtyw55jZlzbff+8i2uA+DrAF9iHbQA3b53y6kc+zIQwjdiGa4hC+G0dxgDh8jCf5UYz2wG9A86VCoZIPEAltK0QBuD367uiXo8OjA+v6eEyG2N5c+O9QmCTkTAwMadwT3vHC6Nvn+0cHR8+Onh4dPH8I18\/g\/6fSdrRTFBZszjwaW7uINmyYehTt9fE9blsUMQ5fNOyC\/LHzmxfzaCM1ovwEW8WuK39Su9RgtFOSc8aTQTap47hOpZn5lwDK13GdaqfSqWT+JAANh7DyhIvq023VW203xSqg5NLgu11tl4saXvFfXuPcdMWvhpegxL+zhu92PYiihpegBO+u4R2nWvIcDS9BCb6yhq8Wmm2nquElyKck3FlDF9xK2VusNoOMI3rFCK+7TrdaSp0vUVANWbWJKcZRyM9aewG6G8VdMBCGFHESWnw+xWM0hEL3ECWDmFhbZOJDIU5RGDEYLpQK3UIZ\/opfR17JCKENjBRrwROYsbUhwc9iw5hMecP+ELzaCuTV4Y+vDp9Yrw4PjvefHu\/\/evzo0fH+z4kvzfAKCieq4cvvP\/v764fWX0++efn4CzOeqfjff\/r4t2efm4Gw2GUUXnx58MfTgxdfffLnD48N8GaMBiq8TwLMrGt4z7oZBbA2GQWdOR7Er2fR9xHRLJAPvg2uO9zXgNfmiJpwLawH73YMgmMCXp7d1bj2\/HjGiWHmq36gAbejiLai2BiAq2IuJcL9WTgxTx7PVNxNhHZNc3so1FLbmU1BeYnJpedjjeYNikKOJjjE3BLfRTsYG1Z3hxAtrttkGEcsGnPrDrFaiBhD0icDrZCWRldIAHmZmwhCqrXYbN+2WhE1rbqNd3Uk3BCIGsj3MdXCeBnNOApMLvsooGrAtxD3TSR783io4jqMQ6YnmEZWZ4QZM9lcj2G9StKvgriY075N54GOjDnZMfncQlGkItvRjuejYGrC9kjoq9gP2A6UKLJuRNwE3470O0R8hjyg8MR03yZYS\/fpQnALdFWltCwQ8c0sNuTyMo60+u3N6RhhqTLQBjQ1D0h4qrSviLr7TtSTrrQq6s2YGG+tKytSfhLuPyjgbTQLb2C4Z9Yb2Dv9fqff9v9ev0+6l9+8ai+FGjRcbBWT3bvcywdn3sqPCaU9Pqd4i8ndPIN2NerCoPAjn3Rx9qg39eFS3NkwoYabxEjaWHHEPyLc7\/loClv+oi2cTFjqesKsacTgSUAOG30LPJ0F29EoeaItFsXTayImDPHleMHNxuHpgyfoSnX5lJa5l2wn8ul6QUDYvg4JZTKdRNlAoroYFEGSz\/IQNAMJubI3wqJuYFET7hepWmMB1LKswH7Kgl1Yw3YdMAEjeMhCFI9EnpJUL7Irk\/kmM31SMLUKgM3FogKWma4LricuT6wuKbUzZFojoZSbTkJGRvY05qMRTqtTjJ6Fxuvmur5MqUZPhELOB6W1pFGt\/RuL8+Ya7Fa1gYaqUtDQ2mvYlbILJTNE04Y9hjcBcBlMoXaY2AcjOoE3bkMeJzf8eZRlGjPeRsxPAi5FJ1GDgHAcW5QEDVssP0sDDaWGSG7FEgjCW0uuDrLytpGDpOtJxuMxHnI17cqIiHTyERQ+0Qrjt9L8\/GBhGc0g3T1\/tGcN6Cy+iaDE3GpRBHBEGLwQKibRHBF445kJ2bL+VhpTKrvqK0dZQ8k4olMfpR1FFfMELqU8oyM\/ZTFQPqVrhoAqIUkb4WAiGqwaVK2bZl0j4XBi1z3dSEROEc1lz9RURXRNs4ppMyzawEosz9fkFVaLEIOmqR0+ke5Vya0vtG5ln5B1CQh4Fj9D1z1DQ1CoLSfTqAnG6zIsNDsd1XvHYoGnUDtLk1BUv7JwuxK3rEcYp4PBc3V+sFutWhgaL\/aZMtLytEQ9zYgGd0E82vBeeEY5k6mEs4kYwYaoJ\/ckiWzALXKPp7cGXFmzmDTs+wW36Xgl18sVam4n55SdQq7mNsu5puuWix23WGi3Sg+gsXA\/KLrJSU0X3k\/ReXpeI8fXzmyCxSu4C8MoyEfyKCYvicszm2JJO7NJjmqsvjiRsS0ConO\/UurWy\/VWJVcvN7s5p92q5epepZVrV7xqu9v23Fq9+8C2diXYaZY9p9Kp5SpFz8s5lYKgX6vnqk6p1HSqzVrHaT5ItzGw8kQ+0lhAeCWvzX8AAAD\/\/wMAUEsDBBQABgAIAAAAIQAN0ZCftgAAABsBAAAnAAAAdGhlbWUvdGhlbWUvX3JlbHMvdGhlbWVNYW5hZ2VyLnhtbC5yZWxzhI9NCsIwFIT3gncIb2\/TuhCRJt2I0K3UA4TkNQ02PyRR7O0NriwILodhvplpu5edyRNjMt4xaKoaCDrplXGawW247I5AUhZOidk7ZLBggo5vN+0VZ5FLKE0mJFIoLjGYcg4nSpOc0IpU+YCuOKOPVuQio6ZByLvQSPd1faDxmwF8xSS9YhB71QAZllCa\/7P9OBqJZy8fFl3+UUFz2YUFKKLGzOAjm6pMBMpburrE3wAAAP\/\/AwBQSwECLQAUAAYACAAAACEA6d4Pv\/8AAAAcAgAAEwAAAAAAAAAAAAAAAAAAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQItABQABgAIAAAAIQCl1qfnwAAAADYBAAALAAAAAAAAAAAAAAAAADABAABfcmVscy8ucmVsc1BLAQItABQABgAIAAAAIQBreZYWgwAAAIoAAAAcAAAAAAAAAAAAAAAAABkCAAB0aGVtZS90aGVtZS90aGVtZU1hbmFnZXIueG1sUEsBAi0AFAAGAAgAAAAhAOPGPQDhBgAAwRoAABYAAAAAAAAAAAAAAAAA1gIAAHRoZW1lL3RoZW1lL3RoZW1lMS54bWxQSwECLQAUAAYACAAAACEADdGQn7YAAAAbAQAAJwAAAAAAAAAAAAAAAADrCQAAdGhlbWUvdGhlbWUvX3JlbHMvdGhlbWVNYW5hZ2VyLnhtbC5yZWxzUEsFBgAAAAAFAAUAXQEAAOYKAAAAAJsIEACbCAAAAAAAAAAAAAABAAAAjAgQAIwIAAAAAAAAAAAAAAAAAAAKAAAACQgQAAAGEABUOM0HycABAAYHAAALAhQAAAAAAAAAAAAEAAAADUcAAA1JAAANAAIAAQAMAAIAZAAPAAIAAQARAAIAAAAQAAgA\/Knx0k1iUD9fAAIAAQAqAAIAAAArAAIAAACCAAIAAQCAAAgAAAAAAAAAAAAlAgQAAAAsAYEAAgDBBBQAAAAVAAAAgwACAAAAhAACAAAAJgAIAGZmZmZmZuY\/JwAIAGZmZmZmZuY\/KAAIAAAAAAAAAOg\/KQAIAAAAAAAAAOg\/TQCSBgAAQQBkAG8AYgBlACAAUABEAEYAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEEAAbcALQFU++AAQEACQCaCzQIZAABAA8AsAQCAAEAsAQDAAEAQQA0AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAAAAAABAAAAAgAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFBSSVZCIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAYAAAAAAAQJxAnECcAABAnAAAAAAAAAACwAIQDAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAwAAAAAAAAAwAhAAUDQDACiIBAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAARkaf8gUAAAAEAAAA\/wD\/AAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAAAAAAAAAACwAAAAU01USgAAAAAQAKAAQQBkAG8AYgBlACAAUABEAEYAIABDAG8AbgB2AGUAcgB0AGUAcgAAAFJlc29sdXRpb24AMTIwMGRwaQBQYWdlU2l6ZQBMZXR0ZXIAUGFnZVJlZ2lvbgAATGVhZGluZ0VkZ2UAAElucHV0U2xvdABPbmx5T25lAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADACAABFQkRBAAABAAEAAAABAAAAAQAAAAEAAAAAAAAAUwB0AGEAbgBkAGEAcgBkAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAAAoQAiAAkAZAABAAEAAQACALAEsAQzMzMzMzPTPzMzMzMzM9M\/AQCcCCYAnAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADwzAAAAAAAAAABVAAIACAB9AAwAAAABACQYDwAGAAAAfQAMAAIACgAkCg8ABgAAAAACDgAAAAAABAAAAAAADAAAAAgCEAAAAAAADAAsAQAAAAAAAQ8ACAIQAAEAAAAMACwBAAAAAAABDwAIAhAAAgAAAAwALAEAAAAAAAEPAAgCEAADAAAADAAsAQAAAAAAAQ8A\/QAKAAAAAAAPAAcAAAD9AAoAAAACAD8ACAAAAL4AGAAAAAMAPwA\/AD8APwA\/AD8APwA\/AD8ACwB+AgoAAQACAD4AAESfQP0ACgABAAMAPgACAAAAfgIKAAEABAA+AABIn0D9AAoAAQAFAD4AAwAAAH4CCgABAAYAPgAATJ9A\/QAKAAEABwA+AAQAAAB+AgoAAQAIAD4AAFCfQP0ACgABAAkAPgAFAAAAfgIKAAEACgA+AABUn0D9AAoAAQALAD4ABgAAAP0ACgACAAEADwAAAAAAvQBCAAIAAgAPAACgkkAPAAAQgUAPAAAgjEAPAAC4lEAPAADsl0APAADYkEAPAAAolkAPAACokUAPAAAogUAPAADcnEALAP0ACgADAAEADwABAAAAvQA8AAMAAgAPAKFm40APAADAZkAPAADAckAPAACge0APACHr6EAPAKGL4UAPAGEU50APAGFk4kAPAADgZkAKAAMCDgADAAsADwCPwvUoXD2DQNcADADIAQAAPAA4AIwAVAA+AhIAtgYAAAAAQAAAAAAAAABcPQAAiwgQAIsIAAAAAAAAAAAAAAAAWj0dAA8AAwAAAgAAAAEAAAAAAAIL5QAKAAEAAAAAAAIACwC6AQ0ABQABGwQ4BEEEQgQxAGcIFwBnCAAAAAAAAAAAAAACAAH\/\/\/\/\/A0QAAAoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP7\/AAAGAQIAAAAAAAAAAAAAAAAAAAAAAAEAAADghZ\/y+U9oEKuRCAArJ7PZMAAAAMAAAAAHAAAAAQAAAEAAAAAEAAAASAAAAAgAAABoAAAAEgAAAIgAAAAMAAAAoAAAAA0AAACsAAAAEwAAALgAAAACAAAA4wQAAB4AAAAYAAAAU2VkdW5vdiwgQWxleGFuZGVyIE0uAAAAHgAAABgAAABTZWR1bm92LCBBbGV4YW5kZXIgTS4AAAAeAAAAEAAAAE1pY3Jvc29mdCBFeGNlbABAAAAAAK2UWcSH0AFAAAAAgIOz\/syH0AEDAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAD+\/wAABgECAAAAAAAAAAAAAAAAAAAAAAABAAAAAtXN1ZwuGxCTlwgAKyz5rjAAAAC8AAAACQAAAAEAAABQAAAADwAAAFgAAAAXAAAAZAAAAAsAAABsAAAAEAAAAHQAAAATAAAAfAAAABYAAACEAAAADQAAAIwAAAAMAAAAnQAAAAIAAADjBAAAHgAAAAQAAAAAAAAAAwAAAAAADwALAAAAAAAAAAsAAAAAAAAACwAAAAAAAAALAAAAAAAAAB4QAAABAAAABQAAAERhdGEADBAAAAIAAAAeAAAABgAAAMvo8fL7AAMAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAIAAAADAAAABAAAAAUAAAAGAAAABwAAAAgAAAAJAAAACgAAAAsAAAAMAAAADQAAAA4AAAAPAAAAEAAAABEAAAASAAAAEwAAABQAAAAVAAAAFgAAABcAAAAYAAAAGQAAABoAAAAbAAAAHAAAAB0AAAAeAAAAHwAAACAAAAAhAAAAIgAAACMAAAAkAAAA\/v\/\/\/yYAAAAnAAAAKAAAACkAAAAqAAAAKwAAACwAAAD+\/\/\/\/LgAAAC8AAAAwAAAAMQAAADIAAAAzAAAANAAAAP7\/\/\/\/9\/\/\/\/\/v\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/9SAG8AbwB0ACAARQBuAHQAcgB5AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAFgAFAf\/\/\/\/\/\/\/\/\/\/AgAAACAIAgAAAAAAwAAAAAAAAEYAAAAAAAAAAAAAAACAvtx74YfQAf7\/\/\/8AAAAAAAAAAFcAbwByAGsAYgBvAG8AawAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAASAAIB\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAJhJAAAAAAAABQBTAHUAbQBtAGEAcgB5AEkAbgBmAG8AcgBtAGEAdABpAG8AbgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACgAAgEBAAAAAwAAAP\/\/\/\/8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAlAAAAABAAAAAAAAAFAEQAbwBjAHUAbQBlAG4AdABTAHUAbQBtAGEAcgB5AEkAbgBmAG8AcgBtAGEAdABpAG8AbgAAAAAAAAAAAAAAOAACAf\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/wAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAC0AAAAAEAAAAAAAAA==",
"excel" :
{
"hasHeader" : "false",
"query" : "Data",
"imexMode" : "Import"
}
}
},
"leftBegin" : "1",
"leftEnd" : "1",
"headTop" : "0",
"headBottom" : "1",
"headColumn" : "0",
"dataTop" : "2",
"dataWidth" : "2",
"dataRight" : "11",
"dataBottom" : "3",
"fixedCells" :
{
"Item" :
{
"row" : "0",
"column" : "0"
}
}
}
}
},
"parent" :
{
"@isShortcut" : "false",
"@isLink" : "false",
"@hf" : "false",
"i" : "FORNEWCUBE",
"n" : "Для новых кубов",
"k" : "5881",
"c" : "0",
"p" : "4294967295",
"h" : "false"
},
"createInfo" :
{
"name" : "Куб(данные из кросс-таблицы)",
"id" : ""
},
"resultType" : "Cube"
},
"action" :
{
"initBinds" : "true"
},
"metaGet" :
{
"obInst" : "true",
"dimBinds" : "true",
"factBinds" : "true",
"source" :
{
"fields" : "true",
"rows" : "true",
"rowsFilter" :
{
"range" :
{
"start" : "0",
"count" : "10"
}
}
}
}
}
}
}
{
"SetCubeImportResult" :
{
"id" :
{
"id" : "S1!M!S!I1"
},
"meta" :
{
"obInst" :
{
"obDesc" :
{
"@fullUrl" : "\/",
"@isShortcut" : "0",
"@isLink" : "0",
"i" : "FORNEWCUBE",
"n" : "Для новых кубов",
"k" : "5881",
"c" : "0",
"p" : "5845",
"h" : "0",
"isPermanent" : "1",
"isTemp" : "0"
}
},
"dimBinds" :
{
"its" :
{
"it" :
[
{
"sourceField" : "FIELD1",
"fields" :
{
"its" :
{
"Item" :
[
{
"name" : "FIELD1",
"attributeId" : "NAME",
"identifying" : "1"
},
{
"name" : "FIELD2",
"attributeId" : "",
"identifying" : "1"
}
]
}
},
"newDictionaryName" : "",
"nameFields" :
{
"its" : ""
},
"skipLoad" : "0"
}
]
}
},
"factBinds" :
{
"its" :
{
"it" :
[
{
"sourceField" : "FIELD4",
"newElementName" : ""
},
{
"sourceField" : "FIELD5",
"newElementName" : ""
}
]
},
"newDictionaryName" : ""
},
"source" :
{
"fields" :
{
"its" :
{
"it" :
[
{
"k" : "1",
"id" : "FIELD0",
"n" : "FIELD0",
"vis" : "1",
"dt" : "1",
"size" : "255",
"precision" : "0",
"expression" : "",
"calculated" : "0"
},
{
"k" : "2",
"id" : "FIELD1",
"n" : "FIELD1",
"vis" : "1",
"dt" : "1",
"size" : "255",
"precision" : "0",
"expression" : "",
"calculated" : "0"
},
{
"k" : "3",
"id" : "FIELD2",
"n" : "FIELD2",
"vis" : "1",
"dt" : "1",
"size" : "255",
"precision" : "0",
"expression" : "",
"calculated" : "0"
},
{
"k" : "4",
"id" : "FIELD3",
"n" : "FIELD3",
"vis" : "1",
"dt" : "1",
"size" : "255",
"precision" : "0",
"expression" : "",
"calculated" : "0"
},
{
"k" : "5",
"id" : "FIELD4",
"n" : "FIELD4",
"vis" : "1",
"dt" : "1",
"size" : "255",
"precision" : "0",
"expression" : "",
"calculated" : "0"
},
{
"k" : "6",
"id" : "FIELD5",
"n" : "FIELD5",
"vis" : "1",
"dt" : "1",
"size" : "255",
"precision" : "0",
"expression" : "",
"calculated" : "0"
}
]
}
},
"rows" :
{
"its" :
{
"r" :
[
{
"it" :
[
"Refund, USD",
"",
"2001",
"Ver 1",
"1192",
"546"
]
},
{
"it" :
[
"Refund, USD",
"",
"2002",
"Ver 1",
"900",
"1326"
]
},
{
"it" :
[
"Refund, USD",
"",
"2003",
"Ver 1",
"1531",
"1078"
]
},
{
"it" :
[
"Refund, USD",
"",
"2004",
"Ver 1",
"1418",
"1130"
]
},
{
"it" :
[
"Refund, USD",
"",
"2005",
"Ver 1",
"549",
"1847"
]
},
{
"it" :
[
"Refund (bad quality), USD",
"",
"2001",
"Ver 1",
"397,33",
"182"
]
},
{
"it" :
[
"Refund (bad quality), USD",
"",
"2002",
"Ver 1",
"300",
"442"
]
},
{
"it" :
[
"Refund (bad quality), USD",
"",
"2003",
"Ver 1",
"510,33",
"359,33"
]
},
{
"it" :
[
"Refund (bad quality), USD",
"",
"2004",
"Ver 1",
"472,67",
"376,67"
]
},
{
"it" :
[
"Refund (bad quality), USD",
"",
"2005",
"Ver 1",
"183",
"615,67"
]
}
]
}
}
}
}
}
}
Указанная ниже функция SetImportParamsFromCrossTabke задает параметры объекта импорта для загрузки данных из кросс-таблицы. Моникеры соединения с репозиторием и объекта импорта данных в куб передаются в качестве входных параметров. В примере используется функция FindObjectById, код которой приведен в примере «Получение описания объекта по его идентификатору». Результат выполнения операции является результатом выполнения функции.
public static SetCubeImportResult SetImportParamsFromCrossTable(MbId mb, CubeImportId moniker)
{
var somClient = new SomPortTypeClient(); //Прокси-объект для выполнения операций
//Параметры выполнения операции
var tSet = new SetCubeImport()
{
tArg = new SetCubeImportArg()
{
action = new CubeImportAction()
{
initBinds = true
},
meta = new CubeImportMd()
{
createInfo = new ObjectCreateBaseInfo()
{
name = "Куб(данные из кросс-таблицы)",
id = string.Empty
},
parent = FindObjectById(mb, "FORNEWCUBE"),
resultType = CubeImportResultType.Cube,
source = new DtProviderMd()
{
props = new DtProviderProps()
{
type = DtProviderType.Unpivot,
unpivot = new DtProviderUnpivot()
{
provider = new DtProviderMd()
{
props = new DtProviderProps()
{
type = DtProviderType.Excel,
fileContent = File.ReadAllBytes(@"D:\Work\Data\Data_CrossTable.xls"),
excel = new DtExcelProvider()
{
imexMode = DtExcelImexMode.Import,
hasHeader = false,
query = "Data"
}
}
},
leftBegin = 1,
leftEnd = 1,
headTop = 0,
headBottom = 1,
headColumn = 0,
dataTop = 2,
dataWidth = 2,
dataRight = 11,
dataBottom = 3,
fixedCells = new DtProviderUnpivotFixedCell[]
{
new DtProviderUnpivotFixedCell() {row = 0, column = 0}
}
}
}
}
},
pattern = new CubeImportMdPattern()
{
createInfo = true,
parent = true,
resultType = true,
source = new DtProviderMdPattern()
{
props = true
}
},
metaGet = new CubeImportMdPattern()
{
dimBinds = true,
factBinds = true,
source = new DtProviderMdPattern()
{
fields = true,
rows = true,
rowsFilter = new ListFilter()
{
range = new ListRange()
{
start = 0, count = 10
}
},
}
}
},
tCubeImport = moniker
};
//Установка параметров объекта импорта
var result = somClient.SetCubeImport(tSet);
return result;
}
См. также: