T_CREATE

T_CREATE creates a cube that has up to eight dimensions, which is the limit in older versions of TM1®.

Note: If you use T_CREATE to create a cube with the name of an existing cube, TM1 replaces the existing cube and deletes all of its data.

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

Syntax

T_CREATE(cube,d1,d2[,d3,d4,d5,d6,d7,d8])

Argument	Description
cube	The name of the cube to be created. Use a server name prefix to indicate the server location. For the local server, specify local:cube. For a remote server, specify servername:cube.
d1...d8	Names of up to eight existing dimensions, in the order you want them stored in the cube. You must specify at least two dimensions.

Argument

Description

cube

The name of the cube to be created.

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

d1...d8

Names of up to eight existing dimensions, in the order you want them stored in the cube. You must specify at least two dimensions.

=T_CREATE("local:Sales","Region","Products","Month")

This example creates a cube named Sales. This new cube has three dimensions, in the following order: Region, Products, and Month.