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.