Apart from decks, kpi and dashboard, can a report be generated in Oracle Fusion Analytics Warehouse?
Yes, you can. Please refer :
Create a Workbook and Add Visualizations
https://docs.oracle.com/en/cloud/saas/analytics/22r2/fawug/create-workbook-and-add-visualizations-fawug.html#GUID-42D0523D-F937-423A-A1FE-983FC34DDF51
It really depends on what you mean by a report. The OAC component of FAW has the classic part for analyses and dashboards; Oracle Analytics Publisher is used for pixel perfect reporting and Data Visualisation is used for creating self serve workbooks. FAW should allow you to do all the above.
