Hi,

I want to get distinct values only during a drillthrough command.

Currently the drill command return all rows behind the cube.
But I want to retrieve only particular information like customer name(s)
instead-of customer name + sales list.

thanks.

Jerome.

In AS2k I don't think there is any way of doing this with drillthrough.
Have you had a look at actions? You might be able to set up a URL action
that would hit a web page that could return the results you are looking
for.

In AS2k5 you might be able to achieve this using an alternate measure
group with the distinct values (maybe based on a view)

see the following:

http://msdn.microsoft.com/library/de...l=/library/en-
us/dnsql90/html/sql2k5_anservdrill.asp

Although you may also be able to make use of attributes in you
dimensions in AS2k5.


--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell

It's doable if you modify the drillthrough.htc file that comes with BI
Portal.
HTH

Pablo Mugica


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

just more info...
I'm using Excel.
does it possible to modify the MQX query to add a "Select distinct"
anywhere???
I don't want to load the entire result in memory then create a new dataset
with only distinct values...

Modifying the .htc... ok, good idea... but to change what?
I don't see any option in the MDX statement.

"Pablo Mugica" <PSM@x.com> wrote

More info from me too. This is just a workaround.
I didn't find a way to do this with MDX, just filter the resultant
recordset.
HTH

Pablo Mugica

"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote