Home
Kimball Group Home
Search
Register
Log inDedicated reporting server?...
Page 1 of 1
Dedicated reporting server?...
SuperPindos 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?
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
Similar topics» Any Benefit to Defining Foreign Keys in SQL Server without enforcing foreign key constraint in SQL Server
» Reporting on SCD
» Financial Reporting and the DW
» Operational Reporting
» ETL and Reporting Tool
» Reporting on SCD
» Financial Reporting and the DW
» Operational Reporting
» ETL and Reporting Tool
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum