I want my users to drill through on the measure cell in
the cube to get the detail info that got that count.

Here is what I did,
In the cube editor i selected the columns that needs to
be seen in the drill through option. When I double click
the cell it shows me the records but those records are
not distinct. Is it possible to select distinct records
in the filter tab of drill through option in the cube
editor?

Hi Usha,
By default, cubes do not allow drillthrough operations.
This is because, it can be a very resource-intense
process, perhaps trying to retrive millions of rows of
source date. To enable drillthrough, we must use the Cube
Editor.

1) Right click on the cude and select Edit.
2) Select Tools --> Drillthrough Options
3) Check the Enable drillthrough box.
4) Select the columns that should be shown to the end
user.
5) Click OK to save the drillthrough options and return
to Cube Editor.
6) Select File --> Save and then close Cube Editor.
7) Right click the cube and choose Browse-Data.

Hope it helps.

Please read again my original post.
You have explained the steps that I am already doing.
What I want is beyond that. In the drillthrough option is
there a way to select distinct records. I know you can
filter it by giving some conditions but selecting
distinct records is it possible?
Here is the scenario, I have measure like Count. When I
drillthrough it should show me the count of records that
got that count for the measure for ex. if my count=100
then when I drill through it should show me 100 records
but it shows more that that.
Can anybody expalin why it is doing so?

Thanks,



Whatever you have indicated for drillthrough I am doing