TM1 Forum

Just an observation not sure it will help but you need a closing } to close out your Select NON Empty

Great idea @Marenc. That worked. Thank you so much.

Hi guys, I finally had the time to get back to this and getting close I think :) I have come up with this but not getting any elements. Can someone point out what's wrong with my syntax. Thank you STRTOMEMBER("[Periods].[" + [Periods].CURRENTMEMBER.NAME + " YTD]"), FILTER( TM1FIL...

Hey guys, I am back with more problems :(. I cant get that currentmember to resolve let alone add YTD to it. Any ideas on this one ? FILTER( TM1FILTERBYLEVEL(TM1SUBSETALL([Customers]), 0), ( ( [Client Selections].( STRTOMEMBER("[}Clients].[" + USERNAME + "]"), [MD_Selection].[Sup...

One last question and I promise this would be it. I think :) Is there a way concatenate YTD to the [Periods].CurrentMember. [Customer Summary].([Organizations].CurrentMember,[Periods].CurrentMember,[Regions].[99999],[Currency].[USD],[Customer Sources].[Total],[Versions].[Actual],[Customer Summary Me...

That worked beautifully. Thanks for pointing out the fact that I failed to encapsulate the second clause. Thank you Ardian. Much appreciated.

Thank you Wim. I have this so far and the suppression filter is not working. Its probably the Or/And combo but I cant pin point it. When I select False in the Client Selections cube I do not get all the level zero elements. FILTER(TM1FILTERBYLEVEL(TM1SUBSETALL([Customers]) , 0) , [Client Selections]...

Thanks for response @ardi. I appreciate it. Does it matter if the suppression flag is string. Like a True or False ?

Hello, I have a Customers dimension and I would like to create a subset on it to show All elements if a value in a 2 dimension control cube is false and show only customers that have data in the Customers cube if the value in the control cube says true. In the end I am trying to do zero suppression ...