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', ' ');
[{"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"TM1 Turbo Integrator","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF010","label":"HP-UX"}],"Version":"10.2.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27042401