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

DATE returns the date in a string yy-dd-mm format. Works in

TIMST Returns a formatted date/time in a string format. Works in

CONSOLIDATEDAVG returns the average value in a consolidation. Works in

NOW returns the current Time in a serial number format. Works in

ATTRS returns the string attribute for a specified element of a dimension. Works in

CELLVALUES returns the string value of the specified element in a specified cube. Works in

YEAR returns the year from a date in a numeric format. Works in

DAY returns the day from a date in a numeric format. Works in

UNDEF returns the undefined value. Works in

HIERARCHY returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.

CUBEATTRN returns a numeric attribute for a specified cube. Works in

CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in

MAX returns the largest number between two numbers. Works in

DIMENSIONATTRS returns a string attribute for a specified dimension. Works in

ELEMENTISCOMPONENT determines if the element is child of a consolidation or not.

SUBST returns the substring of a specified string. Works in

FEEDSTRINGS enables feeding of string cells. Works in