View function for IBM Planning Analytics (TM1)
The View function sets up an optimised view for a cube cached in memory so it can be referenced quicker when referred within the DBRW or DBR formula.
In the View function, the title dimension is referenced to an element, while the row and column axis dimensions are defined as “!” to include all elements.
In this video, learn how the View function is constructed from a Custom Report in IBM Planning Analytics for Excel.
Where can the View function be used?
Excel
Which TM1 Server version is the View function available for?
Version 11 and 12
What is the syntax for View?
View(TM1ServerName:Cube, Element 1, Element 2, …, Element n)
- TM1ServerName = Name of the TM1 Server
- Cube = Name of the Cube
- Element1 to ElementN = An element in each dimension from the Cube. Each element must be ordered based on the dimension of the Cube.