SSAS - Why is it a good idea to run reports against the cube vs the data warehouse?
I am trying to convince our reporting person to run all reports against the cube instead of the warehouse. I have come up with 3 reasons why all reports should go against the cube. Please let me know your thoughts on this matter.
Do you run SSRS against the cube or the Data Warehouse and why?
These are my reasons:
1) The data warehouse might be changed during the day due to ETL or other processes running so the data may not be insync and the reporting may be incorrect.
2) The reports will run slower since the cube has been designed to be very quick access for reporting.
3) It may slow down any processes we have running when there are reports running against it causing locking issues.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.