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 to see the selected items, but I was wanting to get at it through the object model.
I have looked at CurrentPageList and VisibleItemsList, but they both return an application error when there is a multiple select.
Anyone know how to do it?
TIA
Bob
[Windows XP Pro SP3, SQL Server 2008, Excel 2007 SP2]
Getting Multiple Items From Pivotable
-
- Posts: 1
- Joined: Tue Dec 29, 2009 11:32 pm
- OLAP Product: MS Analysis Services
- Version: SQL Server 2008
- Excel Version: Excel 2007