MDX-create a parameter against a measure

• sdugan 46791

  Newbie

  Points: 1

  More actions

  February 12, 2015 at 12:51 pm

  #297657

  I need to create a parameter in SSRS against a cube using a measure instead of a dimension.

  This is the set I have created. This works fine as is, however, the business users need to be able to type in the amount. Instead of 750000, they may want to see anything greater than 150000. I can't find anyway to do this. Is this possible?

  set

  [PoliciesOver] as exists(filter({[Product].[Policy].[Policy]},[Measures].[Total Coll Prem] >=750000))

  Thanks