OpenCubeImport

Syntax

OpenCubeImportResult OpenCubeImport(OdId tOb, OpenCubeImportArg tArg)

Parameters

tOb. Moniker of the parent object, within which the operation is executed.

tArg. Operation execution parameters.

Description

The OpenCubeImport operation creates an object of data import to cube and returns the context for working with it.

Comments

On executing the operation a new object is created in BI server memory that is used for data import. To set up parameters of the obtained object, and also to start import, use the SetCubeImport operation. To get import object state, use the GetCubeImport operation.

To execute the OpenCubeImport operation, in the tObj field specify moniker and in the tArg field specify import object creation parameters. The repository root moniker is specified as a moniker value.

After data is imported, call the CloseCubeImport operation to release BI server resources.

Example

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">
<OpenCubeImport xmlns="http://www.fsight.ru/PP.SOM.Som">
<tOb xmlns="">
  <id>APJPBGEDEHLPFOAEJOPLMILHOOECMEPEOJKDMJHCGFMKDNKM!M!0</id>
  </tOb>
<tArg xmlns="">
<metaGet>
  <obInst>true</obInst>
  <parsOwnDefVals>true</parsOwnDefVals>
  <all>true</all>
  </metaGet>
  </tArg>
  </OpenCubeImport>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<OpenCubeImportResult 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>APJPBGEDEHLPFOAEJOPLMILHOOECMEPEOJKDMJHCGFMKDNKM!M!S!IDGLAIGEDEHLPFOAEPEOHNINBKMJBOEEEAINBLLIJNBNHEPDJ</id>
  </id>
<meta xmlns="">
<obInst>
<obDesc ds="" isShortcut="0" isLink="0" ver="0" hf="0">
  <i>WAREHOUSE</i>
  <n>Warehouse</n>
  <k>0</k>
  <c>0</c>
  <p>-1</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  <isPermanent>1</isPermanent>
  <isTemp>0</isTemp>
  </obDesc>
  </obInst>
<dimBinds>
  <its />
  </dimBinds>
<factBinds>
  <its />
  <newDictionaryName />
  </factBinds>
<parent ds="" isShortcut="0" isLink="0" ver="0" hf="0">
  <i>WAREHOUSE</i>
  <n>Warehouse</n>
  <k>0</k>
  <c>0</c>
  <p>-1</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  </parent>
  <resultType>Cube</resultType>
  <addAllFields>0</addAllFields>
  <editExistingObject>0</editExistingObject>
  <createStoredView>0</createStoredView>
  <createETLTask>0</createETLTask>
  <loadDuplicates>0</loadDuplicates>
  </meta>
  </OpenCubeImportResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
"OpenCubeImport" :
{
"tOb" :
{
"id" : "APJPBGEDEHLPFOAEJOPLMILHOOECMEPEOJKDMJHCGFMKDNKM!M!0"
},
"tArg" :
{
"metaGet" :
{
"obInst" : "true",
"parsOwnDefVals" : "true",
"all" : "true"
}
}
}
}

JSON response:

{
"OpenCubeImportResult" :
{
"id" :
{
"id" : "APJPBGEDEHLPFOAEJOPLMILHOOECMEPEOJKDMJHCGFMKDNKM!M!S!IDGLAIGEDEHLPFOAEPEOHNINBKMJBOEEEAINBLLIJNBNHEPDJ"
},
"meta" :
{
"obInst" :
{
"obDesc" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "0",
"@hf" : "0",
"i" : "WAREHOUSE",
"n" : "Warehouse",
"k" : "0",
"c" : "0",
"p" : "4294967295",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0",
"isPermanent" : "1",
"isTemp" : "0"
}
},
"dimBinds" :
{
"its" : ""
},
"factBinds" :
{
"its" : "",
"newDictionaryName" : ""
},
"parent" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "0",
"@hf" : "0",
"i" : "WAREHOUSE",
"n" : "Warehouse",
"k" : "0",
"c" : "0",
"p" : "4294967295",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0"
},
"resultType" : "Cube",
"addAllFields" : "0",
"editExistingObject" : "0",
"createStoredView" : "0",
"createETLTask" : "0",
"loadDuplicates" : "0"
}
}
}
public static OpenCubeImportResult OpenCubeImport(MbId mb)
{
var somClient = new SomPortTypeClient(); //Proxy object for operation execution
//Operation execution parameters
var tOpen = new OpenCubeImport()
{
tArg = new OpenCubeImportArg()
{
metaGet = new CubeImportMdPattern()
{
all = true
}
},
tOb = new OdId()
{
id = mb.id + "!0"
}
};
//Create an object of data import to cube
var result = somClient.OpenCubeImport(tOpen);
return result;
}

See also:

Working with Cubes