question

SteveO avatar image
SteveO asked

Use SSRS with SAS Cube?

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).
excelssrs-2008-r2cubes
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered
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. https://www.youtube.com/watch?v=o2N3ZCinpPs Hope that helps.
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks - but I am not talking about a SSAS data source. SAS is a statistical language that has been around since the 70's. It can create regular datasets and OLAP datasets - but they are not SQLServer objects. I guess the real question is if SSRS can consume a cube from any other database besides SQLServer. EXCEL can use SAS drivers to make connections directly to the SAS OLAP cube. I am wondering if SSRS can do the same thing.
0 Likes 0 ·
Ah, my apologies. I mis-read the last line in your question. My fault. Sorry about that. This link might provide some insight. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b804109d-c882-4875-8ff1-0a8027e4c6ce/connect-from-ssrs-to-sas?forum=sqlreportingservices
0 Likes 0 ·
We're getting closer! The link you provided shows how to access a regular SAS dataset in SSRS. We've already accomplished that, but now we want to consume a SAS OLAP cube. So far, no luck with that.
0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.