TM1 Forum

Hi all, Need some clarity on the RunProcess return value. I have setup some validation in the sub process and if something goes wrong, it will add up the error counter and ProcessBreak. This will skip everything and goes directly to Epilog (here I have some important procedure to remove some generat...

to get the parent of the organization and check the level attribute if it's equal to 'Level 0'. If yes, use Subset1, else Subset 2 Hello, If I am to elaborate the above from my post, the objective is to allow user to select the organization element in PAW, and to shorten the list of programs that a...

I have a simple one that works TM1SubsetToSet([staff_position] , IIF([organization].[Supreme] = 1 , "Supreme_Org" , "z_none")) For this case, it needs to check the level attribute of the organization's parent attribute. Correct me if I am wrong as I am trying to learn more - the ...

Sorry, I might not have explained the whole picture. The objective is to have a cascading filter from organization dim to program dim in a cube view in PAW. That's why I cannot understand your statement can't have a user pick an element from the "Organization" dimension --- because the sec...

I replaced CurrentMember with the element name and it works. But I need the element to be user selection, therefore CurrentMember should work right @Declanr? What is wrong with the syntax here? :? {TM1SubsetToSet ( [program], IIF ( STRTOMEMBER("[Organization].[" + [Organization].[OrgParent...

Hi Ascheevel, That's a good idea but I'm stubborn about getting it to work in MDX :lol: Hi Declanr, That's the correct understanding as I think I did mentioned in my original post stating 'trying to get the level attribute of the organization's parent (or something like that). As for the code sugges...

Hello there, I'm trying to do this - to get the parent of the organization and check the level attribute if it's equal to 'Level 0'. If yes, use Subset1, else Subset 2 TM1SubsetToSet([program], IIF([organization].[parent].[Level] = "Level 0" , "Subset1", "Subset2")) I t...