Cube Slice (String)

Impure

Slices data from an intersection of elements from their respective dimensions within the cube.

Pure Function

No

Execute Inputs

Execution

INPUT

Execution Input.

Execute Outputs

Process Row

OUTPUT

Fires for each row with parsed data.

Loops

Complete

OUTPUT

Fires when the entire slice is successfully processed.

Data Inputs

Location

INPUT

A location of elements for each dimension in the cube in the format of ["Element 1", "Element 2", ...].

Cube

INPUT

The target cube name or ID.

Data Outputs

Row Data

OUTPUTarray

A list containing elements and value of the location in the cube.

Multiple

Row Elements

OUTPUTarray

A list containing elements of the location in the cube.

Multiple

Row Value

OUTPUTdouble

Value for the location in the cube.

Multiple

Row Number

OUTPUTinteger

The current row number in the slice.

Multiple

Total Rows

OUTPUTinteger

Total number of rows in the slice.

Multiple

Settings

Static Values

BOOLEAN

If true, cube data will return with no formulas applied.

Default: false

First Row Headers

BOOLEAN

If true, headers will be supplied in the first row outputted by the slice.

Default: false

Debug

STRING

Break on node when executing.

Default: No

Options:

NoBeforeInputsBeforeProcessingAfterProcessing