Hi chandu_shekar,
Generally, one very important setting with regards to Cube View performance is the "Allow Sparse Row Suppression" that should be set to True both on the General Settings and the appropriate Columns (together with the "Use To Determine Row Suppression" setting).
However, reading your post (and without knowing your data model, data volumns, etc.) it sounds like this might be classed more like a data dump than an actual report. If your goal is to export this data to a .csv file for reconciliation or other purposes you might want to consider using a DM job with a Export Data Step instead.