MDX - TOP 10 Dynamic

• demitri_baran

  SSC-Addicted

  Points: 423

  More actions

  May 19, 2010 at 3:40 am

  #224791

  Hi All,

  TOPCOUNT(

  [Person Beneficiary].[Person ID].MEMBERS,

  10,

  [Measures].[Average Approved per Claim]

  )

  I would like re-write this mdx statement to work against any other measure picked.

  My target is one Top 10 MDX statement for all measures

  Thanks

• sanjay.patel 30254

  SSC Enthusiast

  Points: 101

  More actions

  October 26, 2011 at 2:36 am

  #1399445

  TOPCOUNT(

  [Person Beneficiary].[Person ID].MEMBERS,

  10,

  [Measures].currentmember

  )