Tried it by creating a hierarchy subset and then the following:
Code: Select all
sMDX = 'TM1FILTERBYLEVEL(TM1SUBSETALL( [Accounts Master].[Statistical Categories]), 0)';
HierarchySubsetCreate(dimAccountsMaster, hierStatisticalCategories, subStatisticalCategories, 1);
HierarchySubsetMDXSet(dimAccountsMaster, hierStatisticalCategories, subStatisticalCategories, sMDX);
DataSourceType = 'SUBSET';
# this does not work either: DataSourceNameForServer = dimAccountsMaster;
DataSourceNameForServer = hierStatisticalCategories;
DataSourceDimensionSubset = subStatisticalCategories;
Hope I'm just missing something because I'm just diving into using the hierarchy functionality.