OpenCubeImport: Operation

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">

</tOb>

</metaGet>

</tArg>

</OpenCubeImport>

</s:Body>

</s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

</id>

P7REPOSITORY

<n>p7repository</n>

4294967295

</obDesc>

</obInst>

<its />

</dimBinds>

<its />

</factBinds>

P7REPOSITORY

<n>p7repository</n>

4294967295

</parent>

</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 a cube data import object
        var result = somClient.OpenCubeImport(tOpen);
        return result;
    }

OpenCubeImport

Syntax