VUSLICE

VUSLICE creates a slice worksheet from the specified cube view. The slice is inserted starting at the top left cell (A1 or R1C1) in the active worksheet.

This TM1® macro function is valid in Excel macros and VBA modules only.

Syntax

VUSLICE(cube, view)

Argument	Description
cube	The name of an existing cube. Use a server name prefix to indicate the server location. For the local server, specify local:cube. For a remote server, specify servername:cube.
view	The name of a view associated with the cube.

Argument

Description

cube

The name of an existing cube.

Use a server name prefix to indicate the server location. For the local server, specify local:cube. For a remote server, specify servername:cube.

view

The name of a view associated with the cube.

Example

=VUSLICE("local:98sales","Quarterly")

This example copies data from the Quarterly view of the 98sales cube into the active worksheet.