MDX help - counting tuples with a given member

• jm99

  SSCommitted

  Points: 1740

  More actions

  May 28, 2013 at 10:52 am

  #149824

  Is there a way, MDX, to count the number of tuples in a set that have a given member.

  For example

  { (a1, b1) , (a1, b2) , (a1, b3) , (a2, b1) }

  such that given member a1 would yield a count of 3 (the first three tuples in the set)

• 8reat1s

  SSChasing Mays

  Points: 616

  More actions

  May 29, 2013 at 9:45 pm

  #1619545

  try something like this

  SELECT NON EMPTY {[Measures].[b1/b2/b3]} ON 0,

  NON EMPTY {[a1].ALLMEMBERS)} ON 1

  FROM CUBE_NAME