Exploring Tm1 Function Month Rule
Let's dive into the details surrounding Tm1 Function Month Rule.
- YEAR returns the year from a date in a numeric format. Works in
- DATE returns the date in a string yy-dd-mm format. Works in
- HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.
- CONSOLIDATECHILDREN forces consolidate value to be calculated by summing immediate children. Works in
- TIME returns the current Time from the
In-Depth Information on Tm1 Function Month Rule
MONTH DATES returns the date in a string yy-dd-mm or yyyy-dd-mm format. Works in TIMVL returns a formatted date/time in a string format. Works in DAY returns the day from a date in a numeric format. Works in
TIMST Returns a formatted date/time in a string format. Works in
That wraps up our extensive overview of Tm1 Function Month Rule.