View function for IBM Planning Analytics (TM1)

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