My company has created a SAS cube and successfully connected to it using EXCEL. Now they want to know if SSRS can use the same cube. Is this possible? They do not want to create a new cube in SQLServer (or SSAS).
asked Aug 10, 2015 at 07:50 PM in Default
This article from MSSQLTips says that you can. https://www.mssqltips.com/sqlservertip/2704/developing-a-ssrs-report-using-a-ssas-data-source/
The article doesn't state what version they are using so your mileage may vary with 2008 R2.
Also found this YouTube video that has a demo with 2008 r2 and an SSAS cube.
Hope that helps.
answered Aug 10, 2015 at 08:11 PM