TM1 Forum

Hi, As Ellessar has said twice already, what you are trying to do will NOT work if both dimensions are dragged outside the cube view . I posted about this issue here, please read the whole thread: https://community.ibm.com/community/user/businessanalytics/communities/community-home/digestviewer/vie...

Is there any way to get that working? either by changing the MDX or changing something in PAW? No. Somebody has already asked this on IBM community forum: IBM said that when you drag filter to external widget, MDX becomes disconnected from view. Thank you for the quick response. i came across the f...

Wim Gielis wrote: ↑Fri Jan 21, 2022 12:28 pm Hello,

Please read this lengthy page on MDX:
https://www.wimgielis.com/tm1_mdxstatements_EN.htm

Thank you @Win Gielis, looks an amazing document. apologies for the late response.

Hi, what interface are you using? If it is tm1web, it will not work. such dynamic subsets work only when Year is in context and Employee is in rows/columns "Both dims in filters" will work only in PAW (until you drag them out of the view to external selector widget) Thank you for the resp...

First thing to do is correct the MDX - TM1SubsetBasis() is probably unknown in this context - typically added when recording MDX. Replace that with the [dim].[member] or set you are starting from and try again. Thanks for the response @gtonkin i have used the following MDX later on, but still the s...

Hi all, my first post here and kind of a newbie to TM1 PA. I have created a dynamic subset filtered attribute(YearNo attribute on Employee Dim, and attribute value is an element from other dimension (Year dimension). When i placed the Employee DIM as Row or column its working fine based on the Year ...