I am trying to export data in cube to local directory in Excel spreadsheet or .CSV format. The cube contains close to one million records. Is there any best way to export the data. Is there any limit on number of records in csv format
In cube manage, in menu i see export spreadsheet option. But i think it will limit to 65535. I am trying to export in batches.
Is there any best way so that I can export as many records as possible?