Hello,

I'm using AS2000 on SS2000 and Excel 2000 to create charts on my cubes via
PivotTables, as RS2000 can't make charts with a 2nd y-axis (thats what i
need).

For my design-chart-app, I'd like to read the members of a given dimension
and make them available for selection, in the same way Excel does itself in
the members treeview. But as I see things, this is not quite easy:

* The Pivotfield, Pivotitems and ChildItems-Properties don't work completely
when dealing with OLAP-sources. If my data were based on, say, a Access MDB,
my chart designer tool could read the items and offer them for selection. But
with OLAP, this is not the way to go...

* The Treeviewcontrol offers just the properties "Drilled" and "Hidden",
which expect Arrays of MDX-suitable member names. I can't just parse the tree
to read the hierarchy from top to bottom.

Any hints on how to "read" the dimension in Excel?

Thx
Martin