Extracting Connection Information from Pivot Tables

It's pretty easy to add pivot tables to worksheets - even easier to add them when the source is a cube. However there are a couple of ways to go about adding them which could make your life easier - that's one of the things we look at in this post. When you first create a connection to an OLAP source (and I am including tabular in that), a connection is created in the work book. So just for fun, let's go through the process and connect to the cube. On the Data tab chose From Analysis Services from the Other Sources dropdown.