Getting Information about Cube Structure

Below is the example of using the GetCube operation to get information about cube structure. The request contains moniker of opened cube instance and the pattern indicating whether all the information on the cube structure must be obtained. The response contains requested information.

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">
<GetCube xmlns="http://www.fsight.ru/PP.SOM.Som">
<tCube xmlns="">
  <id>S1!M!S!C1</id>
  </tCube>
<tArg xmlns="">
<pattern>
  <obInst>true</obInst>
  <all>true</all>
  </pattern>
  </tArg>
  </GetCube>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<GetCubeResult 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">
<id xmlns="">
  <id>S1!M!S!C1</id>
  </id>
<meta xmlns="">
<obInst>
<obDesc ds="" isShortcut="0" isLink="0" ver="34" hf="0">
  <i>STD_CUBE</i>
  <n>Cube</n>
  <k>5857</k>
  <c>1281</c>
  <p>5845</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  <isPermanent>1</isPermanent>
  <isTemp>0</isTemp>
  </obDesc>
  </obInst>
  <dirty>0</dirty>
<dims>
<its>
<it>
  <k>5858</k>
  <id>FACTS</id>
  <n>Facts</n>
  <vis>1</vis>
<obDesc ds="" isShortcut="0" isLink="0" ver="34" hf="0">
  <i>FACTS</i>
  <n>Facts</n>
  <k>5858</k>
  <c>1028</c>
  <p>5857</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  </obDesc>
  <aggsPresent>0</aggsPresent>
  <hierAggsPresent>0</hierAggsPresent>
  </it>
<it>
  <k>112</k>
  <id>CALENDAR</id>
  <n>Calendar</n>
  <vis>1</vis>
<obDesc ds="" isShortcut="0" isLink="0" ver="8" hf="0">
  <i>CALENDAR</i>
  <n>Calendar</n>
  <k>112</k>
  <c>1026</c>
  <p>103</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  </obDesc>
  <aggsPresent>0</aggsPresent>
  <hierAggsPresent>0</hierAggsPresent>
  </it>
<it>
  <k>116</k>
  <id>DIM_1</id>
  <n>Dim_1</n>
  <vis>1</vis>
<obDesc ds="" isShortcut="0" isLink="0" ver="3" hf="0">
  <i>DIM_1</i>
  <n>Dim_1</n>
  <k>116</k>
  <c>1025</c>
  <p>103</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  </obDesc>
  <aggsPresent>0</aggsPresent>
  <hierAggsPresent>0</hierAggsPresent>
  </it>
<it>
  <k>991</k>
  <id>DIM_2</id>
  <n>Dim_2</n>
  <vis>1</vis>
<obDesc ds="" isShortcut="0" isLink="0" ver="1" hf="0">
  <i>DIM_2</i>
  <n>Dim_2</n>
  <k>991</k>
  <c>1025</c>
  <p>10529</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  </obDesc>
  <aggsPresent>0</aggsPresent>
  <hierAggsPresent>0</hierAggsPresent>
  </it>
  </its>
  </dims>
<dests>
<its>
<it>
  <k>1</k>
  <id>STD_CUBE</id>
  <n>Cube</n>
  <vis>1</vis>
  <isDefault>1</isDefault>
  <hideTrivialFactDimension>0</hideTrivialFactDimension>
  <selSetOriginalOnly>0</selSetOriginalOnly>
  <useMultiAttrTable>0</useMultiAttrTable>
<datasets>
<its>
<it>
  <k>5878</k>
  <id>OBJ5877</id>
  <n>Table</n>
  <vis>1</vis>
  <aggrType>Server</aggrType>
  <useSubqueryOptimization>1</useSubqueryOptimization>
  </it>
  </its>
  </datasets>
<dims>
<its>
<it>
  <k>5858</k>
  <id>FACTS</id>
  <n>Facts</n>
  <vis>1</vis>
<obDesc ds="" isShortcut="0" isLink="0" ver="34" hf="0">
  <i>FACTS</i>
  <n>Facts</n>
  <k>5858</k>
  <c>1028</c>
  <p>5857</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  </obDesc>
  <aggsPresent>0</aggsPresent>
  <hierAggsPresent>0</hierAggsPresent>
  </it>
<it>
  <k>112</k>
  <id>CALENDAR</id>
  <n>Calendar</n>
  <vis>1</vis>
<obDesc ds="" isShortcut="0" isLink="0" ver="8" hf="0">
  <i>CALENDAR</i>
  <n>Calendar</n>
  <k>112</k>
  <c>1026</c>
  <p>103</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  </obDesc>
<aggs>
<its>
<it>
  <k>-1</k>
  <id>CHRONOLOGICALMATRIXAGGREGATOR</id>
  <n>Chronological aggregator</n>
  <vis>1</vis>
  <factKey>1</factKey>
  <isChrono>1</isChrono>
<operations>
<its>
<it>
  <k>0</k>
  <n>No</n>
  </it>
<it>
  <k>1</k>
  <n>Chronological average</n>
  </it>
<it>
  <k>2</k>
  <n>Uniform disaggregation</n>
  </it>
  </its>
  </operations>
<chronoAggregator>
<defaultLevelAggregation>
  <k>-1</k>
  <vis>1</vis>
  <includeChildren>1</includeChildren>
  <useDefaultLevelAggregation>0</useDefaultLevelAggregation>
  <operation>None</operation>
  <resultToSourceLevel>1</resultToSourceLevel>
  <resultToThisLevel>1</resultToThisLevel>
  </defaultLevelAggregation>
<dimLevelsAggregators>
<its>
<it>
  <k>2</k>
  <id>HALF_YEARS</id>
  <n>Half-years</n>
  <vis>1</vis>
  <includeChildren>0</includeChildren>
  <useDefaultLevelAggregation>0</useDefaultLevelAggregation>
  <operation>UniformDisaggregation</operation>
<sourceLevel>
  <k>1</k>
  <id>YEARS</id>
  <n>Years</n>
  <vis>1</vis>
  </sourceLevel>
  <resultToSourceLevel>1</resultToSourceLevel>
  <resultToThisLevel>0</resultToThisLevel>
  </it>
  </its>
  </dimLevelsAggregators>
  <levelAggsPresent>1</levelAggsPresent>
  </chronoAggregator>
  </it>
  </its>
  </aggs>
  <aggsPresent>1</aggsPresent>
  <hierAggsPresent>0</hierAggsPresent>
  </it>
<it>
  <k>116</k>
  <id>DIM_1</id>
  <n>Dim_1</n>
  <vis>1</vis>
<obDesc ds="" isShortcut="0" isLink="0" ver="3" hf="0">
  <i>DIM_1</i>
  <n>Dim_1</n>
  <k>116</k>
  <c>1025</c>
  <p>103</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  </obDesc>
  <aggsPresent>0</aggsPresent>
  <hierAggsPresent>0</hierAggsPresent>
  </it>
<it>
  <k>991</k>
  <id>DIM_2</id>
  <n>Dim_2</n>
  <vis>1</vis>
<obDesc ds="" isShortcut="0" isLink="0" ver="1" hf="0">
  <i>DIM_2</i>
  <n>Dim_2</n>
  <k>991</k>
  <c>1025</c>
  <p>10529</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  </obDesc>
  <aggsPresent>0</aggsPresent>
  <hierAggsPresent>0</hierAggsPresent>
  </it>
  </its>
  </dims>
<dimBinds>
<its>
<it>
  <dimKey>5858</dimKey>
<datasets>
<it>
  <dsKey>5878</dsKey>
  </it>
  </datasets>
  </it>
<it>
  <dimKey>112</dimKey>
<datasets>
<it>
  <dsKey>5878</dsKey>
  <indexKey>7</indexKey>
  <indexBlockKey>3</indexBlockKey>
<attrs>
<it>
  <attrKey>2</attrKey>
  <fieldId>V_DATE</fieldId>
  <formula>OBJ5877.V_DATE</formula>
  </it>
  </attrs>
  </it>
  </datasets>
  </it>
<it>
  <dimKey>116</dimKey>
<datasets>
<it>
  <dsKey>5878</dsKey>
  <indexKey>121</indexKey>
  <indexBlockKey>120</indexBlockKey>
<attrs>
<it>
  <attrKey>118</attrKey>
  <fieldId>DIM1_ID</fieldId>
  <formula>OBJ5877.DIM1_ID</formula>
  </it>
  </attrs>
  </it>
  </datasets>
  </it>
<it>
  <dimKey>991</dimKey>
<datasets>
<it>
  <dsKey>5878</dsKey>
  <indexKey>1001</indexKey>
  <indexBlockKey>1000</indexBlockKey>
<attrs>
<it>
  <attrKey>993</attrKey>
  <fieldId>DIM2_ID</fieldId>
  <formula>OBJ5877.DIM2_ID</formula>
  </it>
  </attrs>
  </it>
  </datasets>
  </it>
  </its>
  </dimBinds>
<factBinds>
<its>
<it>
  <factKey>1</factKey>
  <dsKey>5878</dsKey>
  <formula>OBJ5877.VALUE</formula>
  <aggrType>None</aggrType>
  </it>
<it>
  <factKey>1</factKey>
  <dsKey>5878</dsKey>
  <formula />
  <aggrType>None</aggrType>
  </it>
  </its>
  </factBinds>
<calcBinds>
<its>
<it>
  <factKey>1</factKey>
  <formula />
  <revFactKey />
  <revFormula />
  <timeLagLevel>None</timeLagLevel>
  <timeForwardLag>0</timeForwardLag>
  <timeBackwardLag>0</timeBackwardLag>
  <includeInSelection>0</includeInSelection>
  <calcMethod>BySelection</calcMethod>
  </it>
<it>
  <factKey>1</factKey>
  <formula />
  <revFactKey />
  <revFormula />
  <timeLagLevel>None</timeLagLevel>
  <timeForwardLag>0</timeForwardLag>
  <timeBackwardLag>0</timeBackwardLag>
  <includeInSelection>0</includeInSelection>
  <calcMethod>ByMatrix</calcMethod>
  </it>
  </its>
  </calcBinds>
<relations>
  <its />
  </relations>
<selControl>
  <its />
  <options />
  <isEmpty>1</isEmpty>
  </selControl>
  </it>
  </its>
  </dests>
<selControl>
  <its />
  <options />
  <isEmpty>1</isEmpty>
  </selControl>
  <supportsRub>0</supportsRub>
  <validationAssertions />
  </meta>
  </GetCubeResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
"GetCube" :
{
"tCube" :
{
"id" : "S1!M!S!C1"
},
"tArg" :
{
"pattern" :
{
"obInst" : "true",
"all" : "true"
}
}
}
}

JSON response:

{
"GetCubeResult" :
{
"id" :
{
"id" : "S1!M!S!C1"
},
"meta" :
{
"obInst" :
{
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "34",
"@hf" : "0",
"i" : "STD_CUBE",
"n" : "Cube",
"k" : "5857",
"c" : "1281",
"p" : "5845",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0",
"isPermanent" : "1",
"isTemp" : "0"
}
},
"dirty" : "0",
"dims" :
{
"its" :
{
"it" :
[
{
"k" : "5858",
"id" : "FACTS",
"n" : "Facts",
"vis" : "1",
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "34",
"@hf" : "0",
"i" : "FACTS",
"n" : "Facts",
"k" : "5858",
"c" : "1028",
"p" : "5857",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0"
},
"aggsPresent" : "0",
"hierAggsPresent" : "0"
},
{
"k" : "112",
"id" : "CALENDAR",
"n" : "Calendar",
"vis" : "1",
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "8",
"@hf" : "0",
"i" : "CALENDAR",
"n" : "Calendar",
"k" : "112",
"c" : "1026",
"p" : "103",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0"
},
"aggsPresent" : "0",
"hierAggsPresent" : "0"
},
{
"k" : "116",
"id" : "DIM_1",
"n" : "Dim_1",
"vis" : "1",
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "3",
"@hf" : "0",
"i" : "DIM_1",
"n" : "Dim_1",
"k" : "116",
"c" : "1025",
"p" : "103",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0"
},
"aggsPresent" : "0",
"hierAggsPresent" : "0"
},
{
"k" : "991",
"id" : "DIM_2",
"n" : "Dim_2",
"vis" : "1",
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "1",
"@hf" : "0",
"i" : "DIM_2",
"n" : "Dim_2",
"k" : "991",
"c" : "1025",
"p" : "10529",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0"
},
"aggsPresent" : "0",
"hierAggsPresent" : "0"
}
]
}
},
"dests" :
{
"its" :
{
"it" :
[
{
"k" : "1",
"id" : "STD_CUBE",
"n" : "Cube",
"vis" : "1",
"isDefault" : "1",
"hideTrivialFactDimension" : "0",
"selSetOriginalOnly" : "0",
"useMultiAttrTable" : "0",
"datasets" :
{
"its" :
{
"it" :
[
{
"k" : "5878",
"id" : "OBJ5877",
"n" : "Table",
"vis" : "1",
"aggrType" : "Server",
"useSubqueryOptimization" : "1"
}
]
}
},
"dims" :
{
"its" :
{
"it" :
[
{
"k" : "5858",
"id" : "FACTS",
"n" : "Facts",
"vis" : "1",
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "34",
"@hf" : "0",
"i" : "FACTS",
"n" : "Facts",
"k" : "5858",
"c" : "1028",
"p" : "5857",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0"
},
"aggsPresent" : "0",
"hierAggsPresent" : "0"
},
{
"k" : "112",
"id" : "CALENDAR",
"n" : "Calendar",
"vis" : "1",
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "8",
"@hf" : "0",
"i" : "CALENDAR",
"n" : "Calendar",
"k" : "112",
"c" : "1026",
"p" : "103",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0"
},
"aggs" :
{
"its" :
{
"it" :
[
{
"k" : "4294967295",
"id" : "CHRONOLOGICALMATRIXAGGREGATOR",
"n" : "Chronological aggregator",
"vis" : "1",
"factKey" : "1",
"isChrono" : "1",
"operations" :
{
"its" :
{
"it" :
[
{
"k" : "0",
"n" : "No"
},
{
"k" : "1",
"n" : "Chronological average"
},
{
"k" : "2",
"n" : "Uniform disaggregation"
}
]
}
},
"chronoAggregator" :
{
"defaultLevelAggregation" :
{
"k" : "4294967295",
"vis" : "1",
"includeChildren" : "1",
"useDefaultLevelAggregation" : "0",
"operation" : "None",
"resultToSourceLevel" : "1",
"resultToThisLevel" : "1"
},
"dimLevelsAggregators" :
{
"its" :
{
"it" :
[
{
"k" : "2",
"id" : "HALF_YEARS",
"n" : "Half-years",
"vis" : "1",
"includeChildren" : "0",
"useDefaultLevelAggregation" : "0",
"operation" : "UniformDisaggregation",
"sourceLevel" :
{
"k" : "1",
"id" : "YEARS",
"n" : "Years",
"vis" : "1"
},
"resultToSourceLevel" : "1",
"resultToThisLevel" : "0"
}
]
}
},
"levelAggsPresent" : "1"
}
}
]
}
},
"aggsPresent" : "1",
"hierAggsPresent" : "0"
},
{
"k" : "116",
"id" : "DIM_1",
"n" : "Dim_1",
"vis" : "1",
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "3",
"@hf" : "0",
"i" : "DIM_1",
"n" : "Dim_1",
"k" : "116",
"c" : "1025",
"p" : "103",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0"
},
"aggsPresent" : "0",
"hierAggsPresent" : "0"
},
{
"k" : "991",
"id" : "DIM_2",
"n" : "Dim_2",
"vis" : "1",
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "1",
"@hf" : "0",
"i" : "DIM_2",
"n" : "Dim_2",
"k" : "991",
"c" : "1025",
"p" : "10529",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0"
},
"aggsPresent" : "0",
"hierAggsPresent" : "0"
}
]
}
},
"dimBinds" :
{
"its" :
{
"it" :
[
{
"dimKey" : "5858",
"datasets" :
{
"it" :
{
"dsKey" : "5878"
}
}
},
{
"dimKey" : "112",
"datasets" :
{
"it" :
{
"dsKey" : "5878",
"indexKey" : "7",
"indexBlockKey" : "3",
"attrs" :
{
"it" :
{
"attrKey" : "2",
"fieldId" : "V_DATE",
"formula" : "OBJ5877.V_DATE"
}
}
}
}
},
{
"dimKey" : "116",
"datasets" :
{
"it" :
{
"dsKey" : "5878",
"indexKey" : "121",
"indexBlockKey" : "120",
"attrs" :
{
"it" :
{
"attrKey" : "118",
"fieldId" : "DIM1_ID",
"formula" : "OBJ5877.DIM1_ID"
}
}
}
}
},
{
"dimKey" : "991",
"datasets" :
{
"it" :
{
"dsKey" : "5878",
"indexKey" : "1001",
"indexBlockKey" : "1000",
"attrs" :
{
"it" :
{
"attrKey" : "993",
"fieldId" : "DIM2_ID",
"formula" : "OBJ5877.DIM2_ID"
}
}
}
}
}
]
}
},
"factBinds" :
{
"its" :
{
"it" :
[
{
"factKey" : "1",
"dsKey" : "5878",
"formula" : "OBJ5877.VALUE",
"aggrType" : "None"
},
{
"factKey" : "1",
"dsKey" : "5878",
"formula" : "",
"aggrType" : "None"
}
]
}
},
"calcBinds" :
{
"its" :
{
"it" :
[
{
"factKey" : "1",
"formula" : "",
"revFactKey" : "",
"revFormula" : "",
"timeLagLevel" : "None",
"timeForwardLag" : "0",
"timeBackwardLag" : "0",
"includeInSelection" : "0",
"calcMethod" : "BySelection"
},
{
"factKey" : "1",
"formula" : "",
"revFactKey" : "",
"revFormula" : "",
"timeLagLevel" : "None",
"timeForwardLag" : "0",
"timeBackwardLag" : "0",
"includeInSelection" : "0",
"calcMethod" : "ByMatrix"
}
]
}
},
"relations" :
{
"its" : ""
},
"selControl" :
{
"its" : "",
"options" : "",
"isEmpty" : "1"
}
}
]
}
},
"selControl" :
{
"its" : "",
"options" : "",
"isEmpty" : "1"
},
"supportsRub" : "0",
"validationAssertions" : ""
}
}
}
public static GetCubeResult GetCubeInfo(CubeId moniker)
{
var somClient = new SomPortTypeClient(); //Proxy object for operation execution
//Operation execution parameters
var tMeta = new GetCube()
{
tArg = new GetCubeArg()
{
pattern = new CubeMdPattern()
{
all = true
}
},
tCube = moniker
};
//Get information about cube structure
var result = somClient.GetCube(tMeta);
return result;
}

See also:

GetCube