list of all cubemembers

[Guest]

Hi there -
How can I get a list of all cubemembers from a given connection? I am using
Excel 2007 and have a connection to an OLAP cube.
Thx
- Kai

 

[Guest]

Not too sure what you mean by cube memebers (pivot items prehaps?) but here
is a good link to VBA code for pivot tables...

http://www.contextures.com/

 

[Guest]

http://msdn2.microsoft.com/en-us/library/aa139932(office.10).aspx

Look at Table 6.2

You want to use the ADOX library.