OLAP Online - Pivot Table Object and DrillThrough [Archive]

Erika

08-01-02, 12:54

Okay,

I have an ActiveX Pivottable control on my site, with an OLAP datasource. Its all working beautifully - except my next hurdle is creating a drillthrough option that mimics the drillthrough functionality of the Cube Browser in Analysis Services. :eek:

I'm scripting in javascript, on a .NET platform for this page of the application. I'm completely stuck at this point. I cannot seem to get anything to work when trying to return ANYTHING from a selected pivot cell.

PivotTable.ActiveObject.Value = returns null even when cell is selected

I've tried other objects and collections such as PivotAggregates, PivotData, etc. etc. etc.

Can someone point me in the right direction for help here? Anyone ever done this?

Thanks,

Erika

salman128

10-31-02, 11:42

Have you tried using PivotTable1.Selection? I am not sure what the syntax in JavaScript is, but in VBScript, you can use TypeName PivotTable1.Selection to figure out the type and you can obtain a pointer to the object using set Obj=PivotTable1.Selection