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 to start import, use the SetCubeImport operation. Import object state can be found by means of the GetCubeImport operation.

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

After data import call the CloseCubeImport operation to free 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>S1!M!0</id>
  </tOb>
<tArg xmlns="">
<metaGet>
  <obInst>true</obInst>
  <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>S1!M!S!I1</id>
  </id>
<meta xmlns="">
<obInst>
<obDesc isShortcut="0" isLink="0" fullUrl="/">
  <i>P7REPOSITORY</i>
  <n>p7repository</n>
  <k>0</k>
  <c>0</c>
  <p>4294967295</p>
  <h>0</h>
  <isPermanent>1</isPermanent>
  <isTemp>0</isTemp>
  </obDesc>
  </obInst>
<dimBinds>
  <its />
  </dimBinds>
<factBinds>
  <its />
  <newDictionaryName />
  </factBinds>
<parent isShortcut="0" isLink="0" fullUrl="/">
  <i>P7REPOSITORY</i>
  <n>p7repository</n>
  <k>0</k>
  <c>0</c>
  <p>4294967295</p>
  <h>0</h>
  </parent>
  <resultType>Cube</resultType>
  <addAllFields>0</addAllFields>
  <editExistingObject>0</editExistingObject>
  <createStoredView>0</createStoredView>
  <createETLTask>0</createETLTask>
  </meta>
  </OpenCubeImportResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

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

JSON response:

{
 "OpenCubeImportResult" : 
  {
   "id" : 
    {
     "id" : "S1!M!S!I1"
    },
   "meta" : 
    {
     "obInst" : 
      {
       "obDesc" : 
        {
         "@fullUrl" : "\/",
         "@isShortcut" : "0",
         "@isLink" : "0",
         "i" : "P7REPOSITORY",
         "n" : "p7repository",
         "k" : "0",
         "c" : "0",
         "p" : "4294967295",
         "h" : "0",
         "isPermanent" : "1",
         "isTemp" : "0"
        }
      },
     "dimBinds" : 
      {
       "its" : ""
      },
     "factBinds" : 
      {
       "its" : "",
       "newDictionaryName" : ""
      },
     "parent" : 
      {
       "@fullUrl" : "\/",
       "@isShortcut" : "0",
       "@isLink" : "0",
       "i" : "P7REPOSITORY",
       "n" : "p7repository",
       "k" : "0",
       "c" : "0",
       "p" : "4294967295",
       "h" : "0"
      },
     "resultType" : "Cube",
     "addAllFields" : "0",
     "editExistingObject" : "0",
     "createStoredView" : "0",
     "createETLTask" : "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