New Features and Improvements

AtScale contains the following new features and improvements.

I2025.2.0

New First Child and Last Child options for semi-additive measures

You can now configure semi-additive measures to return either the first child or last child of a dimension. This enables you to create semi-additive measures that return NULL values when used across a time dimension.

To support this functionality, the Semi-Additive Measure field in the Create/Edit a Measure dialogs contains two new options: First Child and Last Child.

Note

When using either First Child or Last Child, be aware of the semi-additive trigger hierarchy's Exclude Values With No Fact Data setting. When this option is disabled, the first child and last child always return the first or last child dimension member via an outer join with the semi-additive hierarchy's relationship key. When Exclude Values With No Fact Data is enabled (the default), the system performs an inner join, resulting in the first child or last child result that has a fact table row. Keep the fact table record requirement in mind when using first child / last child with the associated hierarchy's Exclude Values With No Fact Data setting.

For more information, see Semi-Additive Measures and Add Semi-Additive Measures.

ATSCALE-24755