In IBM® Cognos® Analysis for Microsoft Excel, a single VIEW function
is used to specify the cube and cube element information.
Syntax
VIEW(cube, e1,e2[,...en])
The arguments are described in the following list.
- 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,"!","!")