discogodfather
New Member
- Joined
- May 6, 2022
- Messages
- 1
Some colleagues of mine have an Excel plug-in that was custom-built by a software developer many years ago. That plug-in reads data from SSAS cubes and presents the results in Excel. The plug-in also allows the user to write data from an Excel spreadsheet into SSAS cubes as well. We're trying to find another software solution that can do the same thing; read data from and write data to SSAS cubes via Excel. I suspect Excel might be able to do this natively, but the user group in question is not technically oriented. Also, I've tried querying the cubes directly through Excel and the results would not return due to the volume of data in the cubes. Does anyone know if there are software options (Power or otherwise) that would meet our needs?