Tm1 Function Date Rule

DATE

DATES returns the

TODAY returns the current

TIMST Returns a formatted

DAY returns the day from a

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

MAX returns the largest number between two numbers. Works in

MONTH returns the month from a

TIMVL returns a formatted

CONSOLIDATEDAVG returns the average value in a consolidation. Works in

EXP returns the natural anti-log of a number. Works in

CONSOLIDATEDMIN returns the minimum value in a consolidation. Works in

DELET

YEAR returns the year from a

SUBST returns the substring of a specified string. Works in

IF is a logical expression

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

CONSOLIDATEDCOUNTUNIQUE counts the unique elements of the consolidated cell in one dimension. Works in

CAPIT capitalize the first letter of every word in a string. Works in