We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Support for SSAS data sources and Cube formulas

Hi,

I need to open a bunch of excel files which have data connections to a Sql Server Analysis Services cube, and use Cube formulas to put data into cells. I have tried opening these in the latest version of Aspose, refreshing pivot tables, recalculating formulas, then streaming to a browser. Unfortunately I get errors from Aspose saying type of connection not supported, and cube formulas not recognised. Does Aspose have plans to add support for SSAS data connections and cube formulas in a future release?

Thanks,

Marcus

@marcus.scholz,

Thanks for your query.

I am afraid, currently, Aspose.Cells does not support interacting pivot tables and slicers with OLAP data source. A ticket is already logged with an id “CELLSNET-47280” for your demanded feature. We have no plans to implement it in near future.

Once we have an update on it, we will let you know.