VIEW

VIEW is primarily used for compatibility with TM1® TM1 Perspectives worksheets. For example, when you create a slice from a TM1 Perspectives worksheet and open it in IBM® Planning Analytics for Microsoft Excel, you might see a VIEW function. The VIEW function defines a view of the cube specified by the server:cube argument.

DBR and DBRW formulas can refer to a VIEW function.

A workbook can contain multiple VIEW functions.

Syntax

VIEW(server:cube, m1,m2[,...mn])

Argument

Description

 Required/Optional

server:cube

The name of the TM1 server and the name of the cube from which to retrieve data.

 Required

m1,...mn

Either specific members in the slice to be used as titles, or the string "!".

The string "!" indicates that the corresponding dimension is a row or column in the view.

Arguments m1 through mn are sequence-sensitive. m1 must be a member from the first dimension of the cube, m2 must be a member from the second dimension, and so on. These arguments can also be the names of aliases for dimension members.

 Required

Example

The following examples use the GO_New_Stores TM1 server. The dimensions in this cube are:
  • Retailers
  • Countries_currency
  • Products
  • Month
  • Budget version
  • Store Sales Plan
VIEW("GO_New_Stores:Store Sales Plan")

In this example, the function defines a view for the Store Sales Plan cube. The cell containing the VIEW function displays GO_New_Stores:Store Sales Plan.

VIEW("GO_New_Stores:Store Sales Plan","Department Store",
"Americas","!", "!", "Budget version 1","Quantity")
In this example, the function defines a view as follows:
  • Title members: Department Store, Americas, Budget version 1, Quantity
  • Rows: Products
  • Columns: Month

The cell containing the VIEW function displays GO_New_Stores:Store Sales Plan.

You can also use cell references in a VIEW function:

VIEW("GO_New_Stores:Store Sales Plan",$B$20,"$B$21","!", "!",
$B$23,$B$24)

Suppose that cell B5 contains the VIEW function shown previously. You can display data from the view by using a DBR or DBRW function that references the view.

DBR(B5,"Department Store","Americas","Tents","Total Year",
"Budget version 1","Quantity")

In this example, the DBR function returns the value at the intersection of Department Store, Americas, Tents, Total Year, Budget version 1, and Quantity in the view that is defined in cell B5.

You can also use cell references for some or all of the arguments:

DBR(B5,D55,D56,D57,D58,D59,”Quantity”)