QULOOP

QULOOP exports data that meets query set criteria from the specified cube. TM1® reads in each output record, one at a time, into the first row of the active worksheet. Each field populates a different cell. The worksheet is recalculated after each record is read in.

Each output record has the following format:

  • The name of the cube containing the exported values
  • The 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

Use QULOOP in conjunction with a DBSn formula to populate cells in a cube.

Note: QULOOP 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

QULOOP(cube, query)

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.

Example

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

This example exports data from the 98sales cube using the query set Sedans.