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).

more ▼

asked Aug 10, 2015 at 07:50 PM in Default

avatar image

1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Aug 10, 2015 at 08:11 PM

avatar image

14.2k 3 7 14

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.

Aug 10, 2015 at 08:17 PM SteveO

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

Aug 10, 2015 at 08:22 PM JohnM

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.

Aug 10, 2015 at 08:31 PM SteveO

So at this point, I'm going to stop looking because I apparently can't read things today. ;-)

Aug 10, 2015 at 08:52 PM JohnM
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 10, 2015 at 07:50 PM

Seen: 220 times

Last Updated: Aug 10, 2015 at 08:52 PM

Copyright 2018 Redgate Software. Privacy Policy