qfKI : Hi, Yes that is possible. Below steps would help:
-- Login to SC/Omniture and navigate to Tools-->>Data Warehouse
-- You would see an option Request Manager at the top just below the header "Data Warehouse"
-- Once on request manager, search for your reports by report name or login
-- The status would be on the reports with the details. Click on hyperlink on Report Name
-- You would be able to see error for the report over there
p.s. Screen Shots as attached
Common Errors: FTP details incorrect, sFTP instead of FTP, segment applied incompatible with DW, issue while processing data.