OLAP MDX: SetToArray function and members: how to use? -
01-05-2004
, 08:30 AM
Subject: OLAP MDX: SetToArray function and members: how to use?
Hi all,
Products:
Server:Microsoft SQLServer 2000 SP3a Analysis Services.
Client: OLE-DB for OLAP driver as included in the MDAC V2.8 package.
We have a question about the OLAP MDX SetToArray() function:
how can we to store the ***members*** in an Array using this function?
Your advise if greatly appreciated.
P.S.: Georges Spofford's book on MDX Solutions says "SetToArray (...) will in fact
create sets of strings as well, which makes it useful for scanning sets of
member names and property values as well as for processing a set of
numbers." (p.166)
Please advise.
Season's Greetings
Rolf H. |