QUEXPORT

QUEXPORT exports cells values from the specified cube to a delimited ASCII file.

To create the query set, use the QUDEFINE function.

Each output record has the following format:

The name of the cube containing the exported values
Names of elements that identify the cell location of a single exported value
The exported value

For a five-dimensional cube, TM1® creates records containing seven fields:

"cube name", "elem1", "elem2", "elem3", "elem4", "elem5", value

Note: QUEXPORT applies a lock to the server, preventing other users from accessing the server during function execution. If you use this function to export values from a large query set, the server might be inaccessible for a significant amount of time.

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

Syntax

QUEXPORT(cube, query, file)

Argument	Description
cube	The name of the cube to be queried. Use a server name prefix to indicate the server location. For the local server, specify local:cube. For a remote server, specify servername:cube.
query	The name of an existing query set.
file	The name of the delimited ASCII file (.cma) to contain the exported cube data. Do not include the file extension. The file is created in the local data directory.

Argument

Description

cube

The name of the cube to be queried.

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

query

The name of an existing query set.

file

The name of the delimited ASCII file (.cma) to contain the exported cube data. Do not include the file extension. The file is created in the local data directory.

Example

=QUEXPORT("sales:98sales", "Sedans", "Sedans")

This example exports data from the 98sales cube using the query set Sedans. The records are written to the file Sedans.cma.