since cubes are not supported by sql azure reporting services, does it not limit reporting functionailty?

Question

running reports just against sql azure data source limit what we can do with reporting services? Is there documents that could compare reporting vs data source. And reporting vs cubes? thank you a lot

Answer 1

SQL Azure Reporting Services is still in Preview mode and here's a list of limitations compared to SSRS:

http://msdn.microsoft.com/en-us/library/windowsazure/gg430132.aspx

what sort of comparison are you looking at? a report with OLTP as data source vs a report with OLAP as a data source?

Answer 2

Yes please: comparison a report with OLTP as data source vs a report with OLAP as a data source

Answer 3

Hi PowerPivotQ,

SQL Azure Reporting Services only supports SQL Azure databases as data source currently, so you can't retrieve data for SQL Azure Reporting report from your OLAP as its data source. You can vote about Adding the feature of "Include Analysis Services in SQL Azure"

http://www.mygreatwindowsazureidea.com/forums/34685-sql-azure-feature-voting/suggestions/413063-include-analysis-services-in-sql-azure

Thanks for your understanding.

---

Challen Fu

TechNet Community Support

Answer 4

Thank you to JuneT and Challen Fu.