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

On point (1), you can use calculated cells instead of calculated
measures, if you need drill-through to work.

On point (2), the "relevant records" are all fact table records used to
compute a given cell. So, even if some records have null Passport field,
they are still aggregated to compute the "Count of People with
Passports". One solution is to set up a dimension on the Passport field
with 2 leaf values: Yes and No. Then drill-through with Passport
dimension sliced to "Yes" will filter correctly.


http://msdn.microsoft.com/library/de.../en-us/olapdma
d/agdrillthrough_8583.asp
By default, a drillthrough result set is derived from only the table
rows that were evaluated to calculate the value of the selected cube
cell.
...
Note Drillthrough is not supported for cells that have values based on
expressions such as calculated member cells or ones that are associated
with custom member formulas. This includes cells that display values for
the level members of a mining model dimension.
..

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Which product are you using?

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