This project has moved. For the latest updates, please go here.

Setting MDX - Possible in VSTO or.NET?

Topics: Resolved
May 19, 2009 at 4:26 PM

I was trying to set MDx using VBA, and I was wondering if it was possible VSTO.

Coordinator
May 19, 2009 at 5:09 PM

I believe that property is read-only. So it's not possible. You have to interact with PivotField objects and such to manipulate what's in a PivotTable.

Marked as answer by furmangg on 6/10/2014 at 3:54 AM
Coordinator
Apr 4, 2011 at 9:22 PM

One workaround is to use a QueryTable to run any MDX query you want. Chris Webb blogged about this here:
http://cwebbbi.wordpress.com/2009/12/18/binding-an-excel-table-to-the-results-of-an-mdx-query/

Marked as answer by furmangg on 6/10/2014 at 3:54 AM