Cube/Web Page Interaction...

[rheilman]

I'm not sure where to post this. It crosses several specific forum areas.

I have an OLAP Cube that feeds an Excel Pivot Table and Pivot Chart. The Excel file has been published as a web page. In an effort to make the interface more user-friendly, I would like to put controls on the web page to manipulate the Pivot Table and Pivot Chart, suppressing data within a user specified date range.

The page's source code makes reference to <OBJECT></OBJECT>'s representing the Pivot Table and Pivot Chart. Rather than parsing HTML code and generating new source, I'm looking for a way to address the objects, and manipulate the data filtering using properties of these objects. The objects represented, do maintain a link back to the OLAP Cube data.

I'd appreciate, even, direction to a source for such information. Thanks.

Ray <><

"I was going to change my shirt, but I changed my mind instead." - Winnie the Pooh

 

[rheilman]

From another source...I'm trying to hit the PivotTable and PivotChart objects through their Office Web Components ID's using JavaScript.

My apologies for the location of this post!
Ray <><

"I was going to change my shirt, but I changed my mind instead." - Winnie the Pooh