MDX Question: Using Set and Tuple

#1

Hello,

I create in MDX query a Set named [Active]:
[Active] = {(a,1), (a,2), (b,2), (c,1), (d,3), (c,4), (b,1)} ([Active]
is a set of tuple)

How can I create a set [NoActive] that is first distinct item of each tuple
contained in [Active] set:
[NoActive] = {a, b, c, d}

Anyone can help me ?
Thanks

YD.

Usage:
WITH
SET [Active] AS '...'
SELECT { ... Measures ... } ON COLUMNS ,
{[NoActive]} ON ROWS
From [MyCube]

#2

Try:

set [No Active] as 'generate([Active],
{[Active].current.item(0)})

HTH,
Brian
www.geocities.com/brianaltmann/olap.html

Quote:

-----Original Message-----
Hello,

I create in MDX query a Set named [Active]:
[Active] = {(a,1), (a,2), (b,2), (c,1), (d,3), (c,4),
(b,1)} ([Active]
is a set of tuple)

How can I create a set [NoActive] that is first distinct
item of each tuple
contained in [Active] set:
[NoActive] = {a, b, c, d}

Anyone can help me ?
Thanks

YD.

Usage:
WITH
SET [Active] AS '...'
SELECT { ... Measures ... } ON COLUMNS ,
{[NoActive]} ON ROWS
From [MyCube]

.

#3

Thanks a lot.
Result is very good !

"Brian Altmann" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

Try:

set [No Active] as 'generate([Active],
{[Active].current.item(0)})

HTH,
Brian
www.geocities.com/brianaltmann/olap.html

-----Original Message-----
Hello,

I create in MDX query a Set named [Active]:
[Active] = {(a,1), (a,2), (b,2), (c,1), (d,3), (c,4),
(b,1)} ([Active]
is a set of tuple)

How can I create a set [NoActive] that is first distinct
item of each tuple
contained in [Active] set:
[NoActive] = {a, b, c, d}

Anyone can help me ?
Thanks

YD.

Usage:
WITH
SET [Active] AS '...'
SELECT { ... Measures ... } ON COLUMNS ,
{[NoActive]} ON ROWS
From [MyCube]

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

MDX Question: Using Set and Tuple

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

MDX Question: Using Set and Tuple - 10-21-2003 , 09:02 AM

MDX Question: Using Set and Tuple - 10-21-2003 , 09:38 AM

Re: MDX Question: Using Set and Tuple - 10-21-2003 , 11:18 AM