1. Why is drill-through not possible on calculated measures?

2. In a cube, I have measures; Count, Count of People with Passports.
Count of People with Passports is defined as the count of records with
a non-null PASSPORT field.
In Analysis Manager, when I display Measures against another
dimension, say Location, I get 2 columns for the above measures.
When I invoke drill-through on the intersection of Count and
Location='All Location', I see all the records from the fact table.
When I invoke drill-through on the intersection of Count of People
with Passports and Location='All Location', I again see all the
records from the fact table, even if the records are marked as without
passports.
Does this mean that the drill-through mechanism is unable to show
precisely the relevant records?

-Yash

Which product are you using?

"Yash" <yashgt (AT) yahoo (DOT) com> wrote