Home › Forums › SpreadsheetML › Adding a PivotTable using data connection to a OLAP Cube
Tagged: #OLAP #PivotTable #OpenXml
This topic contains 5 replies, has 3 voices, and was last updated by 
I haven’t seen much useful traffic on here recently. I have not connected to OLAP with OpenXML and cannot help except to tell you to look elsewhere.
Thanks, Jim, for reply.
And that’s the other thing: where else do you see more active discussion/help? I did some extensive search and much to my disappointment, and more accurately, to my shock: this is very essential thing and no single sample can be found, and official doc from Microsoft is just a simple syntax/semantic explanation of various objects, without connecting dots…
There have been some active threads at StackOverflow and CodeProject. Neither has a forum, but searching for OpenXML will pull up a few.
Thanks again. Just checked out both sites and StackOverflow has a little more recent questions related to OpenXml Pivot Table but not much discussion/answering. Will check that anyway as one can also find something from questions or posted code.
Regarding my original question, I re-watched the video from Bob/Eric, and found the root cause: mishandled relationship id when adding pivot cache entry to the workbook Xml file, partly due to the fact I didn’t know there are multiple .rel files related to a document/package (under the parent node, like a workbook or worksheet).
Here’s how to create a PivotTable by using an existing external data connection:
Click any cell on the worksheet.
Click Insert > PivotTable.
In the Create PivotTable dialog box, under Choose the data that you want to analyze, click Use an external data source.
Click Choose Connection.
You must be logged in to reply to this topic.
