I have a process dimension that has 4 levels.

Process Level

Task Level

Status Level

Queue Level



Here is an example of the data:

Process A, Task A, Status A, Queue A

Process A, Task A, Status B, Queue A

Process A, Task A, Status C, Queue B

Is there a way to use the Distinct function in MDX to get a listing
like:

Queue A

Queue B

Instead of getting Queue A listed twice?



Thanks.

My first guess is, although i haven' t fully researched this, is no,
because MASA will look upon the two as being difefrent members.

Maybe you could consider putting the queue in a different dimension,
that would enable you to select just A.

Hope this helps,

GJ

Maybe the MDX Extract() function will meet your needs - it eliminates
duplicates in the result set:

http://msdn2.microsoft.com/en-us/library/ms145980.aspx

Returns a set of tuples from extracted dimension elements.
...
Remarks

The Extract function returns a set that consists of tuples from the
extracted Dimension_Expression elements. This function always removes
duplicate tuples.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***