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.

Relevant Functions

DBR = Retrieve and write back a value or text to a cube’s cell
DBRW = Retrieve and write back a value or text to a cube’s cell, which is more efficient than the DBR over a WAN than DBRW