Analysis hierarchy used to perform day-to-day comparisons.
Dimension
Dates
Hierarchy
DayToDay
Levels
[DayToDay]
[Dates].[DayToDay] is filled with the members of [Dates].[Date].[AsOfDate] and the content of the mr.cubes.levels.day-to-day-members property. The first element of the property is the default member.
The default configuration is:
Member
Offset
Description
Yesterday
DAY-1
One calendar day before the current as-of date
Day-2
DAY-2
Two calendar days before the current as-of date
Tomorrow
DAY+1
One calendar day after the current as-of date
End Of Month
EOM-1
Last day of the previous month
End Of Quarter
EOQ-1
Last day of the previous quarter
End Of Year
EOY-1
Last day of the previous year
The offset format supports three move kinds:
DAY: relative calendar day shift (e.g. DAY-1, DAY+2)
CUB: shift relative to the dates loaded in the cube (e.g. CUB+1 is the previous loaded date)
EOM/EOQ/EOY: end-of-period shift (e.g. EOM-1 is the end of the previous month)
To customize the members, override the mr.cubes.levels.day-to-day-members property. For example, to add a member that shifts to the previous loaded date in the cube:
The DayToDay hierarchy is used by “Previous” measures (e.g. Delta Previous, Vanna Native Previous) to retrieve a measure value at a different as-of date.
This is a slicing hierarchy. Please refer to the Atoti UI User Guide to read more about slicing hierarchies: Atoti UI FAQ.