Ole Dyring
Articles
-
FLOOR, Floor value (as a column)
Type: Inserted as a columnDescription: Returns the nearest integer value lower than or equal to a number.Range:Columns: Last columnRows: Each rowMeasures: First measureSyntax:floor(sum(d-1, 0, m1))...
-
DIV, integer from division (as a measure)
Type: Inserted as a measureDescription: Returns only the integer part from a division, discarding the remainder.Range:Columns: Each columnRows: Each rowMeasures: First measureSyntax:div(sum(0, 0, m...
-
DIV, integer from division (as a column)
Type: Inserted as a columnDescription: Returns only the integer part from a division, discarding the remainder.Range:Columns: Last columnRows: Each rowMeasures: First measureSyntax:div(sum(d-1, 0, ...
-
CEIL, Ceiling value (as a measure)
Type: Inserted as a measureDescription: Returns the nearest integer value higher than or equal to a number.Range:Columns: Each columnRows: Each rowMeasures: First measureSyntax:ceil(sum(0, 0, m1))S...
-
CEIL, Ceiling value (as a column)
Type: Inserted as a columnDescription: Returns the nearest integer value higher than or equal to a number.Range:Columns: Last columnRows: Each rowMeasures: First measureSyntax:ceil(sum(d-1, 0, m1))...
-
ABS, absolute value (as a measure)
Type: Inserted as a columnDescription: Returns the absolute value (removes minus signs) from numbers in each column.Range:Columns: Each columnRows: Each rowMeasures: First measureSyntax:abs(sum(0, ...
-
ABS, absolute value (as a column)
Type: Inserted as a columnDescription: Returns the absolute value (removes minus signs) from numbers in the last column.Range:Columns: Last columnRows: Each rowMeasures: First measureSyntax:abs(sum...
-
Result Modifiers syntax
FunctionDescriptionAbs(x)Returns the absolute value of x:Abs(-3) =3Abs(0) = 0Abs(3) = 3Ceil(x)Returns the smallest integer not less than xEksempler:Ceil(3.01) = 4Ceil(3.5) = 4Ceil (3.99) = 4Div(x;y...
-
InMemory ETL script execution controls
[Cloud release: 2025.10.29][On-prem release: 2026 January][On-prem build: 26.01.21003]Controls have been added for parallel script limits, per-script CPU caps, and configurable timeouts. Improves r...
-
Debugging InMemory ETL projects with VS Code
[Cloud release: 2025.04.09][On-prem release: 2025 June][On-prem build: 25.05.27002]You can start debugging an opened InMemory ETL project file by clicking the Debug button in the InMemory ETL Studi...