Skip to main content
Version: I2022.3.0

Using AtScale with Microsoft Excel on Windows

This section explains how to connect to a published AtScale cube from Microsoft Excel on Windows.

note

Note: Microsoft Excel on Mac OS X does not have an embedded driver for Microsoft SQL Server Analysis Services. The instructions in this section are for Microsoft Excel on Windows only.

  • Create a New Connection in Excel You connect to AtScale from Excel as though you are connecting to a Microsoft SQL Server Analysis Services (MSSAS) cube. Once you have connected to an AtScale cube, you can build a PivotTable report from fields in the cube.
  • Excel Tips and Limitations When building a PivotTable report in Excel using data in an AtScale cube, there are a few things you can do in Excel and/or AtScale to improve the experience.
  • Using CUBE functions CUBE functions in Excel allow you to extract individual cells from an OLAP cube. Here you can find which CUBE functions can be used when you connect to AtScale from Excel.