Get list of field members OWC PivotList 10.0

[Michael Weiss]

I am using a OWC Pivot Table component (v10.0) on a web
page. I need to pull a list of members(?) from a field
object. Specifically, I have an OLAP cube as a source for
my pivot table and that cube has a dimension called
[Region Customers]. In that dimension, I have two levels -
(1)Regions and (2) Customer. I am loading this dimension
as a fieldset onto the pivot table row axis. When
accessing the members in the Regions level, I use the
following code to load the option selections in a select
list on a web page and it works just fine:
set fsRegions = pview.fieldsets("Region Customers")
set mems = fsRegions.members
for mem = 0 to mems.count -1
set opt = document.createElement("OPTION")
opt.Text = mems(mem).Caption
opt.Value = mems(mem).name
cbxDim1.options.add opt
next

I am having a real issue however with accessing the
members under the Customer level. The following code
allows me to point to the Customers level without error...
set fsCustomers = pview.fieldsets("Region
Customers").fields("Cust Name")

however, I can not tell from either the documentation or
experimentation, what the collection of members under the
Customers level is called.

Can anyone point me in the right direction here?
Thank you in advance,
Michael

 

[michael weiss]

I figured it out...here is the code I used to get the
list of customer members under the customer field of the
Region Customers fieldset:
'do cbxDim2:
set fsCustomers = pview.fieldsets("Region
Customers").member.childmembers
'pview.rowaxis.label.visible = false
set mems = fsCustomers
'msgbox mems.count
for mem = 0 to mems.count - 1
for child = 0 to mems(mem).childmembers.count - 1
set opt = document.createElement("OPTION")
opt.Text = mems(mem).childmembers(child).Caption
opt.Value = mems(mem).childmembers(child).name
cbxDim2.options.add opt
next
next

Many thanks though to all who may have given this some
thought...
michael