Condition in Drillthrough action

• Raj-115466

  SSC Journeyman

  Points: 77

  More actions

  August 24, 2010 at 6:06 am

  #225179

  I have a cube with 2 measures

  ActivityCount | MissingGender

  10 | 2

  At backend in fact table it goes like this

  ActivityCount | MissingGender

  1 | 0

  1 | 0

  1 | 1

  1 | 0

  1 | 0

  1 | 0

  1 | 0

  1 | 0

  1 | 0

  1 | 1

  When Drillthrough action defined and used in browser for "ActicityCount" it gives 10 rows back, but, for "MissingGender" it also gives 10 rows, how can I limit it to show on 2 rows where gender is missing?

  Is it possible to do it without adding any dimentional filter?

  Is it possible to do it wtihout creating a seperate fact table / view for the measure "Missing Gender"?

  Thanks

• sheila.etcuban

  Newbie

  Points: 7

  More actions

  October 1, 2012 at 6:31 am

  #1543947

  We have the same problem. I have been trying to look for a solution. My drillthough is giving me everything when for example i am only expecting 2 lines/ rows.

  Can someone help please???

  thanks!