Working with an OLAPQuery Offline

To view, plot, and work with an OLAPQuery offline, download the data set to an OLAPResults section within the document. Once downloaded, the data can be integrated with the Chart, Table, and other reporting sections. If you need to modify the query, reconnect to the database and apply any necessary changes.

  To download the OLAPQuery data set, select OLAP, then Download to Results.

An OLAPResults section is created for the query. You can use the OLAPResults data set to insert a new chart, pivot, or other report.