Range from a Selected Parameter Till Last Item in the Same Level the Parameter was Selected in

{[Customer Geography].[!@param@1] : TAIL({ [Customer Geography].[!@param@1].LEVEL.MEMBERS},1).ITEM(0)}

Where [Customer Geography].[!@param@1] is your parameter

@param@ is the parameter name.


This can also work for any other hierarchy, for example dates.

Range from the selected parameter date till current date.

{[Date].[Month Dates].[!@param@!] : TAIL({[Date].[Month Dates].[!@param@!].LEVEL.MEMBERS},1).ITEM(0) }


range till last member in the same level.png (quick view)

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 6 yrs agoLast active
  • 695Views
  • 2 Following