Tm1 Function Code Rule

Summary

Want to interact with your Planning Analytics environment…from anywhere? Say hello to cloud UNDEF returns the undefined value. Works in DB retrieve a value from a cube cell. Works in CODEW returns the UTF-8 numeric CHAR converts the ASCII numeric SUBST returns the substring of a specified string. Works in ELEMENTCOMPONENTCOUNT returns the number of components of the consolidation. Works in ATTRS returns the string attribute for a specified element of a dimension. Works in CONSOLIDATEDAVG returns the average value in a consolidation. Works in FILL repeats a string to the specified number of lengths. Works in ELEMENTCOMPONENT returns the name of child of a consolidated element. Works in ELEMENTFIRST returns the first element of a specified dimension. Works in LONG returns the length of the string. Works in