Hi All,

I have used Distinct function in my mdx query to avoid duplicate
values.

I want to know what performance effect it will have on execution of
query.

With large volume of data query is taking more time to execute with
Distinct function. If we remove it it is taking less time.

Any inputs is appreciated.

Raghu

do you use AS2000 or 2005?

the distinct function is one of the functions which greatly impact the
performance.

do you use it to count the number of distinct values?
or do you use it to list a set of non duplicated members?

"Raghu" <raghubd (AT) gmail (DOT) com> wrote

I use AS2000.

It is used to get a set of non duplicated members.

Jéjé,

In one forum I read, before accessing the cell values AS engine removes
duplicates first if it is placed on the axis of SELECT query. In my
case it is applied on the axis of SELECT query.

You mentioned that it greatly affects the performance of the query.
Where Distinct will affect?

1. While fetching set of non duplicated members. or
2. While fetching cell values.

Raghu

Jéjé wrote: