Dedicated reporting server?...

View previous topic View next topic Go down

Dedicated reporting server?...

Post  SuperPindos on Sun Jun 09, 2013 6:47 am

I am seeking advice. Consider: Distributed data warehouse, consisting of multiple dimensional marts, on multiple servers, Windows, MS SQL, Cisco net.
The largest mart is 300 GB, the smallest is 50 GB. Nightly ETL (Informatica), the availability SLA is 12x5, but it's more like 16x7.

Introducing SSRS/SSAS. There will be multiple "dashboards", with multiple reports, ROLAP and MOLAP cubes, etc.
Assuming these dashboards and cubes will be using/relying upon the data from multiple marts, do I build a dedicated "reporting" server to carry these dashboards and cubes, or do I deploy the dashboards on the same servers that the marts are on? I am leaning more toward the dedicate SSRS reporting server, but am far from certain I am doing the right thing.

What does everyone think?

SuperPindos

Posts : 1
Join date : 2013-06-09

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum