Search found 1 match
- Tue Dec 29, 2009 11:39 pm
- Forum: MS Analysis Services
- Topic: Getting Multiple Items From Pivotable
- Replies: 0
- Views: 46797
Getting Multiple Items From Pivotable
Hi, I have a pivotable connected to an AS OLAP cube, and it consists of 3 page fields. When the first of these fields has a multiple selection, I want to be able to get an array of those selected items, in VBA in Excel 2007. I know that I can use CUBESET, CUBESETCOUNT and CUBERANKEDMEMBER functions ...