OWC 10 (Pivot table )HELPPPP Please.......

[visakasi]

Hi All,



I have a problem with OWC 10.We are using pivot table 10.0 ,data source
control 10.0.We are populating data from cubes thru' data source control
and showing it in IE browser thru' Pivot table.



When i try to access the pivot column members (we use client side VB
scripts to access pivot table) with some code say



msgbox ptable.ActiveData.ColumnMembers.Item(0).Value



i get a runtime error like "Unexpected Call to method or Property
Access".

Actually we are migrating from OWC 9 to OWC 10.The same code works well
with OWC 9 but not in OWC 10.Do i need to set any pivot table property
to access the column members or is there any change in OWC 10.



the ptable.activadata object is not working at all.



The Sample code is as follows.



Sub LoadFilterLists(ptable, cboField, cboMember, cboTotal)

Dim opt 'Temp HTML <option> element

Dim fset 'Temp PivotFieldset reference

Dim fld 'Temp PivotField reference

Dim member 'Temp PivotMember Field reference

Dim ttl 'Temp PivotTotal reference

Dim ct 'Temp loop counter

Dim pview 'Temp PivotView reference





'*************



For Each member In ptable.ActiveData.ColumnMembers

Set opt = document.createElement("OPTION")

opt.Text = GetFilterCaption(member.UniqueName)

opt.Value = member.UniqueName

cboMember.options.add opt

Next



'*********************





Can somebody throw some light on this ?? I am literally fighting with
this for more than a week!!!! :-(



Any help is greatly appreciated.

 

[Chavi]

Hi



I do not have OWC 10 version ... but i guess i can help you out with
some of my experiences.



What u do is ... embed Pivot Table to visual basic form and connect the
same way you connect from the web page.



The advantage u have in Visual basic is the "Add Watch" feature.



Add a command button and put this piece of code

+++++++++

msgbox PivotTable1.Name

+++++++++

and set a break point to this line



when u execute and click the button ... the line of execution will wait
at this point ...



Now highlight only the "Pivottable1" and right click and select
"Add Watch"



now in the watch window u should be able to see the PivotTable1 object
with the "+" sign prefixed to it ...



now just expand it and look thru where u can find the cell data ...



Hope it helps u ...



Chavi

 

[Dan Ricker]

For OWC10 use:

PivotTable1.ActiveData.ColumnAxis.Member.ChildMembers
(0).Value