FILLMISSING
Basic Overview
AVAILABLE FROM 5.2.0
Description | Fills up all the missing level values of a specified dimension to the data of the input node. The input node must already contain the levels of the dimension. |
Signature | FILLMISSING('Node' [, "Dimension" [, "Value"]]) |
Parameters |
|
Limitations |
|
Example
The time horizon of the project is 2021-2024.
The Dimension 'ProductDimension' consists out of the level 'Product' and the level values 'Car', 'Van', and 'Truck'.
The input node features the level values '2021', 2023' and 'Car', 'Van'.
Input node =
Year | Product | Value |
---|---|---|
2021 | Car | 100 |
2023 | Van | 90 |
FILLMISSING('Input node') =
Year | Product | Value |
---|---|---|
2021 | Car | 100 |
2021 | Van | 0 |
2022 | Car | 0 |
2022 | Van | 0 |
2023 | Car | 0 |
2023 | Van | 90 |
2024 | Car | 0 |
2024 | Van | 0 |
With this formula, the input node is filled with the missing level values (2022, 2024) of the default dimension 'Time' and the default value '0' is added.
The input node now features all years of the project time horizon with the value '0'.
FILLMISSING('Input node',"ProductDimension", 1) =
Year | Product | Value |
---|---|---|
2021 | Car | 100 |
2021 | Van | 1 |
2021 | Truck | 1 |
2023 | Car | 1 |
2023 | Van | 90 |
2023 | Truck | 1 |
With this formula the input node is filled up with the missing level values of the Dimension 'ProductDimension' (Truck).
The entered value is '1'.
Example with linked levels
Keep in mind that this function might change existing level values if the levels are linked. The result of this function will always follow the links in the dimension table.
Input =
Month | CalendarMonth | Value |
---|---|---|
2021-02 | 06 | 100 |
2021-03 | 06 | 105 |
2021-04 | 11 | 110 |
2021-05 | 05 | 115 |
2021-06 | 06 | 120 |
2021-07 | 02 | 125 |
FILLMISSING('Input',"TimeDimension", 15) =
Month | CalendarMonth | Value |
---|---|---|
2021-01 | 01 | 15 |
2021-02 | 02 | 100 |
2021-03 | 03 | 105 |
2021-04 | 04 | 110 |
2021-05 | 05 | 115 |
2021-06 | 06 | 120 |
2021-07 | 07 | 125 |
2021-08 | 08 | 15 |
2021-09 | 09 | 15 |
2021-10 | 10 | 15 |
2021-11 | 11 | 15 |
2021-12 | 12 | 15 |