Configuring SAS ROLAP – Solving Excel Pivot Size Issues

Had some issues with users using the SAS Addin for Microsoft Office against Info Maps where the size of the Excel file gets massive when you save it.

It seems Excel must be caching the data somewhere.

We are working on configuring SAS OLAP cubes in ROLAP mode as this removes the size issues with Excel.