TM1 is great at consolidating data, but what if you want to prevent that from happening? Consider the following example, where we have FTE data for an employee at the Month level that is being incorrectly consolidated at the Quarter level.

 

We can use business rules to pull the last month in the quarter and prevent the natural consolidation. The rule will leverage the “Last Period” attribute that is automatically created and populated when a dimension is customized as a time dimension in PAW.

The rule is shown in the animated GIF below. The PAW rule editor has a handy autocomplete feature that can be enabled by typing SHIFT + SPACE – that is how the DB statement is automagically populated for our rule.

The result is exactly what we are looking for – the value in Q2 2018 is equal to Jun 2018.