Condition in Drillthrough action

  • 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

  • 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!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply