<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-NCX94J4" height="0" width="0" style="display:none;visibility:hidden"></iframe>

TM1 Function for Excel, VIEW

Where can the VIEW function be used?

Excel

Which TM1 Server version is this function available for?

Version 11 and 12

What is the VIEW function?

VIEW sets up an optimised view for a cube that is cached in memory, so it can be referenced quicker. When Slicing a view in Perspectives or exporting to a Custom Report in PAX, the VIEW function is used to optimise the report.
In the VIEW function, title dimension is referenced to an element, while the dimensions in the row and column axis are defined as “!” to include all elements.

What is the syntax for VIEW?

VIEW(TM1ServerName:Cube, Element 1, Element 2,… , , u0022!u0022,u0022!u0022, Element n);

– TM1ServerName = Name of the TM1 Server
– Cube = Name of the Cube
– Element 1 and Element 2 = Name of the title dimension elements
“!” = refers to row or column dimensions to include all elements

A demonstration of how to use VIEW

Export the default view from the Product Scorecard cube as a Custom Report and show how the VIEW function is put together.