TM1Val is a hierarchy-aware formula that reads, writes, or clears a cell, and it works with TM1 Web and IBM Planning Analytics for Excel.
In this video, TM1Val will be used to read, clear and write to a cell at the lowest cell level and consolidate.
Excel
Version 11 and 12
TM1Val(Datasource URI, Server, Cube, Mode, WriteValue, Cube Intersection)