Build an MDX string

#1

Anyone ever taken a list of 400 random member keys and built a set out of it?

Example:

set Target as '([1],[2],[3],[4],[5]...[400])'

Any ideas?

Jim

#2

Does it mean From-To? If then,

SET Target AS '{[1]:[400]}'

If not and no family member to refer them, you have to decribe every member
respectively.

Ohjoo Kwon

"Jim_OLAP" <JimOLAP (AT) discussions (DOT) microsoft.com> wrote

Quote:

Anyone ever taken a list of 400 random member keys and built a set out of
it?

Example:

set Target as '([1],[2],[3],[4],[5]...[400])'

Any ideas?

Jim

#3

You can possibly use the Generate() function. It works like "For" loop if
you iterating over each individual member can get you the results you need.

"Ohjoo Kwon" wrote:

Quote:

Does it mean From-To? If then,

SET Target AS '{[1]:[400]}'

If not and no family member to refer them, you have to decribe every member
respectively.

Ohjoo Kwon

"Jim_OLAP" <JimOLAP (AT) discussions (DOT) microsoft.com> wrote in message
news:464095AD-5ADB-4B62-BB23-CEBA51C969F7 (AT) microsoft (DOT) com...
Anyone ever taken a list of 400 random member keys and built a set out of
it?

Example:

set Target as '([1],[2],[3],[4],[5]...[400])'

Any ideas?

Jim

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

Build an MDX string

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

Build an MDX string - 03-04-2005 , 01:01 PM

Re: Build an MDX string - 03-04-2005 , 05:48 PM

Re: Build an MDX string - 03-07-2005 , 07:41 AM