List members in Dimension (Pivot table field)
 

I'm using Excel XP and Pivot tables as an OLAP front-end. I now want
to list all members in a specific Dimension (Pivot table field), and
finally add them to a Combo box. I think it's possible to do with DSO,
but is it possible to do it directly from the Pivot table?

Rickard

List members in Dimension (Pivot table field)
 

unless i'm confused..
drop de Dimension in the PageFields area and you should be ok..

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


(Rickard) wrote:

I'm using Excel XP and Pivot tables as an OLAP front-end. I now want
to list all members in a specific Dimension (Pivot table field), and
finally add them to a Combo box. I think it's possible to do with DSO,
but is it possible to do it directly from the Pivot table?

Rickard

List members in Dimension (Pivot table field)
 

Private Sub CommandButton2_Click()
Dim pvtItem As PivotItem

For Each pvtItem In Worksheets("Pivot1") _
.PivotTables("PivotTable1").PivotFields("Header1") _
.PivotItems
UserForm1.ComboBox1.AddItem pvtItem.Value
Next

End Sub


Works with a standard pivot table. You would have to check it with a pivot
table fed by an OLAP cube as the pivot table depends on the Cube to do a lot
of the processing.

--
Regards,
Tom Ogilvy



"Rickard" wrote in message
m...
I'm using Excel XP and Pivot tables as an OLAP front-end. I now want
to list all members in a specific Dimension (Pivot table field), and
finally add them to a Combo box. I think it's possible to do with DSO,
but is it possible to do it directly from the Pivot table?

Rickard