VIEW
VIEW creates an optimized view of the cube specified by the cube argument.
A single VIEW function is created when you slice a view from a cube browse.
All DBR and DBRW formulas that refer to the VIEW function can then access this optimized view. In this way, results are returned much faster.
Multiple VIEW functions can reside in the same spreadsheet if you have blocks of DBR formulas that refer to different TM1® views or cubes.
This worksheet function is valid in worksheets only.
Syntax
VIEW(cube, e1,e2[,...en])|
Argument |
Description |
|---|---|
|
cube |
The name of the cube from which to retrieve data. |
|
e1,...en |
Either specific elements 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. These arguments can also be the names of aliases for dimension elements. |
Example
VIEW("93sales",$B$2,$B$3,$B$4,"!","!")