Reporting against a cube -- where to find / how to build one?

Question

Reporting against a cube -- where to find / how to build one?

pietlinden

SSC Guru

Points: 63503
More actions
October 1, 2014 at 5:11 pm

#311508

Is there any alternative to building your own SSAS cubes to report against? I would have sworn that SSAS creates an object that can be reported on using SSRS... but I'm not sure where to find such a thing.
If I have no option but to build my own, are there tutorials for 2012 around somewhere? I did find Ray Barley's on 2008, but 2012 is a little different.
Thanks!
Pieter

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

I'm not sure what you mean.

In Reporting Services, you can create a connection to an Analysis Services cube stored on an SSAS server. This means of course you need to have a cube deployed and processed on an SSAS server.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

pietlinden SSC Guru Points: 63503 More actions · Answer 2

Guess I have to learn how to build a cube... oh well.

Alan Burstein SSC Guru Points: 61141 More actions · Answer 3

pietlinden (10/1/2014)
Is there any alternative to building your own SSAS cubes to report against? I would have sworn that SSAS creates an object that can be reported on using SSRS... but I'm not sure where to find such a thing.

I'm not sure what you are asking either... In SQL Server 2012 SSAS has three deployment modes:

(1) multidimensional, this allows you to build cubes

(2) PowerPivot, this allows you to create "workbooks"

(3) Tablular, for tabular databases

Depending on what you need you can build SSRS reports right from your data warehouse, no SSAS required.

If I have no option but to build my own, are there tutorials for 2012 around somewhere? I did find Ray Barley's on 2008, but 2012 is a little different.

I wish SQLServerCentral had a "Stairway to SSAS". (hint, hint)

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

Alan Burstein SSC Guru Points: 61141 More actions · Answer 4