IBM Support

Documentation update - TurboIntegrator functions SubsetMDXGet and SubsetMDXSet

Product documentation


Abstract

Two new TM1 TurboIntegrator functions were added for TM1 version 10.2.2 but are not included in the documentation.

Content

SubsetMDXGet

This function retrieves the MDX expression used to create a subset.

This is a TM1® TurboIntegrator function, valid only in TurboIntegrator processes.


Syntax:

SubsetMDXGet(dimension, subsetname);


Argument Description
dimension The parent dimension of the subset.
subsetname The subset for which you want to retrieve the MDX expression.

Example:

mdxString = SubsetMDXGet('Cities', 'testsubset');


SubsetMDXSet
This function removes the MDX expression from a dynamic subset and converts the dynamic subset to a static subset without locking the underlying dimension.

All of the old elements at the time of the call are saved as elements of the new static subset. The function returns the number of elements that the new subset contains. Optionally, you can also populate the subset with a new MDX expression.
Note: This function works with public subsets only.

This is a TM1 ® TurboIntegrator function, valid only in TurboIntegrator processes.

    Syntax:

    SubsetMDXSet( dimension, subsetname, [ MDX_expression]);


    Argument Description
    dimension The parent dimension of the subset.
    subsetname The subset for which you want to remove the MDX expression.
    MDX_expression Optionally, the MDX expression that you want to populate the subset with. All elements are deleted and the subset is populated with the elements as defined by the new MDX expression. If the MDX expression is invalid, TurboIntegrator processing stops, the contents of the subset is unchanged and an error is logged.
    If you do not use this parameter, include an empty string.

    Example:

    countMem = SubsetMDXSet('Cities', 'testsubset', ' ');

Document information

More support for: Cognos TM1
TM1 Turbo Integrator

Software version: 10.2.2

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Reference #: 7042401

Modified date: 27 October 2015