Programming Pivot Table Object connected to AS Cube

#1

Hi all,

Does anyone have an example of some VBA code that loops through the items on
the page axis and produces worksheets or charts for each sibling of the
current member? Any nested examples i.e. for each member in page 1 filter
loop through page 2 filter would also be great.

Thanks in advance!

Mark

#2

Hello Mark,
not an exact match, but near:

at
www.tomchester.net
you will find
mdx_applet.xls

HTH
Jörg

"Mark Frank" wrote:

Quote:

Hi all,

Does anyone have an example of some VBA code that loops through the items on
the page axis and produces worksheets or charts for each sibling of the
current member? Any nested examples i.e. for each member in page 1 filter
loop through page 2 filter would also be great.

Thanks in advance!

Mark

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Programming Pivot Table Object connected to AS Cube

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

Programming Pivot Table Object connected to AS Cube - 10-26-2004 , 03:39 PM

RE: Programming Pivot Table Object connected to AS Cube - 10-27-2004 , 08:15 AM