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 );
* 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