SUBPICK
SUBPICK calls a dialog box that lists all the elements in the specified subset. The elements you select are inserted in the active worksheet, starting at the current cell position.
This TM1® macro function is valid in Excel macros and VBA modules only.
Syntax
SUBPICK(dimension, subset, vertical)|
Argument |
Description |
|---|---|
|
dimension |
The name of the dimension containing subsets. Use a server name prefix to indicate the server location. For the local server, specify local:dim. For a remote server, specify servername:dim. |
|
subset |
The name of the subset whose elements you want to select. |
|
vertical |
Specify TRUE to insert the element names vertically, from the current cell downward. Specify FALSE to insert the element names horizontally, from the current cell rightward. |
Example
=SUBPICK("local:Model", "Smith", TRUE, )This example inserts selected elements from the Smith subset into the active worksheet. The elements are arranged vertically, starting from the current cell downward.