How to extract distinct data from a cube ?

[IsBo]

Hi all,

Environment :
SQL Server 2000

I have a cube in with data are not distincted. And I want to extract disctincted data to insert them into a new cube.
The function Distinct has no effect in the MDX query.

So it will be helpful to have some ways of solution.
If you have any information about this, thanks in advance to send me an email.

Example of MDX query
SELECT
NON EMPTY Distinct([Server].members) on rows,
NON EMPTY Distinct([[UserLogin].members) on columns
FROM myCube
WHERE ([Date].[year].[Month].[Day])

Regards,
Isa.