Issue with OBIEE 22.214.171.124.0 . Analysis outputs 570 records. Export to csv shows more than 570 rows ( actual 593 rows) . Also, the order of columns in csv is different from what's displayed in BI Answers .
Export to CSV is what you have in criteria and export to excel/pdf is from the view you created. So if you are in need of exporting the view (ie the data which is there in the view) use Excel. Whenever you need whole data from the criteria you can use CSV.