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.
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.