TM1 Forum

image2x wrote:I'm testing TM1's 10.2.2 FP1 undocumented SubsetMDXSet function ( see http://www-01.ibm.com/support/docview.w ... wg27042401 ) and thus far cannot get it to function as documented:

Code: Select all

### total_lvl_0_w_alias
vDim = 'Legal_Entity';
vMdx = '{[legal_entity].[Total Company],TM1SORT( {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( {[legal_entity].[Total Company]}, ALL, RECURSIVE )}, 0)}, ASC)}';
vSubset = 'total_lvl_0_w_alias';
SubsetCreatebyMDX ( vSubset, vMdx );
SubsetMDXSet ( vDim, vSubset );

The documentation is unclear on if the subset needs to already exist which is why I have the SubsetCreateByMDX statement included. Results:
* If dynanmic subset already exists, there is no conversion to a static subset.
* If run as 'SubsetMDXSet ( vDim, vSubset, vMdx)', no subset is created.
-- John

# Create empty subset
SubsetCreate(<DimName>, <SubsetName>);
# Attach MDX and make it dynamic
SubsetMDXSet(<DimName>, <SubsetName>, <MDXQuery>);
# Detach MDX query and make it static
SubsetMDXSet(<DimName>, <SubsetName>, '');