Finding OLAP Pivot VisibleItemsList values

[100_Meridian]

Hello

I've been trying to solve his problem without any success. There appeared to be a similar issue posted back in September that was unsolved I believe.
http://www.excelforum.com/excel-prog...er-values.html

The pivot table I'm dealing with is linked to an SQL Server Analysis Service Cube. Many of the fields are dynamic in nature, such that I'd like to read the parameters to allow the users the ability to adjust filters while the resultant values can be utilized with getpivot formulas. It may seem backwards as the pivot table features allow users this ability. But given the other features of the workbook, knowing the visibleitemslist value is desirable.

This is what I'm dealing with;

Please Login or Register  to view this content.

What I need help with is;
1/ Usage of a dynamic array (as the VisibleItemList varies in size)
2/ Reading the VisibleItemsList parameters ID (204,207) and Name (Metric A, Metric B)
3/ writing the parameters into the array
4/ Setting the VisibleItemsList from a large array of 50-100 items


Thanks in advance for any assistance,
John
p.s. being my first post, please let me know if I've done anything wrong

[Jinkira]

Hi I am having a similar problem also with SSAS
have you resolved this at all

[kkode]

I'm facing the same problem. Did you find a solution to your problem?

Please post the solution. Thanks in advance.

[arlu1201]

kkode,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.