TM1 Forum

Also i would not like to use TM1RPTFILTER function since the MDX which i am trying to implement is pretty complex (different from the one posted), i am just trying with simple MDX first and would replace once i get to know exactly on how i could use the parameter.

Thanks all for your response!

The stray bracket was just a typo error while posting the request. Since a formula in excel cannot exceed 255 characters i cannot include the MDX directly in the TM1RPTROW function.

Hi All, I need help to pass a parameter to MDX query in Active Form. =TM1RPTROW($B$9,"abc_tm1:Customer",,,,,$H$2) Under H2 cell of the sheet i have the below MDX. { ORDER( {TOPCOUNT( {FILTER( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Customer] )}, 1)}, [Customer].[IncludeInTop] = "Include&qu...