dbTalk Databases Forums  

OLAP MDX: SetToArray function and members: how to use?

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


Discuss OLAP MDX: SetToArray function and members: how to use? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ralpghtf
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.