Macro functions

DATAAREA.DEFINE
Creates a data area. Here, a data area is a temporary query object. It is not available for selection in the Cubes and Data Areas dialog. As such, it must be distinguished from a Data Area, which is a saved area of a cube containing subsets.
SeeData areas.
DATAAREA.DESTROY
Deletes the currently active data area (the data area last called by another Infor OLAP function). Here, a data area is a temporary query object. It is not available for selection in the Cubes and Data Areas dialog. As such, it must be distinguished from a Data Area, which is a saved area of a cube containing subsets .
DATAAREA.SETVALUE
Sets all values of the currently active data area (a data area that has just been created by DATAAREA.DEFINE or accessed by another OLAP Server function) to a new value. Here, a data area is a temporary query object. It is not available for selection in the Cubes and Data Areas dialog. As such, it must be distinguished from a Data Area, which is a saved area of a cube containing subsets .
DATAWORLD.ADD
Creates a data area on the specified database alias for the given cube .
DATAWORLD.KILL
Deletes the specified data area for the specified cube on the specified database alias.
DIMS.DIALOG
Displays the Dimensions dialog, allowing the user to select a dimension from a specified cube.
DE.ADD
Adds an element to the dimension.
DE.CHILDRENCOUNT
Displays the number of children of the given element.
DE.CHILDNAME
Displays the name of the specified child of the given element.
DIM.ELEMS.DIALOG
Opens the Dimension Browser dialog.
MDS.LAST.ERROR
The function returns the number of the error that occurred last. Use the function MDS.ERROR display the text associated with the error.
SERVER.CONNECT
Connects to a specified database alias as a specified user.
SERVER.DISCONNECT
Disconnects from the specified database alias.
SERVER.GET.INFO
Displays information about a given database alias associated with a specified ID number.
SUB.DEFINE
Creates a new subset for a specified dimension.
SUB.DEFINE.DIALOG
Opens the Subset Definition dialog.
SUB.DEFINE.DIALOGEX
Shows the Subset Definition dialog (as in 'SubsetDefineDialogbox'). But in this dialog, the definition is saved automatically, i.e. the user does not need to issue a saving command.
SE.ELEMENS.DIALOG
Opens the Dimension Browser for the specified subset.
SE.COUNT
Returns the number of elements in a given subset.
SE.NAME
Returns the name of the nth element in a specified subset.
TAB.CLEAR
Clears a cube from memory (not from disk).
TABS.DIALOG
Opens the Cubes and Data Areas dialog.
TABS.IMPORT
Imports cube values from a flat file without Microsoft Excel.
TAB.KILL
Deletes a cube from memory and from disk.
TABS.ADD
Creates a new cube on the specified database alias.
TAB.SAVE
Saves a cube which is currently in memory to disk.
TABS.IMPORT.FROM.DATAAREA
Processes a cube import from a defined data area. The data area used is the data area last called or created.
TABS.IMPORT.FROM.FILE
Processes a flat file into the first row of an Excel sheet. Analogous to the process flat file command.
WORKSPACE.GET.PARAMETER
Returns the specified string from the MDSEX.INI file.
WORKSPACE.SET.PARAMETER
Writes the given value at the specified entry in the MDSEX.INI file.