Link to home
Start Free TrialLog in
Avatar of Bodhi108
Bodhi108

asked on

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.
SOLUTION
Avatar of Tony303
Tony303
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial