Code: Select all
sDim='Versions';
sSubsetName='CurrentVersion';
sMDX='{TM1FILTERBYPATTERN( {TM1SUBSETALL( [Versions] )}, "2018")}';
IF(SubsetExists(sDim,sSubsetName)=1);
SubsetDestroy(sDim,sSubsetName);
ENDIF;
SubsetCreatebyMDX(sSubsetName,sMDX);
Code: Select all
sDim='Versions';
sSubsetName='CurrentVersion';
sMDX='{TM1FILTERBYPATTERN( {TM1SUBSETALL( [Versions] )}, "2018")}';
IF(SubsetExists(sDim,sSubsetName)=0);
SubsetCreate(sDim,sSubsetName);
ELSE;
SubsetDeleteAllElements(sDim,sSubsetName);
ENDIF;
SubsetMDXSet(sDim,sSubsetName,sMDX);
Code: Select all
SubsetMDXSet(sDim,sSubsetName,'');
Code: Select all
SubsetCreate(sDim,sSubsetName,1);