Cube ImportCells

Writes one or more cell values/notes to the specified cube.

In the default mode, the caller needs the Write Values and the View OLAP permissions.

Request

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="4.180.1" Class="Cube" Method="ImportCells">
    <Alea:CellBatch Cube="DCS_Planning" Delimiter=";">
AS600/175;01_2017;Units;3.14
AS600/175;02_2017;Units;2,718;"Cell^tnote line1^^^r^nLine2"
AS600/175;03_2017;Units;[+]-1,414
AS600/175;04_2017;Units;%#DELETED#%;%#DELETED#%</Alea:CellBatch>
  </Alea:Request>
</Alea:Document>

The content of the <Alea:CellBatch> XML element consists of one or more lines that end with CRLF ("\r\n") or with LF ("\n"), except for the last one. Each line represents one cell of the cube and contains several columns separated by the specified delimiter. The default is a horizontal tabulator. If there are multiple <Alea:CellBatch> XML elements, only the first one is processed. Consecutive <Alea:CellBatch> XML elements are silently ignored.

By default, each dimension in the cube is represented by one column within the lines. These columns hold the dimension element names (coordinates) of the targeted cell. They must be in the same order as the dimensions in the cube. If a dimension has alternate hierarchies, the default hierarchy is selected. Alternate hierarchies can be targeted with a different syntax. The last column holds the cell note. It can be omitted. The second to last column (or the last column if the cell note is omitted) holds the cell value.

When importing numbers as cell values, the decimal separator can either be a decimal point (.) or a comma (,). Both separators are accepted.

String values and cell notes can be enclosed in quotation marks. If you want quotation marks at the beginning or at the end of the resulting string value or cell note, there must be two quotation marks. Some characters need to be escaped. The list is below. If there are escaped characters in the string value or cell note and they are supposed to be converted, the string value or cell note must be enclosed in quotation marks.

Empty cell values and empty cell notes are silently ignored.

Escape sequences to encode text elements into structured format:

^^ : '^' : 94
^t : '\t' : 9
^r : '\r' : 13
^n : '\n' : 10

The example in the request is converted as:

Cell note line1^
Line2

Note: After Cell is a horizontal tab, not a space character.

The syntax [+]<value> requests the value to be added to the current cell instead of overwriting its value.

The %#DELETED#% token is used to delete the value and/or note of a cell during the import.

Answer

<Alea:Document xmlns:Alea="http://www.misag.com">
  <Alea:Request RequestID="4.180.1">
    <Alea:Return />
  </Alea:Request>
</Alea:Document>