TM1 Forum

In tm1, is this possible to write a mdx subset using where clause between two different dimensions?

Hi All: Could you please do needful if it is possible solution or not? A Cube: below dimensions BU Index summary dpt PY scenario version measures (these five elements are expenses,resource,band,key goals,layer with picklist. for these measures users are mapping through template. these five elements ...

Hi Wim Gielis, could you please do needful if this it is correct? I tired various options but didnot work. could you please some light on it. =TM1RPTROW($B$9,"PLANNING:OUTLETS","","","Alias",0,"{FILTER({FILTER({FILTER({TM1FILTERBYLEVEL({TM1DRILLDOWNMEMBER...

Thank you burnstripe. it was typo while I am typing it. do you have any suggestions how to call the subnm function selection (user selection) in the mdx in below bolded syntax? =TM1RPTROW($B$9,"PLANNING:OUTLETS","","","Alias",0,"{FILTER({FILTER({FILTER({T...

Thanks gtonkin. I figured out the issue. I added the "s" in TRANE (make unique Trane attribute) because I have one of the dimension name is TRANE and my attribute name is TRANE in the OUTLETS dimension. so renamed the attribute name to OUTLET dimension as TRANEs then it worked. =TM1RPTROW(...

Dear All: Immediate help is really appreciated. kindly assist me if it is correct mdx or not. I have active form input template where I filter using MDX to show the Outlets that outlets are active, no rule applied OUTLETS using the TM1RPTROW which is perfectly working. but I am adding the one filter...