TM1 Forum

Thanks
I am now reading
http://www.wimgielis.com/tm1_subsetcrea ... set_EN.htm

Hi tom,

Thanks:

I did re-test
IF(ELLEV(MyDimension, MyElement) > 0); and it worked.Thank you.

only thing - i did not understand is. SUBSETMDXSET(MyDimension, MySubset, '')
What is the need of ? SUBSETMDXSET function removes the MDX expression from a dynamic subset (Per IBM)
Regards

Hi The below code effects the regular and alternate hierarchy. IF(ELLEV(MyDimension, MyElement) > 0); DIMENSIONELEMENTDELETE(MyDimension, MyElement); ENDIF: I need to apply conditions to ONLY Alternate hierarchy. Example: Account_Alt (TopLevle) AAA A1 A2 BBBB B1 B2 CCCC C1 C2 Like above the -I have ...

Hi, I am still trying to get there- Condition on delete: IF(DTYPEvDimName,InputeElem)@= 'C'); DIMENSIONDELEMENTDELETE(vDimname,InputElem); Endif: I have tried using the ELISANC(dimension, element1, element2) example:IF(DTYPEvDimName,InputeElem)@= 'C' & LISANC(Account, element1, element2) The pro...

Hi tomok, Thanks for reply: I took the data source as dimension subset and coded vDimName = 'Account'; vSubset = 'Delete_Consolidation'; IF(SubsetExists(vDimName,vSubset)=1); SubsetDestroy(vDimName,vSubset); Endif; SubsetCreatebyMDX(vSubset, '{EXCEPT({[ACCOUNT].[ACCOUNT_CUSTOM_TM1].CHILDREN}. {[acco...

Hi All, I have two main dimension hierarchy, regular and alternate hierarchy. I need delete parents and along with children and ancestor for the ONLY few of the consolidated elements (Parents) from alternate hierarchy. This alternate hierarchy have multiple parents/rollups under it. I tried followin...